Am trying to upload the CSV file into internal table using 'GUI_UPLOAD' initially and then splitting the record at ',' into different fields. But the issue is, my data contains numbers (currency) and they have ',' in the data and hence the data is uploaded into the internal table with 'GUI_UPLOAD' inbetween " ", for example, "41,500".
So when we use Split at ',' it splits the entire number to "41 and 500" etc..
How can I resolve this?
Thanks in advance.