Query Data before space

[rbs]

Hi Everyone,

I have data in a field from which I need to extract any data prior to the first hardspace in the field.

Can anyone help?

Thanks in advance.

Natalie.

 

[bat17]

Assuming that you are doing this in a query then in a new column add: -
Left3: Trim(Left([MyField],InStr([MyField]," ")))
Replacing [MyField] with your field name.

HTH

Peter

 

[rbs]

Thanks Peter,

I don't need to replace the field, just view the data in a query.

Can you change the formula for me...

THanks,

Natalie.

 

[bat17]

This does create a new column for you. "Replacing [MyField] with your field name." means that you should replace "MyField" in my example with whatever the name is of the field that you wish to work on.

HTH

Peter

 

[rbs]

Thanks for your help.