topic Re: Pipe delimited File format in Application Development and Automation Discussions

Pipe delimited File format

Former Member — Fri, 02 Feb 2007 05:44:58 GMT

Hi ,

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

Help me out to solve this.

Thanks.

Re: Pipe delimited File format

Former Member — Fri, 02 Feb 2007 05:47:48 GMT

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

Re: Pipe delimited File format

Former Member — Fri, 02 Feb 2007 06:03:34 GMT

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|

Re: Pipe delimited File format

Former Member — Fri, 02 Feb 2007 09:48:17 GMT

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.

Re: Pipe delimited File format

Former Member — Fri, 02 Feb 2007 09:51:56 GMT

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