‎2009 Feb 26 11:52 AM
Hi all,
I have uploaded data directly to application server from itab using Open dataset,transfer,and close dataset. But i am getting "#' in between the records. I tried to ignore that using
REPLACE ALL OCCURRENCES OF '#' IN str WITH ',' & also tried with SPLIT file at comma separator, but its coming the same. Can you anybody give the solution to remove #.
Regards
Sree
‎2009 Feb 26 11:55 AM
Hi,
IS this ECC6 system which you are working?
please provide the structure which you are using to transfer to file.
transfer str to file.
revrt back with str structure as i need to check the type attributes of fileds of structure.
Regards,
Naveen
‎2009 Feb 26 11:56 AM
‎2009 Feb 26 11:59 AM
Hi sreedevi ,
paste the code .
Regrds ,
naveen
Edited by: Naveen Deva on Feb 26, 2009 1:00 PM
‎2009 Feb 26 11:56 AM
Hi Sree,
Your file is TAB delimited, that is why you are getting # after every fields in the application sevrer file.
What is your exact problem????
Regards,
Anil
‎2009 Feb 26 11:58 AM
Hi Anil,
Its TAB delimited, i want to remove that "#" in the uploaded file.
Regards
Sree
‎2009 Feb 26 11:56 AM
HI,
Instead of transfer wa to file concatenate the fields with comma and then transfer.
Concatenate wa-field1 wa-field2 wa-field3 ....wa-fieldn To string.
Transfer string to p_file
‎2009 Feb 26 12:12 PM
‎2009 Feb 26 12:07 PM
Hi,
Use the addition REPLACEMENT CHARACTER for open dataset, by default '#' is used as the replacement char.
here's the syntax.
OPEN DATASET dsn REPLACEMENT CHARACTER rc
and pl, check F1 help for more info,
thanks\
Mahesh