String field text including and after ","

[SteveGriff]

Hi there,

I have this field with: -

foobar , textiush etc.

I want my script to remove the "," and everything after it.

Any help would be most appreciated.

Thanxs

Steve Griff

[IdealData]

Is this the first comma ?

Maybe you only want to retain the first word.

Look at the Text functions:

Leftwords

Position

Substitute

etc.

[RussBaker]

For the contents of your field "Input_Text", this calc will do it:

code:

---

Left_Bit_Of_Text = Trim(Left(Input_Text,Position(Input_Text,",",1,1)-1))

The Trim tidies it up in case someone types a space before the ",". If you want that space in there, remove the Trim function.

Russ

[ April 10, 2002, 06:30 PM: Message edited by: Russell Baker ]