topic Re: Problem while uploading data to server in Application Development and Automation Discussions

Problem while uploading data to server

Former Member — Thu, 26 Feb 2009 11:52:13 GMT

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

Re: Problem while uploading data to server

Former Member — Thu, 26 Feb 2009 11:55:03 GMT

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

Re: Problem while uploading data to server

Former Member — Thu, 26 Feb 2009 11:56:08 GMT

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

Re: Problem while uploading data to server

Former Member — Thu, 26 Feb 2009 11:56:24 GMT

Hi naveen,

Its of type string.

Re: Problem while uploading data to server

Former Member — Thu, 26 Feb 2009 11:56:43 GMT

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

Re: Problem while uploading data to server

Former Member — Thu, 26 Feb 2009 11:58:46 GMT

Hi Anil,

Its TAB delimited, i want to remove that "#" in the uploaded file.

Regards

Sree

Re: Problem while uploading data to server

Former Member — Thu, 26 Feb 2009 11:59:29 GMT

Hi sreedevi ,

paste the code .

Regrds ,

naveen

Edited by: Naveen Deva on Feb 26, 2009 1:00 PM

Re: Problem while uploading data to server

former_member222860 — Thu, 26 Feb 2009 12:07:39 GMT

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

Re: Problem while uploading data to server

Former Member — Thu, 26 Feb 2009 12:12:58 GMT

Problem is resolved. Thankyou:)