extract first few characters..

[abhi900]

hi all,

I have a string field in use, however i want to extract jst the first few characters of tht string till it hits ";".
So basically give me everything before the ";". so it might return me 7 characters or it might be 4 characters but all do have ";" in the end.
Can someone please pass me a syntax to do this ??

you help is much appreciated.

Regards
abhi.

 

[Turkbear]

Hi,
Check the help file for the use of the Left and InStr functions.

Sample
If string ( say it is {field1}) is wert;sertooke
using

Left({field1},Instr(";")-1) would be wert



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Madawc]

all do have ";" in the end

That can be handled by

split({your.field},";")[1]

If there were a few cases where the ";" was missing, Ubound can check for that.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP