Employees are adding commas to their address fields in employee space and causing issues with various interfaces (which use csv files) to external companies. What's the best was to handle this? We're using GHR with S3 Payroll.
I'm glad we are not the only one with this issue. What I have done, and there might be an easier way, is to assign the field to a variable and then through JavaScript I replace all commas with a blank and assign this value a different variable. I then do a test to see if the original variable contains a comma and if it does to send me an email so that I can remove them from the address field.
I originally tried to put quotes around the fields hoping that the downstream systems would ignore the commas within a quote but not all seemed to work.
We use text qualifiers in our interfaces to avoid this issue
www.import2.com/.../why-quotation-marks-are-used-in-csv
Any chance you can share some of your code? We don't want to use quotes and run through testing with multiple vendors only to find that it doesn't work in all cases (thank you for confirming our 'fears'). Additionally, we would like the data in the database to be correct, with no commas. We might want to run a separate process to look at the employee address fields on a set schedule and send an email to HR to correct any where the process finds a comma.
