I would like to read a CSV file when user uploads it manually using upload control. The file will have around 150 columns( they are not Pega standard properties and also has some special character or long headers) out of which I would need only 10 columns so is there any way we can read only those by ignoring other columns structure. I see this code rules are final so please suggest me any better ways of doing it.
Customer doesn’t want to have any standard template for this as that is generated by some other portal.
I am using the same one but the problem is it expects the required CSV file column name expected same like pega property. For example in file I have coulmn “Was there Any Issue(Primary communication)” so it is throwing a validation message by saying this is not a valid property.
Another problem is that this file has some complex data for some columns with some carriage returns and news line I.e paragraphs and that file is being generated by some other systems.