Constant value in csv output from Data Mapper keeps having quotes

[Jacco_De_Zwart]

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

[Sonal_Reddy_18]

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

[Jacco_De_Zwart]

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

[Jacco_De_Zwart · Accepted solution]

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