tab delimeted text file

[Former Member]

Hi Group,

How to upload tab delimeted text file using FM KCD_CSV_FILE_TO_INTERN_CONVERT or is there any other way.

I am using text file with header text and the data will start from second row.

[Former Member]

use CALL FUNCTION 'WS_UPLOAD'

EXPORTING

filename = path

filetype = 'DAT' "txt

Regards

[Former Member]

Hi ,

Use like this .

constants: c_hex_tab type x value 9.

call function 'KCD_CSV_FILE_TO_INTERN_CONVERT'

exporting

i_filename = filename

i_separator = l_separator

tables

e_intern = l_intern

exceptions

upload_csv = 1

upload_filetype = 2

others = 3.

where l_separator = c_hex_tab. " for tab delimitter

Regards,

GSR.

[Former Member]

Hi Srinivas,

How to start from second row,as my first row contains header information so I have to start from second row,please suggest

[Former Member]

After the upload, just delete the first row.

[Former Member]

Instead use FM : GUI_UPLOAD

here u can import the Header info into some other String

[Former Member]

Hi Srinivas Reddy,

How to pass the header info in to some other String,

can you please suggest

[naimesh_patel]

you can use

WS_UPLOAD or UPLOAD Fm, give filetype = 'DAT'.

You have to make you itab which can contain all your records. I mean if you first field of header is char 5 and item row it is char 10,then you have to make your itab-field1 as char 10..

Regards,

Naimesh

Reward points, if you find good..!