Currently I receive a file that shows different jobs functions and the files related to the jobs, however the list of files received is shoved together in one cell as one long string. A few of the file names have a carraige return between them and some have a space but there is no fixed delimiter and the file names can be different lengths. The only constant is the file naming format. Each file starts with LZ.(the third character is a .) or LC. Some of these have two or three file names and some have 15-20. I am trying to find a way to see if I can get each file name in it s own column.
How data looks now:
<tbody>
</tbody>
How I would like it to look:
<tbody>
</tbody>
I have tried using Text to Columns, substr and LEFT/RIGHT with SEARCH and can not seem to find a proper solution.
Any help would be greatly appreciated.
How data looks now:
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
How I would like it to look:
<tbody> </tbody> |
<tbody> </tbody> | ||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
I have tried using Text to Columns, substr and LEFT/RIGHT with SEARCH and can not seem to find a proper solution.
Any help would be greatly appreciated.