Hi,
I have invoice file back up files which we require to convert to csv format. This has not been possible because the .dat file is not structured properly and it contains a lot of noisy/rogue characters.
1. The header detail is followed by equal sign, e.g customer=Jon Smith
2. Where there are supposed to spaces between records, the spaces are denoted by special characters, e.g Jon%20Smith
How do I get a clean copy of the invoice backup without all the data noise in a csv format?