convert .csv file into internal table based on fieldnames?
I would like to convert the csv file data into internal table based on the fieldnames. not with actual data.
Because some of the cells have data with commas. but this is not the field separated comma. So, we need to build internal table with column names. not with actual data.
Note: Any cell may have text with comm. like below..
col1 | col2 | col3 | col4
123 | test,abcd | sdkl,efheb | egjhfj,dfgeh
234,345 | dfue,ghf | fdhfdjfd | dfjkgfm,ede
I tried with the below fms but no use.
I know normally ... if CSV file will do like SPLIT record by separator.
But here ... the data may contains commas. So, it is not working with my case.
Pls help me .
Any FM to convert the csv file data to internal table with fieldnames not with data.
Thanks in advance.