find occurences of a character in a string 2

[kenwood1]

I am using CR v9

I have long text string that has the data I need separated by a ;. I would like to give each occurence of ; a position number and then use the MID formula to display them on a report.

I have used 'Instr' in my attempt, I found the first occurrence and the shortened the string this value, then found the next occurence.... and so on. This gets me the result but is very slow.

 

[AndyMc]

kenwood1,

The following will split your text up into an array:
stringvar array txt := split({table.name},";");

The following will return the number of values:
ubound(txt)

To show the values:
txt[1]
txt[2] ...

Andy

 

[lbass]

If you don't know how many segments there are in the field, then you should write separate formulas like this, expanding upon Andy's suggestion:

//{@segment1}:
stringvar array txt := split({table.name},";");
if ubound(txt) >= 1 then
txt[1] else
{table.name} //add the field as the default in the first formula only to account for fields without semicolons;

//{@segment2}:
stringvar array txt := split({table.name},";");
if ubound(txt) >= 2 then
txt[2]

If you want to number the segments, then change the formulas to:
//{@segment1}:
stringvar array txt := split({table.name},";");
if ubound(txt) >= 1 then
"1) "+txt[1] else
"1) "+{table.name}

//{@segment2}:
stringvar array txt := split({table.name},";");
if ubound(txt) >= 2 then
"2) "+txt[2]

Write as many formulas (or more) than the maximum number of segments.

-LB

 

[kenwood1]

Thanks andymc & lbass this was the exact solution to my problem, it worked like a dream and 100 times faster than my method. Thanks again guys.