Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Opposite of concatenate

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


1 Solution

Accepted Solutions
kouroshkarimi
Creator III

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

View solution in original post

11 Replies
tresesco
MVP

SubField()

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

SubField(YourField, ' ',1)

michael_maeuser
Partner Ambassador

keepchar ( 'yourfield','0123456789' )

Not applicable
Author

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
Creator III

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

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

Not applicable
Author

Thank you!

Sent from my iPhone

Not applicable
Author

Thank you

Sent from my iPhone

Not applicable
Author

Thank you

Sent from my iPhone

Not applicable
Author

Thank you

Sent from my iPhone

kouroshkarimi
Creator III

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