Hi,
I receive a text version of a report from an external vendor that I'm looking for some help to automate conversion to Excel. When you try to import via the import wizard, because of the file format, never gets the column format correct. There are two reports as part of the file, the first approx 16 pages and then the next page 17 until the end of the report. I have attached my dropbox versions of the file for reference, the txt file and also the Excel version.
Any help you can give would be very much appreciated.
https://www.dropbox.com/s/foot0kmfsi7fznt/TEST.txt?dl=0
https://www.dropbox.com/s/rh9u3ndiqkm4j7q/TEST.xls?dl=0
I receive a text version of a report from an external vendor that I'm looking for some help to automate conversion to Excel. When you try to import via the import wizard, because of the file format, never gets the column format correct. There are two reports as part of the file, the first approx 16 pages and then the next page 17 until the end of the report. I have attached my dropbox versions of the file for reference, the txt file and also the Excel version.
Any help you can give would be very much appreciated.
https://www.dropbox.com/s/foot0kmfsi7fznt/TEST.txt?dl=0
https://www.dropbox.com/s/rh9u3ndiqkm4j7q/TEST.xls?dl=0