Supressing Data after a Comma 1

[ltkling]

I have a field that returns data separated by a comma and I only want to see the data that precedes the comma.
Thanks

 

[kray4660]

I can only think of using the instr function to find the comma, then use the left function to just return that part of the string. Example:
left({string},instr({string},",")-1). If there is not a comma in the string, it will return an error.

 

[lbass]

left({@string},len({@string})-1)

Instr() would only check for the first comma in the string.

-LB

 

[kray4660]

Instr() would only check for the first comma in the string."

I believe that is what Itkling is looking for.

 

[ltkling]

Kray4660 - That is what I am looking for however, there are some results from that field that don't have a comma and are text only...when I use this formula, I get nothing in that field.

 

[fisheromacse]

add a 'no comma' check to the beginning of your formula:

IF instr({string},",")=0
then {string}
else
left({string},instr({string},",")-1)

 

[ltkling]

Thank you all for your help!!! This last one worked.