Help with long, delimited text field 1

[Tatertot45]

I'm using CR XI, SQL DAtabase and a stand alone CR (Developer)

I have a larger ITem Description firled that i need to parse out, but can't seem to figure it out. An example of the field is *CAL,APC,Lav/Pine,33.8oz. I need to display the "APC" part of the field, or the second element as it is seperated with commas. However, i can't find the function to use where you can split a field and identify the delimitor. This hsould be simple, but i'm having a moment.

Any help is appreciated.

 

[AndyMc]

Tatertot45,

try:

stringvar array txt := split({table.itemDescription},",");
if ubound(txt) >= 2 then
txt[2]
else
{table.itemDescription}

Andy

 

[Tatertot45]

Beautiful!! That was it. Thanks.