I receive a text file each day that has no delimiters separating the records. As far as I can tell, though, each record ends with "CURRENT TIME ##:##:##"
What I would like to do is import this text file into Excel each day and separate the records into rows and columns. I have tried using text to columns, but it
does not work that well because there are no delimiters, so I end up having to try to line up the columns manually. If I could just get the
file into Excel with one record per row and the data in columns, that would save so much time for me. Any idea as to how I can do that?
I have attached a sample of what the file looks like. Any help is greatly appreciated.