Dynamic String Parsing

[jlopeman]

Good morning,

Using Crystal XI and MS SQL 2008R2 database, I'm trying to parse a string that's basically a condition stored in the database. Here's and example of the format of the string:

{dbTable.dbField}="some medication name" & {dbTable.dbField}="some medication strength" & {dbTable.dbField ="some boolean condition"

I've created a formula to parse out the medication name, which is what I want the results to be:

WhilePrintingRecords;
Mid({string}, InStr({string},'"'), Instr({string},'"'))

This kind of works for the first medication listed, but the formula seems to be cutting off the med. names that are longer, or returning too much of the string.

I need to capture whatever is inside of the first set of quotes, regardless of the length of that substring. Then, I'll need to go back and capture whatever is in the second set of quotes for another formula to capture the Rx strength.

Thanks in advance,

Jason

 

[jlopeman]

I solved my question using T-SQL and a command. But, if possible, I'd like to know how to do this using a crystal formula.

 

[lbass]

Try something like this:

//{@first set of quotes}:
stringvar x := {table.memo];
stringvar array y := split(x,"&");
extractstring(y[1],",")

//{@second set of quotes}:
stringvar x := {table.memo];
stringvar array y := split(x,"&");
if ubound>=2 then
extractstring(y[2],",")

//{@third set of quotes}:
stringvar x := {table.memo];
stringvar array y := split(x,"&");
if ubound>=3 then
extractstring(y[3],",")

//etc.

-LB