Background
Integration files are either fixed-width or delimited files. These should be in text editors. If the data was in Excel tabular format, it would be much easier to analyze.
YouTube Video
Solution
I have created tow tools using Excel to easily convert the text files to Excel tabular format. The solution is dynamic. Below are the steps how to use these tools.
Download the tools with sample files
https://drive.google.com/file/d/1MwS9qzTM6i6S8xNk1ZlQsC1Y6a9U7nBg/view?usp=sharing
Delimeter Tool V1
Delimeter Tool V2
Note: In this excel, the delimiter is not dynamic. It only works for Pipe(|). Upon request, with little effort, I can prepare a new excel for the desired delimiter.
Fixed Width - Tool V1
Fixed Width - Tool V2
