database array

[jvolden]

I have a field in my database that holds an array. I want to pull the last value of that array out of the database and use it in a report. Someone had suggested a custom ODBC driver. I'm am completly clueless on this one. Any suggestions?
Thank you!

 

[BlurredVision]

What does the array look like?

Could do something like this:

Right ({yourfield},8)

 

[lbass]

If you know what divides the elements of the array, you could use a formula like the following, where "," is the divider for a string like "AB,15,16,xz":

split({table.string},",")[ubound(split({table.string},","))]

-LB

 

[jvolden]

Thank you for your help. The field looks like this: Assignment was changed from \"ENTERPRISE ADMIN\" to \"IT SYSTEMS SUPPORT\" by. This is repeated many times in the field, once for easch queue change, and I have left some information in the field out. How can I split at the '"' ? I know how to place qoutes inside qoutes in other languages (PERL " \" ") but am unsure how to split at the qoute in crystal.
({table.string},"""))] does not work or any other syntax I have tried.

 

[lbass]

Try:

split({table.string},'"')[ubound(split({table.string],'"'))]
//single quote-double quote-single quote

This tests out here.

-LB

 

[jvolden]

That worked out great. Thank you for your help!