topic Re: Issue with special character in tFileOutputDelimeted component in Talend Studio

Issue with special character in tFileOutputDelimeted component

Anonymous — Sat, 16 Nov 2024 06:53:50 GMT

Hi,

I am extracting a query result to tFileOutputDelimeted component(.csv file).

String has to be "can't" but, it is saving in .csv file as "can?t". Why am I getting this?

Can anyone help me out?

Thanks in advance,

Meghana.

Re: Issue with special character in tFileOutputDelimeted component

ankit7359 — Wed, 09 Jan 2019 10:05:23 GMT

Hi @MeghanaKottala,

Can you pls share a sample input data and also can you also share the job screenshot with result such that Community can look into the issue you are facing?

Pls do get back to Community,if necessary.

Thanks,

Ankit.

Re: Issue with special character in tFileOutputDelimeted component

Anonymous — Wed, 09 Jan 2019 10:34:20 GMT

Here is the screenshot.

The query results in one string column which has result like this "youíve" and when I run this job, I am getting the result as "you?ve".

Am I clear

Screen Shot 2019-01-09 at 4.02.20 PM.png

Re: Issue with special character in tFileOutputDelimeted component

akumar2301 — Wed, 09 Jan 2019 11:27:57 GMT

Try to change the encoding to ISO-8859-15

Re: Issue with special character in tFileOutputDelimeted component

Anonymous — Wed, 09 Jan 2019 11:42:59 GMT

I am using the same

Thanks,

Meghana

Re: Issue with special character in tFileOutputDelimeted component

PhilHibbs — Thu, 10 Jan 2019 09:31:11 GMT

When you say it is "saving as can?t", what do you mean? Is it literally a question mark in the output file, or is the reading method converting a character that it doesn't understand into a question mark? How are you viewing the output?

I suspect that your input isn't "can't", I bet it is "can’t" (which has a typographical apostrophe, rather than the plain ASCII apostrophe). ISO8859-15 does not have typographical or “directional” quotes, so it can't be written using that encoding.

Using a larger font, ' is ASCII, but ’ is not, and is not supported by ISO8859 character sets.

https://practicaltypography.com/straight-and-curly-quotes.html

Re: Issue with special character in tFileOutputDelimeted component

Anonymous — Tue, 15 Jan 2019 05:33:21 GMT

The issue has been solved. Changed encoding to UTF-16 and it is working. Thanks for the reply.

Thanks,

Meghana.