other FM or class for uploading CSV file to ITAB

[AJeB]

hi is there other FM/Class i can use for uploading CSV file to ITAB that can hold up to 300 characters per column or higher than the FM module below

i already check this

KCD_CSV_FILE_TO_INTERN_CONVERT up to 32 characters per field

ALSM_EXCEL_TO_INTERNAL_TABLE up to 50 characters per field

GUI_UPLOAD and TEXT_CONVERT_XLS_TO_SAP up to 255 characters and columns are merged into 1 field , not possible and not recommended if i have up to 50 columns with 30characters each field

[Tomas_Buryanek]

Class CL_RSDA_CSV_CONVERTER does not have column/field limit AFAIK.

And I would recommend it for CSV data parsing 🙂

[AJeB]

thanks, but in this class i need to use gui_upload and i avoid that FM because that FM is producing this result

sample
the max character of this table_line is up to 255 only, i also tried to increase the length in my structure up to 300 but still not working

[Tomas_Buryanek]

bolivs22 Yes you need to use GUI_UPLOAD (CL_GUI_FRONTEND_SERVICES method or FM).

If you have issues with GUI_UPLOAD, then please share relevant part of the code with data definition also. There is most likely some issue with your code. Because GUI_UPLOAD has basically no limit with DATA_TAB.

[Sandra_Rossi]

Remark about GUI_UPLOAD. It's not to be used to decode CSV. It just uploads any kind of text file (CSV being a text file). Lines can be more than 255 characters. CSV is one of the most simple format in the world, you can move the field values to an internal table in a few lines of ABAP code.

[matt]

columns are merged into 1 field

If only there was someway of SPLITting the one column.