You need to sign in to do that
Don't have an account?
theD
Strip \n embedded within quotes in CSV in APEX
I am using the code at https://developer.salesforce.com/page/Code_Samples to import and process a CSV. The only issue is that it does have \n's embedded in on of the columns that is surrounded by double quotes. This file is uploaded into a BLOB then I extract the file from the BLOB using toString. I can't then seem to get to the embedded \n within the quotes to strip with replaceall etc. Think First Field,"Hello\n1)There\nWorld",Third Field, Forth field ...... \n (for end of line).
I am hoping I can just find the \n's within double quotes and strip them or replace them.
Not sure...do I have to escape the arguments in ReplaceAll \\n?
Any thougths out there on an approach?
I am hoping I can just find the \n's within double quotes and strip them or replace them.
Not sure...do I have to escape the arguments in ReplaceAll \\n?
Any thougths out there on an approach?