Problem reading csv file with special character

[Former Member]

Hai all,

i have the following problem reading a csv file.

442050-Operations Tilburg algemeen Huis in t Veld, EAM (Lisette) Gebruikersaccount 461041 Peildatum: 4-5-2010 AA461041 1 85,92

when reading this line with FM GUI_UPLOAD this line is split up in two lines in data_tab of the FM,

it is split up at this character

Line 1

442050-Operations Tilburg algemeen Huis in

Line 2

t Veld, EAM (Lisette) Gebruikersaccount 461041 Peildatum: 4-5-2010 AA461041 1 85,92

Anyone have a idea how to get this in one line in my interbal table??

Greetz Richard

[Former Member]

Hai all,

i have the following problem reading a csv file.

442050-Operations Tilburg algemeen Huis in t Veld, EAM (Lisette) Gebruikersaccount 461041 Peildatum: 4-5-2010 AA461041 1 85,92

when reading this line with FM GUI_UPLOAD this line is split up in two lines in data_tab of the FM,

it is split up at this character

Line 1

442050-Operations Tilburg algemeen Huis in

Line 2

t Veld, EAM (Lisette) Gebruikersaccount 461041 Peildatum: 4-5-2010 AA461041 1 85,92

Anyone have a idea how to get this in one line in my interbal table??

Greetz Richard

[former_member214857]

Hi Greetz Richard

Problably character contains same binary code as line feed + carriage return.

You can use statement below as workaround.

OPEN DATASET file FOR INPUT IN TEXT MODE ENCODING UNICODE

In this case your system must support Unicode encoding

Kind regards