On further investigation, it appears that some of our staff have been typing the delivery address in manually, rather than selecting it from the drop down.
Secondly, they added a comment which was pasted from some dubious source.
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?
