csv file format problem

[Former Member]

prodorder;batchno ;text1 ; text2; text3;text4;text5;

"100001012;0008339492;487-07-G1;22;6,86;000081022G; "

"100001013;0008339493;487-07-G1;22;6,86;000081022E;1 "

This is my sample csv file.

i want to upload using bdc.

im splitting the internal table and uploading like this.

call function 'GUI_UPLOAD'

exporting

FILENAME = FILE

FILETYPE = 'ASC'

• has_field_separator = ','

• HEADER_LENGTH = 0

• READ_BY_LINE = 'X'

• DAT_MODE = ' '

• CODEPAGE = ' '

• IGNORE_CERR = ABAP_TRUE

• REPLACEMENT = '#'

• CHECK_BOM = ' '

• IMPORTING

• FILELENGTH =

• HEADER =

tables

DATA_TAB = ITAB

loop at ITAB.

split ITAB at ';' into ITAB1-AUFNR

ITAB1-CHARG

ITAB1-TEXT1

ITAB1-TEXT2

ITAB1-TEXT3

ITAB1-TEXT4

ITAB1-TEXT5.

append ITAB1.

endloop.

But finally im getting output as

"100001012 in ordernumber of co01 transaction.

it should display 100001012 in ordernumber field.

please suggest how we can rectify this problem.

[Former Member]

Hi Vijay,

I can sugest you one thing. Before splitting ITAB at " , " .

use REPLACE command to remove inverted code value ( " ) .

Eg Loop at Itab.

REPLCE ALL OCCURANCES OF " WITH SPACE ( Check syntax).

Hope this will solve your problem.

Regards

Sourabh

[Former Member]

Hi Vijay,

I can sugest you one thing. Before splitting ITAB at " , " .

use REPLACE command to remove inverted code value ( " ) .

Eg Loop at Itab.

REPLCE ALL OCCURANCES OF " WITH SPACE ( Check syntax).

Hope this will solve your problem.

Regards

Sourabh

[Former Member]

Thanks a lot buddy.