Sales Export data does not comply with header
I am user AccountRight Premier. See Screenshot I have run an export as follows: Sales --> Item Sales --> All Sales The first 10 or so lines match the header After that, there are line feeds betwe...
Forum Discussion
Hi Stuart_Edge , my first thought is whether you actually need the fields that contain the extra line breaks for your sales export and analysis. If not, then unmatch them during the export.
If they are essential, then you can use a tool like Notepad++, which has a 'regex' find & replace option.
This link shows an example of how that might be used in a similar situation:
notepad++ - Remove carriage return from text file - Stack Overflow
All the text from that field would then appear as one long string.
(This option would probably be unfamiliar to many people).
Thanks for the reply.
Yes I have worked around this by taking these actions.
It doesn't fix the problem, the workaround actions are time consuming and there is nothing consistent in the data to work with a regex or macro to correct the problem.
Secondly, this data:
Bank:
Account name:
BSB number:
Account number:
Is not listed in the fields I can select or omit. Where is it coming from?
How do we get this fixed?
