@John-Connor-0 said in text string to column:
So far it’s working Thanks so much!
I’ve just noticed that my solution doesn’t do one of the example lines (sorry missed that on the first look).
Not to worry as these lines weren’t affected by the first regex (regular expression) as there was no pseudo arrow character in these lines. So to edit these lines and have the resulting fields line up with the other altered fields I have the following. Same as before, use Replace and set the search mode to regular rexpression.
Find What:(?-s)^(.:)(.+?) - (Skipped.+)
Replace With:"\1\2","","\3"
Important, use the first solution first, then this afterwards otherwise erroneous results will occur. This one places an empty field where the destination drive letter would otherwise be, thus keeping the success or failure result as the third output field.
Terry