I have downloaded some data from the web. The original data was in different columns but was downloaded to a single column
I am trying to split the data into specific data fields
I have extracted the first column using the left function based on the 1st space and the right function
This is one example of the remaining data 0147 1322 03 HEX. HEAD SCREW 4 after I have extracted a drawing referance number
a) I would like to insert 2 dashes to make 0147-1322-03, but I can always do it in stages e, g replace the 5th character with a "-" and then repeat for the 2nd "-"
b) what would be the expression to extract the last digit
Many regards for you help, hope the above is clear
Dave