I have been working on a small project to import set of records from a text file and to split them into columns in excel.
I have designed a vba form that takes inputs from a mail copy and use regex patterns to capture and split the text.
Sample input
ID# start date end date cutomerid descr...