Skip to Content
0
Former Member
Dec 11, 2006 at 07:17 AM

output data to txt file with full length of the field as in database

41 Views

Hi

I have a problem related to output data I ntxt file on server

for eg

CONCATENATE

wa_sagadr_outtab-seqno

wa_sagadr_outtab-bpext

wa_sagadr_outtab-name_org1

wa_sagadr_outtab-country INTO wa_sagadr_text SEPARATED BY ''.

the output is separated by single space irrespective of database length of the field , I want to display all the lenth of the database field eventhough the remaining space is blank ie if a field is 20 char in dtabase and only filled with 6 char the whole 20 char lenth should be displayed in the output file

ouput as below

required format ie space equvalent to as in database lenght

000001 700006 C4 Plant AMD Export Sdn.Bhd.so on.

my format as coming single space in between only

000001 700006 C4 Plant AMD Export Sdn.Bhd

pls suggest