topic Re: Constant value in csv output from Data Mapper keeps having quotes in Talend Studio

Constant value in csv output from Data Mapper keeps having quotes

Jacco_De_Zwart — Mon, 02 Dec 2024 09:57:15 GMT

Hi all,

I use tHmap to extract data from json and place it in a csv file.

Al goes well, except that one column has a constant value. I have delcared the mapping for that column with the mapper function 'constant' and typed the value.

The setting in the representation for csv output is 'Quote mode" "None". That should be enough to have no quotes surrounding the values.

All the other string column have no quotes in the output file. Only the column that I have defaulted with the constant function has quotes.

How do I get rid of these quoutes ?

Thanks in advance

Re: Constant value in csv output from Data Mapper keeps having quotes

Sonal_Reddy_18 — Mon, 02 Dec 2024 17:57:24 GMT

Hi , Can you once try by removing the double quote from "Quote Character" Tab in the CSV Properties.

Re: Constant value in csv output from Data Mapper keeps having quotes

Jacco_De_Zwart — Tue, 03 Dec 2024 08:06:00 GMT

Sonal,

Thanks for your suggestion. After some fidling around I found out that is not in the CSV properties panel, but it is due to the tailing spaces.

From one point I understand, spaces always give headaches, but on the other hand, the CSV properties panel is pretty clear on how to use quotes.

When you configure 'Never' quote values, then tHmap should never quote values. There might be a good practical reason for doing so.

Anyway, thanks for you suggestion. I got it working now.

Jacco

Re: Constant value in csv output from Data Mapper keeps having quotes

Jacco_De_Zwart — Tue, 03 Dec 2024 08:07:16 GMT

I solved it myself after some fidling around. Remove the trailing spaces from the value Cylinder/Roll/Tube.

Problem solved, albeit strange since the CSV properties panel is pretty explicid on how to handle quotes.

Jacco