Hit my next roadblock.
I am trying to take a text file, that seems to be delimited by a random number of spaces and convert to xlsx.
In Excel the normal txt import doesn’t work on Office 265, I have to use the legacy import to text in Office 365.
I downloaded Doug’s module, but am having problems finding how I read the text file in and export to xlsx. Tried finding some documentation to help but could not.
Can someone point me in the right direction?
Thanks in advance,