Hi would appreciate some help with parsing using REGEX the following data
Input Data
Total 123-456 Description of the total |
500000 Description of item |
600-123 Another line description |
Irrespective of the lines in each cases I need to parse the "123-456" , "500000" and "600-123" in one column and in another column I need the remaining descriptions e.g. Total Description of the total, Description of item and "Another line description" using the example above.
