Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Problem while uploading data to server

Former Member
0 Likes
819

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

8 REPLIES 8
Read only

Former Member
0 Likes
797

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

Read only

0 Likes
797

Hi naveen,

Its of type string.

Read only

0 Likes
797

Hi sreedevi ,

paste the code .

Regrds ,

naveen

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

Read only

Former Member
0 Likes
797

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

Read only

0 Likes
797

Hi Anil,

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

Regards

Sree

Read only

Former Member
0 Likes
797

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

Read only

0 Likes
797

Problem is resolved. Thankyou:)

Read only

former_member222860
Active Contributor
0 Likes
797

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