Iam running running a csv with quotes around the fields
i got the following error, how to fix the file? while viewing the file i did not get any error,
looks like control character , and had a new line character in the field.so it
might happen again , is there any i could define the format to overcome this error rather than fixing file.
..ipfile.iprec: read_delimited() - invalid quotes, row 1342 column Address1 = "141 santa rosa avenue
"
Code: Select all
"32045773","goriot@mac.com","greg ","tangonan","asia pacific tech strategies","C
EO/Owner/President","141 santa rosa avenue^M
",,"oxnard","California","United States","93035",,,,"Communications","eb_enhanci
ng_productivity","eb_managing_change","security","voip_telephony","Less Than 100
","no",,,,"Other","yes","networking_exchange","business.att.com","2006-04-24 09:
26:15.0","2006-04-24 09:25:40.0","2006-04-24 09:26:15.0",,
Thank you,