Special characters in flat file output

Hi,

I need to export data in a fixed width formatted file. If a special character like (ö,ü,ä or ß) is present in a value, the export is wrongly formatted.

For example, if I have the word SÜD and set the export to a WSTRING 3, the output file will have SÜ in it. (input file and output file have both UTF-8 as code page)

I suppose that the designer interprets süd as sÃ¼d or something like that and cut the last character of the string.

Do you have any idea on how to fix this?

Regards

Output

Transformation

Bug

Accepted answers

Try setting Code Page (#4) to ISO 8859-2 Central Europe in the OUTPUT Tool.

Cheers,

Mark

All comments

A special character like ü takes 2 bytes, so you can't set your string length to 3. You'd have to make it 4 bytes in this case.

You can test it here.

Hope that helps!

Katrin

Hi Kat,

Yes, that's the point. but if I set the length of a string to be of 3 characters long, I expect it to be 3 characters long.

For me the problem is that the designer concate the string without taking the encoding into account.

Do you have any other ideas?

Thibaut

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703