Hi
I have user that export data from SAP into .csv/xls files (I have no control over this process)
This spreadsheet comes out with the ' character in front of the file headings.
When this sheet is uploaded into our SQL database the ' in the headers prevents import (the data is checked upon import attempt)
Now I could just change the import routine on the database to remove these characters but I'd like to understand why SAP put's these characters in the file so I can pass the problem back or at least find a method of removing them previous to import. I've already tried find ' and replace with blank but this function doesn't appear to work.
Any help greatfully appreciated.
I have user that export data from SAP into .csv/xls files (I have no control over this process)
This spreadsheet comes out with the ' character in front of the file headings.
When this sheet is uploaded into our SQL database the ' in the headers prevents import (the data is checked upon import attempt)
Now I could just change the import routine on the database to remove these characters but I'd like to understand why SAP put's these characters in the file so I can pass the problem back or at least find a method of removing them previous to import. I've already tried find ' and replace with blank but this function doesn't appear to work.
Any help greatfully appreciated.
