Problem while reading data from AL11

[Former Member]

Hi Experts,

I am using OPEN DATASET

READ DATASET

CLOSE DATASET to read data from the application sever. In application sever the file type is .CSV. So after reading data from application layer(AL11) to a text variable, using statement ' SPLIT AT ',' ' all the values passing into correspoding internal table fields. And it getting updated successfully into DB also.

In above scenario my question is, if aquantity figure with coma seperator( 95,000,000.000), then while SPLIT it's creating problem. Same case in .XLS file, it will be created # seperator in the application layer. if any field having # then it will create problem again.

So can anybody suggest how can we over come the problem. Or is there any other way to read data properly from application layer(AL11)?

Thanks and regards,

Phani.

[andreas_mann3]

to overcom this problem,

normally we use tab as sparator

so use CL_ABAP_CHAR_UTILITIES=>VERTICAL_TAB to separate your fields!

grx

Andreas

[Former Member]

We can use 'CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB' as a seperator to split single field value into different.

Thanks,

Phani