This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
See the attach workflow, hopefully that should get you most of the way there.
Your input file is a fixed width text file, so it might be good to look at in Notepad with a font set to Courier, as it has equal spacing per character.
The workflow identifies the report body, by selecting the lines between the ------ and Page : Then it uses RegEx to split your text file into the first 6 characters, then the next 11, the next 6 and so on. (You might need to double check the widths I have here for each field). You could also use a series of Substring functions.
Usually where you get a report like this, they were designed to be printed to typically don't change.
I mightn't have gotten the exact number of characters correct, as I just a had a quick look at creating a solution, so you might need to tweak this as you get more input data. In the case of the Issue column, if this isn't always 52 characters would could look at other ways of doing it, like taking all the characters before USD, BRL, CAD, et c .
But this type of file is usually consistent. And looking at your data again, I had Field Change down for 24 characters, Old Value for 20 characters and New Value for 22. I think this should be 22 characters for each of these fields.
Sometimes you can be luckier with text files, where you have 2 or more spaces between the fields, and you can use a RegEx function to replace 2+ spaces with a |, then just do a Text to Columns splitting on the |. This won't work for you unfortunately as you have empty fields, so it wouldn't align them correctly.