upload a file from presentation server

[Former Member]

hello..

Please help me in the below problem !

When I am uploading a space delimited (.prn) file from presentation server, into an internal table the different fields are not recognized. the data is uploaded according to the length of the field defined in the internal table and hence correct data is not going into the fields in the internal table

for example: if in the file i have the two fields with values

HELLO HOW

and if my internal table has two fields with lengths 8 and 10

i am getting HELLOHOW into first field and blank in next field. How to differentiate the fields?

i am using file type ASC and field separator = 'X'.

I tried with tab delimited file, i am having the same problem.

Thank you,

Rushi

[Former Member]

Try a comma seperated file and use the split at , into respective fields.

Thanks

Kiran

Edited by: kiran dasari on Oct 22, 2008 7:46 PM

[Former Member]

Hi,

Try using the SPLIT AT statement for the purpose.

Regards

Lekha

[BH2408]

Hi ,

Try to create the correct flat file ..while creating use the seperator TAB or pipe .

regards,

Bharani

[Former Member]

Hello Bharani,

How to create the correct flat file? I am having data in a excel sheet, and i saved as a tab delimited file while saving it. I am still having the same problem. fiels values ar enot recognised. Please suggest!.

Thank you,

Rushi

[Former Member]

Hi Rushi,

I have search in SDN for half an hour for your query please do search SDN before posting. As i seen before some good material while we upload the EXCEL with tab delimiter (.prn file)

Check this link your issue will be solved this this complete steps are shown for BDC adjust the code according to your requirement.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/309cb157-738d-2910-7691-b74c4ddb...

Cheers!!

Balu

[Former Member]

Balu,

Thank you very much for ur help ! Next time I will search for an hour before posting ! Sorry about that !.

Thanks again!,

Rushi

[Former Member]

Hi never mind dude, actually many people will be spending there precious time to solve other issues, if i see same repeating post of same quiz questions or any normal issues then i always suggest the poster's to search before they post because definitely there will be some or the post related to the post they send.

Anyways happy to see your query is been solved.

Happy Posting

Cheers!!

Balu