how to read csv file through App engine peoplecode which has one field having values with comma.
I am trying to read a .csv file and load that into peoplesoft table.
file has one amount field(character type) which can have comma(e.g. 2,400,00.00). I want my program to read this field value load into table.
Currently while reading the file as soon as it see first comma in amount field it takes rest all values in next field and program errors out.
file is coming from a place outside our control, and we cannot therefore change the format of the input file. also data in the file can have large number of rows so it is not efficeint to place quotes(" ") around the amount field manually and then do the processing.