I have two questions in order to make a custom csv importer in VF/Apex. I saw many samples out there but I'm not able to find validations samples.
1) I would like to know if is any regex to validate a generic CSV according this spec
Year,Make,Model,Description,Price 1997,Ford,E350,"ac, abs, moon",3000.00 1999,Chevy,"Venture ""Extended Edition""","",4900.00 1999,Chevy,"Venture ""Extended Edition, Very Large""",,5000.00 1996,Jeep,Grand Cherokee,"MUST SELL! air, moon roof, loaded",4799.00
The amount of columns of the csv will be variable...
I know that this forum is for Apex/SFDC question and I should ask in stackoverflow.com/regex but since I have to implement this in apex, I cant use the parsers that are suggested there.
2) Also I would like to know how to validate the limit of the file/string that can be imported/parsed. Thank you!