subject: not correct format of csv files exported from ARM
text:
to show the problems, I show you as example the header:
"SESAID,""ALTERNATEIDS"",""PLATFORM"",""PLATFORMOWNER"",""PUBLISHER"",""APPLICATIONNAME"",""HFMCODE"",""CURRENTLYACTIVE"",""ACTIVATEDATE"",""DEACTIVATEDATE"",""GROUPNAME"",""OFFICECOUNTRY"",""FIRSTNAME"",""LASTNAME"",""COMPANYNAME"",""JOBCODE"",""REPORTINGENTITY"",""BUSINESSUNITNAME"",""LOCATION"",""INTERNETADDRESS"",""MANAGERFIRSTNAME"",""MANAGERLASTNAME"",""MANAGEREMAIL"""
1- the first element (SESAID) is only enclosed by one double-quote, so "SESAID instead of "SESAID", or SESAID as this simple string needs not to be enclosed.
2- the following elements except the last one are unusefully double-enclosed, as, for example ""ALTERNATEIDS"" instead of "ALTERNATEIDS" or even ALTERNATEIDS
3- around the last element, there is a third double-quote at the end: ""MANAGEREMAIL"""
The same faults exist on every lines (records).
It seems necessary that it would be corrected (my tool can't handle these CSV files). I don't know who could do that. I let you manage the problem.
Partager