November 16, 2023 at 4:31 pm
That is a very ugly file. Guessing it came from a mainframe?
It may be faster and more supportable to learn some python to preclean and format the file than it would be to try to do this in SQL.
November 16, 2023 at 4:31 pm
second page bump
November 16, 2023 at 5:32 pm
Thank you!
November 16, 2023 at 6:30 pm
That is a very ugly file. Guessing it came from a mainframe?
It may be faster and more supportable to learn some python to preclean and format the file than it would be to try to do this in SQL.
why? I've already gave working sql to parse the file - nothing major to it really.
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply