junk values while uploading .txt file to application server

[Former Member]

hi Mates,

i have received a .txt file from a non sap system and i am uploading the same to sap application server.

there are two problems in this regards,

when i upload the file from CG3Z transaction,

case 1: i upload it with BIN format option in cg3z. the data records get uploaded with juck values as shown below

actual value - 001750.

loaded value - #0#0#1#7#5#0#

i can see juck values till 550 characters length.

case2: i upload it with ASC format option in cg3z. this time there is no juck values in the application server file but there are only 256 character visible in al11. please note that i have read the file in my program and tested it, it fetches only 256 characters. also i have downloaded the same file using cg3y transaction, the dowloaded file has values till 256 character only.

kindly advise the issues,

thanks

Mano

[Former Member]

hi Mates,

i have received a .txt file from a non sap system and i am uploading the same to sap application server.

there are two problems in this regards,

when i upload the file from CG3Z transaction,

case 1: i upload it with BIN format option in cg3z. the data records get uploaded with juck values as shown below

actual value - 001750.

loaded value - #0#0#1#7#5#0#

i can see juck values till 550 characters length.

case2: i upload it with ASC format option in cg3z. this time there is no juck values in the application server file but there are only 256 character visible in al11. please note that i have read the file in my program and tested it, it fetches only 256 characters. also i have downloaded the same file using cg3y transaction, the dowloaded file has values till 256 character only.

kindly advise the issues,

thanks

Mano

[Former Member]

Hi,

Are there any tabs in the .txt. I think # is because of the tab

Regards,

Naveen

[Former Member]

hi,

Those '#' are nothing But Tabs.

They are equivalent to Tabs.

if you don't want them to see you have to upload a plain text file.

Programatically you can replace them when you are reading if you wnat..

Using CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB you can replace them inside a program.

You can also use function module ARCHIVFILE_SERVER_TO_CLIENT and ARCHIVFILE_CLIENT_TO_SERVER instead of cg3z and cg3y.

Thanks

Ajay

[Former Member]

any comments on Case 2 ?

thanks

Mano