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

please help

Former Member
0 Likes
656

Hi all,

I've created a text delimited file which have 3 columns.... now when I'm trying to upload it.....in the output I'm getting only the first column and the other columns as # can anyone help me in solving this plz.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
639

if you are using gui_upload

then take the field sperator as 'X'.

else tell me which FM you are using to upload the file

thnkx

bhanu

5 REPLIES 5
Read only

Former Member
0 Likes
639

Hi

First create your file in EXCEL with columns

remove the column headings

then save that Excel file as TAB DELIMITED Text file

and if texts are there try to find and replace some unwanted characters like " or #

then that fiel is ready for upload

now use that for BDC program and upload

it will work

declare internal table similar to that fiel fields and use

<b>Reward points for useful Answers</b>

Regards

Anji

Read only

Former Member
0 Likes
639

hi,

Give the FIELD-SEPERATOR = '#'.

Read only

sharadendu_agrawal
Active Participant
0 Likes
639

Check the data types of theother 2 colums while uploading it.

Reward if useful

cheers,

sharadendu

Read only

Former Member
0 Likes
639

Hi,

set the separator tab in the FM to space i.e; ' ' or try using ' \ '.

Pls reward helpful files.

Regards,

Ameet

Read only

Former Member
0 Likes
640

if you are using gui_upload

then take the field sperator as 'X'.

else tell me which FM you are using to upload the file

thnkx

bhanu