topic Re: csv tab delimited problem in Application Development and Automation Discussions

csv tab delimited problem

Former Member — Wed, 12 Jan 2011 04:08:19 GMT

HI Experts,

I have a problem.

I have uploaded the file in csv format using Open dataset.

But they want in csv tab delimited format. I really dont understand how to do in this format.

I know only csv (the file will be separated by ',') and if tab delimited means ( file separated by '#').

How to achieve the csv tab delimited format.

Also, in file, if the field contains - no value, it comes as space. But that space while concatenating, it is not added. How to acheive a space while concatenating the fields.

Awaiting for your replies.

Thans in Advance,

Regards,

Sakthi Sri.

Re: csv tab delimited problem

Former Member — Wed, 12 Jan 2011 04:18:41 GMT

Hi,

Use the below code for tab delimiter.

data: l_seperator TYPE c.

CLASS cl_abap_char_utilities DEFINITION LOAD.

l_seperator = cl_abap_char_utilities=>horizontal_tab.

CONCATENATE field1 field2 field3

INTO <file name> SEPARATED BY l_seperator.

If you need the spaces where field1 is space you can get automatically by passing the work area whatever it contains and will display it as space in the CSV file.

Hope it will help u.

Re: csv tab delimited problem

Former Member — Wed, 12 Jan 2011 05:28:24 GMT

Hi Rajesh,

Thanks for your reply.

I have simply tab delimit we use this. But my question is - is there any thing specific as csv tab delimited.

Because i need to store it as .csv file in AL11 directory and it should be tab delimited. how to achieve this.

Re: csv tab delimited problem

Former Member — Tue, 26 Jul 2011 09:29:15 GMT

hi sri,

even iam facing the same issue...do you got any solution for this ?if so kindly guide me how to achieve.

thanks

Vamshi ..

Re: csv tab delimited problem

Former Member — Wed, 22 Jan 2014 19:32:43 GMT

I have the same problem also. any suggestions is a big help!!

Re: csv tab delimited problem

sivaprasad_paruchuri — Thu, 23 Jan 2014 04:24:49 GMT

hi,

DATA : FILENAME(128) DEFAULT '/usr/......../file.csv'. "" Your path in app server

DATA : lv_str type string.

data: l_seperator TYPE c.

CLASS cl_abap_char_utilities DEFINITION LOAD.

l_seperator = cl_abap_char_utilities=>horizontal_tab.

OPEN DATASET FILENAME FOR OUTPUT IN TEXT MODE.

CHECK sy-subrc EQ 0.

loop at i_item.

CONCATENATE

i_item-FIELD_1

i_item-FIELD_2

i_item-FIELD_3

i_item-FIELD_4

i_item-FIELD_5

into lv_str

SEPARATED BY l_separator.

transfer lv_str to filename.

endloop.

* Close File

CLOSE DATASET FILENAME.

regards,

Siva Prasad