Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Salesforce BlitzSalesforce Blitz 

Need to remove and merge data in between 2 consecutive quotes into one

I am reading csv string and placing the values into appropriate fields in Salesforce Objects.
But for below scenario I am facing error:

Consider csv Line has 123,56,124,45,45,2548,3356 --this works fine with 6 columns into 6 fields
If Input has string/comma like 123,56,124,45,45,"2,548","3,356" We are getting an error of invalid integer "2 

Need to merge data between two "" into one without spaces just like the former
Aman MalikAman Malik
How are you merging these line into fields. Using apex, if yes kindly post your code here.

Thanks,
Salesforce BlitzSalesforce Blitz
 public void importCSVFile(){
 
           csvAsString = csvFileBody.toString();
           csvFileLines = csvAsString.split('\n'); 
           
           string[] csvHeaderData = csvFileLines[0].split(',');
           Month1=csvHeaderData[7];
           Month2=csvHeaderData[8];
           Month3=csvHeaderData[9];
           Month4=csvHeaderData[10];
           Month5=csvHeaderData[11];
           Month6=csvHeaderData[12];
           /*if(Month1.contains(' ')){
           Month1= Month1.substring(0, Month1.indexOf(' '));
           }
           if(Month2.contains(' ')){
           Month2= Month2.substring(0, Month2.indexOf(' '));
           }
           if(Month3.contains(' ')){
           Month3= Month3.substring(0, Month3.indexOf(' '));
           }
           if(Month4.contains(' ')){
           Month4= Month4.substring(0, Month4.indexOf(' '));
           }
           if(Month5.contains(' ')){
           Month5= Month5.substring(0, Month5.indexOf(' '));
           }
           if(Month6.contains(' ')){
           Month6= Month6.substring(0, Month6.indexOf(' '));
           }*/
            
           for(Integer i=1;i<csvFileLines.size();i++){
               Opportunity_Estimate__c oeobj = new Opportunity_Estimate__c() ;
               string[] csvRecordData = csvFileLines[i].split(',');
               oeobj.Opportunity_AX_ID__c = csvRecordData[0] ;             
               oeobj.Comments__c = csvRecordData[13];
               
              
               
}