I am able to convert csv to json. But with some csv they contain escape character in column value(), due to which it is giving error. Below is the sample csv content, you can just copy and paste in notepad and save it as .csv
Please advice the corrections.
“Id”,“IsDeleted”,“MasterRecordId”,“Salutation”,“FirstName”,“LastName”,“MiddleName”,“Title”,“Company”,“Street”,“City”,“State”,“PostalCode”,“Country”,“Latitude”,“Longitude”,“GeocodeAccuracy”,“Phone”,“MobilePhone”,“Fax”,“Email”,“Website”,“Description”,“LeadSource”,“Status”,“Industry”,“Rating”,“AnnualRevenue”,“NumberOfEmployees”,“OwnerId”,“HasOptedOutOfEmail”,“IsConverted”,“ConvertedDate”,“ConvertedAccountId”,“ConvertedContactId”,“ConvertedOpportunityId”,“IsUnreadByOwner”,“CreatedDate”,“CreatedById”,“LastModifiedDate”,“LastModifiedById”,“SystemModstamp”,“LastActivityDate”,“DoNotCall”,“HasOptedOutOfFax”,“LastTransferDate”,“Jigsaw”,“JigsawContactId”,“EmailBouncedReason”,“EmailBouncedDate”,“IndividualId”,“CurrentGenerators__c”,“NumberofLocations__c”,“Primary__c”,“ProductInterest__c”,“SICCode__c”,“Requested_On__c”,“Decision_Date_Expected__c”,“Sent_On__c”,“et4ae5__HasOptedOutOfMobile__c”,“et4ae5__Mobile_Country_Code__c”,“Close_Date__c”,“Program_Interest__c”,“Details__c”
“00Q4a000001BtwDEAS”,“0”,“”,“”,“John”,“Gribble”,“”,“Business Development Consultant”,“Grid Group",“”,“”,“”,“”,“”,“”,“”,“”,“”,“0400156456”,“”,"john_gribble@bigpond.com”,“”,“”,“Website”,“New”,“Grid Group offers sanitisation expertise to various markets. ",”“,”“,”“,“0054a000000Hh1DAAS”,“0”,“0”,”“,“000000000000000AAA”,“000000000000000AAA”,“000000000000000AAA”,“1”,“2020-05-20 01:55:48”,“0050o00000WINgGAAX”,“2020-05-20 01:55:48”,“0050o00000WINgGAAX”,“2020-05-20 01:55:48”,”“,“0”,“0”,“2020-05-20 01:55:48”,”“,”“,”“,”“,“000000000000000AAA”,”“,”“,”“,”“,”“,”“,”“,”“,“0”,”“,”“,”“,”"
