Added fixed spaces in output columns

[Former Member]

Hello experts,

how to add fixed spaces in between columns?

i am using concatenated statement.

concatenate... into line separated by... (here i want 8 spaces).

I am uploading data on application server.

how to add fixed spaces??

Thanks in advance.

Saurabh

[Former Member]

Hi,

declare a variable like:

v_space(8) type c value ' '.

Then use concatenate f1 f2 into fn separated by v_space.

Thanks & Regards,

Navneeth K.

[Former Member]

Try using OFFSET operations.

~Eswar

[Former Member]

>

> Hello experts,
> 
> how to add fixed spaces in between columns?
> i am using concatenated statement. 
> concatenate... into line separated by... (here i want 8 spaces).
> 
> I am uploading data on application server.
> 
> how to add fixed spaces??
> 
> Thanks in advance.
> 
> Saurabh

If you give 8 space characters it would not work. Try '########' or any other character and then use replace statement to replace '#' with ' '. It will work.

Regards,

Prashant.

[rainer_hbenthal]

concatenate `Hello` `        ` `World` into s in character mode.
write:/ s.

Note thate the literals are enclosed in back quotes and not in apostrophes, this makes them to strings which can contain spaces at the end.

[Former Member]

hello saurabh kulkarni ,

You use this solution just know i tryed in this way...

example:

DATA: y_v_message TYPE char1024,

y_v_char TYPE char8 value ' '. i.e. y_v_char is 8 spaces.

CONCATENATE '0009090909' ' ' '89389383'

INTO y_v_message

SEPARATED BY y_v_char.