Thank you for looking at my question,
I have a poorly formatted .csv file that I am need to distill down so that I can import it into MS Access.
The process I am following is to read lines from the csv file, carry out some string manipulation and write to a .xlsx worksheet.
Part of the process Is that I need to extract a sub-string of varying length from a specific line within the file.
The text in question is:
<BOM Line (Parent Node)> 1912009989 Opt 1000 25S wired inner assy.
and I need to be able to extract the sub-string that is, in this case, 1912009989. In subsequent files the sub-string may be longer and I cannot say whether the number of spaces between the ">" character and the first character of the sub-string will always be as in this instance.
I need the sub-string that is the first character after ">" that isn't a space to the last character before the next space
Any help you can offer will be appreciated greatly