Salesforce Apex read CSV file data which has comma in it


List> allFields = new List>();
Blob contentFile;
String nameFile;
String[] filelines = new String[] {};
nameFile = contentFile.toString();
filelines = nameFile.split('\n');

for (Integer i = 1; i < filelines.size(); i++) { //for(String line : filelines) { //String[] inputvalues = new String[] {}; List fields = filelines[i].split(',');

// check for blank CSV lines (only commas)
//if (line.replaceAll(',','').trim().length() == 0)
// break;

List cleanFields = new List();
String compositeField;
Boolean makeCompositeField = false;
for(String field : fields) {

if (field.startsWith('"') && field.endsWith('"')) {
cleanFields.add(field.replaceAll('"',''));
} else if (field.startsWith('"')) {
makeCompositeField = true;
compositeField = field;
} else if (field.endsWith('"')) {
compositeField += ',' + field;
cleanFields.add(compositeField.replaceAll('"',''));
makeCompositeField = false;
} else if (makeCompositeField) {
compositeField += ',' + field;
} else {
cleanFields.add(field.replaceAll('"',''));
}

}
allFields.add(cleanFields);
}
}

By / June 8th, 2018/ Apex, Salesforce, Visualforce/ 0 Comments/
Read More

Customer testmonimal

AdhiSoft’s deep Force.com expertise helps our clients to take advantage of everything Salesforce platform offers and move quickly to go live usage. Our AdhiSoft solution force.com was delivered in lesser time, almost one third of time of traditional platform solutions.

By / April 12th, 2016/ Uncategorized/ 0 Comments/
Read More

Prospective Client from US

We are very aggressive about coming with new solution for our business need, AdhiSoft delivered the right mix of Force.com and
custom development expertise. They helped us with Salesforce solutions for our requirement, Salesforce allows us to maintain a focus on our customer and to do it in a faster, simpler way.

By / April 12th, 2016/ Uncategorized/ 0 Comments/
Read More