topic Re: tab delimited in Application Development and Automation Discussions

tab delimited

Former Member — Tue, 05 Jun 2007 19:16:04 GMT

I need to create a tab delimited file. I am creating file using open dataset

How do i create a tab delimited file

create structure of filecontents 

open dataset file for output 

move values to filecontents 

transfer filecontents to file 

close dataset

Re: tab delimited

RichHeilman — Tue, 05 Jun 2007 19:21:53 GMT

Check this example.



report zrich_0001.

parameters: d1 type localfile default '/usr/sap/TST/SYS/Test.txt'.

data: begin of itab occurs 0,
      field1(20) type c,
      field2(20) type c,
      field3(20) type c,
      end of itab.
data: str type string.

constants: con_tab type x value '09'.

* if you have a newer version, then you can use this instead.
*constants:
*    con_tab  type c value cl_abap_char_utilities=>HORIZONTAL_TAB.

start-of-selection.

itab-field1 = 'ABC'.
itab-field2 = 'DEF'.
itab-field3 = 'GHI'.
append itab.

itab-field1 = '123'.
itab-field2 = '456'.
itab-field3 = '789'.
append itab.

  open dataset d1 for output in text mode.
  loop at itab.
    concatenate itab-field1 itab-field2 itab-field2 into str
                  separated by con_tab.
    transfer str to d1.
  endloop.
  close dataset d1.

Regards,

Rich Heilman

Re: tab delimited

Former Member — Tue, 05 Jun 2007 19:52:17 GMT

constants: con_tab type x will not work as concatenate needs separated by to be followed by character

constants: con_tab type c value cl_abap_char_utilities=>HORIZONTAL_TAB.

does not work either . it simply displays a hash

Re: tab delimited

RichHeilman — Tue, 05 Jun 2007 19:58:21 GMT

<i>it simply displays a hash</i>

This is an internal representation of the tab, in the file there will be a tab and not a #

Regards,

RIch Heilman

Re: tab delimited

Former Member — Tue, 05 Jun 2007 20:29:23 GMT

Thank you