Pipe delimited File format

[Former Member]

Hi ,

How to write a pipe delimited file format in Appliacation Server.

Help me out to solve this.

Thanks.

[Former Member]

Hi ,

How to write a pipe delimited file format in Appliacation Server.

Help me out to solve this.

Thanks.

[Former Member]

HI,

check these links...

or do you mean application server?

then use open dataset. transfer and close dataset.

example:

DATA: e_file like rlgrap-filename value '/usr/sap/tmp/file.txt'.

open dataset e_file for output in text mode.

lOOP AT it_datatab......

transfer it_datatab to e_file.

ENDLOOP.

close dataset e_file.

Regards

Sudheer

[Former Member]

Hi sudheer,

Yes it is for appliaction server.

but my requirement is to have pipe delimited file in appliaction server.

at the end of each field i should have pipe symbol.

can you explain about the pipe delimited file.

eg : 1000|test the a|78989.090|hi sudheer|

[Former Member]

The code is:

data: wa(100).

concatenate '1000' 'test material' '345' into wa separated by '|'.

This will write the three fields above into the work area with a pipe symbol between each field.

Please reward with points if helpful.

[Former Member]

Hi Raj,

Assume that you have an internal table ready to be written to the application server.

then do this

open dataset dsn for output in text mode.

loop at itab.

concatenate itab-field1 itab-field2 itab-field3...into v_str separated by '|'.

transfer v_str to dsn.

endloop.

close datset dsn.

• dsn is the spplication server file name.

Regards,

Ravi