How to get onlthe first word in a text ?

[Skerdi]

Hi,
Can some1 tel me how to get only the first word in a text field where there are many words? The text field has many words but I need only the first (the first before the first space)

Thnx in adv.

 

[DJkarl]

Hi,
Can some1 tel me how to get only the first word in a text field where there are many words? The text field has many words but I need only the first (the first before the first space)

Thnx in adv.

Left$([FieldName],Instr(1,[FieldName]," ")-1)

This should do the trick.

 

[Skerdi]

Left$([FieldName],Instr(1,[FieldName]," ")-1)

This should do the trick.

Thnx DjKarl.
It gives an error at the first comma

 

[neileg]

Try
Left([FieldName],Instr([FieldName]," ")-1)

 

[PeterF]

Some region settings require the use of a semicolon ";" in stead of a comma.

 

[Skerdi]

Some region settings require the use of a semicolon ";" in stead of a comma.

Thanks guys.
That's it. It needs ; instead of a comma.
Thanks