topic Re: Open data set in Application Development and Automation Discussions

Open data set

Former Member — Mon, 02 Feb 2009 05:31:41 GMT

Hi experts ,

when i reading a text file using open data set coding, content are coming like this

0002#######sachin############indara market.

aithough i save text file in tab saprater.i want to read field seprately

like 0002 sachin indra market.

how i can solve this problem .

Thanks & Rgds

Re: Open data set

Former Member — Mon, 02 Feb 2009 05:54:03 GMT

Hi Zeba,

Which is the function module you are using? and also check the file type it should be 'DAT'

if you are using GUI_UPLOAD then pass 'X' to the parameter has field seperator and give a try.

Regards,

Ranjith N

Re: Open data set

Former Member — Mon, 02 Feb 2009 05:57:45 GMT

you can use

OPEN DATASET gv_file FOR INPUT IN TEXT MODE ENCODING DEFAULT

WITH SMART LINEFEED.

Re: Open data set

Former Member — Mon, 02 Feb 2009 06:31:13 GMT

Hi ,

Kindly go through this link:

Hope it helps you

Regrds

Mansi

Re: Open data set

Former Member — Tue, 03 Feb 2009 06:59:01 GMT

hi chenna,

Thanks for ur reply.

its not working , still data is coming like this 0001#######ISRIAL khan#####indra market.

Thanks & Rgds

Zeba

Re: Open data set

Former Member — Tue, 03 Feb 2009 07:11:44 GMT

Hi,

Declare the internal table with these fields and using Read read the data from the application server to the itab instead of text table..


DATA : Begin of itab occurs 0
               field1 type ...
               field2 type ...
               field3 type...
          END of itab.

READ DATASET filename INTO datatab.

When uploading the data to application server the tab delimitor is used because of which you are getting # symbols.