topic Re: regarding flat file in Application Development and Automation Discussions

regarding flat file

Former Member — Fri, 20 Jun 2008 08:36:26 GMT

hi all

i got a flat file with some fields separated by space and some fields by comma .

how to handle the situation.

thnaks in advance

prasanna kumar

Former Member — Fri, 20 Jun 2008 08:38:03 GMT

From where are you getting this flat file?

M S DhanaLakshmi

Former Member — Fri, 20 Jun 2008 08:41:16 GMT

while downloading use field separator,

thn you will get same for all.

Former Member — Fri, 20 Jun 2008 08:42:19 GMT

first declare on itab: itab1

like filed(250).

declare another itab : itab2 (declare here what are field in falt file)

after that using split command and pass the filed value to correspoing

field of tab2.

afther using bdcdata, upload the db

peter_ruiz2 — Fri, 20 Jun 2008 08:42:19 GMT

hi,

use the FM WS_UPLOAD.

your data will be saved on an internal table with only one field.

the field will then contain a line from your flat file. from there, use SPLIT to separate the values of the field.

regards,

Peter

Former Member — Fri, 20 Jun 2008 12:01:25 GMT

When you are downloading data from the flat file, use the field seprator.

it will resolve your problem.

Rewards Points if useful.

Thanks & Regards

Nikunj Shah