Opposite of concatenate

[#1]

Hello

I would like to know what expression should be used to split data. Something similar to Excel's text to column functionality.  I have looked at the left and right functions, but really need to extract the text prior to other text.

See below example of lines;

6 Work Order

295 Work Order

I would like to extract the "6" and the "295" and left function will not work as the length is variable. I really need the left of the word "work"

Hope this makes sense.  cheers

[tresesco]

SubField()

SubField('295 Work Order' , ' ',1)  // gives 295, so to generalise, you can try:

SubField(YourField, ' ',1)

[michael_maeuser]

keepchar ( 'yourfield','0123456789' )

[#4]

May be like this..

=Left('295 Work Order',Index('295 Work Order','Work')-1)

Instead of '295 Work Order', you can use field name

Karthik

[kouroshkarimi]

There are lots of way to do this, and you can use left if you want:

left(Field,Index(Field,' ')-1)

[#6]

Thank you!

Sent from my iPhone

[#7]

Thank you

Sent from my iPhone

[#8]

Thank you

Sent from my iPhone

[#9]

Thank you

Sent from my iPhone

[kouroshkarimi · Accepted solution]

Hello Chris, can you please mark this question as answered if you're happy. Thanks.