topic Re: please help in Application Development and Automation Discussions

please help

Former Member — Wed, 18 Jul 2007 05:49:21 GMT

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.

Re: please help

Former Member — Wed, 18 Jul 2007 05:51:42 GMT

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

Re: please help

Former Member — Wed, 18 Jul 2007 05:52:34 GMT

hi,

Give the FIELD-SEPERATOR = '#'.

Re: please help

sharadendu_agrawal — Wed, 18 Jul 2007 05:53:29 GMT

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

Reward if useful

cheers,

sharadendu

Re: please help

Former Member — Wed, 18 Jul 2007 05:54:29 GMT

Hi,

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

Pls reward helpful files.

Regards,

Ameet

Re: please help

Former Member — Wed, 18 Jul 2007 05:56:33 GMT

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