You need to sign in to do that
Don't have an account?
Øyvind Borgersen 10
CSV file upload skip line if field is blank
Hi,
I've created a CSV file upload code, but need to enhance the code to skip the whole line if one field is blank.
For the code below I want to skip the line if csvRecordData[1] is blank.
csvAsString = csvFileBody.toString();
csvFileLines = csvAsString.split('\n');
for(Integer i=1;i<csvFileLines.size();i++){
Videogram_sales_number__c vidObj = new Videogram_sales_number__c();
//Create date as string
String dateFormatString = 'yyyy-MM-dd';
Date d = Date.today();
Datetime dt = Datetime.newInstance(d.year(), d.month(),d.day());
String dateString = dt.format(dateFormatString);
//Split by comma or semicolon
string[] csvRecordData = csvFileLines[i].split(',|\\;');
if(csvRecordData[1] != null){
vidObj.Case_ID__c = csvRecordData[0];
vidObj.Number_of_copies__c = decimal.valueof(csvRecordData[1]);
vidObj.Registration_date__c = date.today();
vidObj.RegistrationNumberDummy__c = dateString;
vidObj.Titledummy__c = csvRecordData[2];
vidObj.RegistrationNumberDummy__c = csvRecordData[3];
vidList.add(vidObj);
}
}
I've created a CSV file upload code, but need to enhance the code to skip the whole line if one field is blank.
For the code below I want to skip the line if csvRecordData[1] is blank.
csvAsString = csvFileBody.toString();
csvFileLines = csvAsString.split('\n');
for(Integer i=1;i<csvFileLines.size();i++){
Videogram_sales_number__c vidObj = new Videogram_sales_number__c();
//Create date as string
String dateFormatString = 'yyyy-MM-dd';
Date d = Date.today();
Datetime dt = Datetime.newInstance(d.year(), d.month(),d.day());
String dateString = dt.format(dateFormatString);
//Split by comma or semicolon
string[] csvRecordData = csvFileLines[i].split(',|\\;');
if(csvRecordData[1] != null){
vidObj.Case_ID__c = csvRecordData[0];
vidObj.Number_of_copies__c = decimal.valueof(csvRecordData[1]);
vidObj.Registration_date__c = date.today();
vidObj.RegistrationNumberDummy__c = dateString;
vidObj.Titledummy__c = csvRecordData[2];
vidObj.RegistrationNumberDummy__c = csvRecordData[3];
vidList.add(vidObj);
}
}