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