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

[#2]

Hi Kourosh please forgive my ignorance - but how do I do that?

[tresesco]

Hello Chris,

You can mark 'Correct Answer' / 'Helpful Answer' for the ones you feel like. Marking correct answer would lead people understand that the thread is anwsered and might save their time not exploring more on it or help people who might look for solution to similar problem.