1. Challenge: What is the problem or issue that you're attempting to solve?
Flat files are one of the most challenging data files to work with. Importing the file and correctly converting the spaces/tabs into correct format takes time and can be challenging.
2. Solution: How does your workflow, app, package, etc. solve the challenge?
Dynamic Delimiter macro takes the flat file data and automatically calculates the correct number of delimiters to group together and split the data into correct number of columns. This is crucial to avoid any scope of having skewed data flowing into incorrect columns.
3. Value: What value did your solution bring to you or your company?
It will be a plug and play macro, where user can just add this to their workflow and it will give out a clean data.
