Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Problem while reading data from AL11

Former Member
0 Kudos
275

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.

2 REPLIES 2

andreas_mann3
Active Contributor
0 Kudos
97

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
0 Kudos
97

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

Thanks,

Phani