Skip to main content
  • EN

Hello all ! I need to create CSV where value will end  with a semicolon. I can do it using AttributeManager > @SetValue(SUP); but in that case it would add “ “ between attribute because it is converted to varchar. I need it without those “ “ but can’t manage to do it.

Example below : 1st is my output and second is what i want. Only difference is those “ “.

PS : Title is correctly formatted

CODE_AL;NUM_AL;LIBELLELOL;LIBELLEC;SECTSTAT;ANCIENNE_C;NOUVELLE_C;CODE_POSTAL;PRO;REGION;PAYS;POP;SUP
10;10;GEROMPONT Avenue des Déportés 74;GEROMPONT ;25122C11-;Gérompont;Ramillies;1367;Brabant Wallon;Région Wallonne;BELGIQUE;82;"0,099368;"
CODE_AL;NUM_AL;LIBELLELOL;LIBELLEC;SECTSTAT;ANCIENNE_C;NOUVELLE_C;CODE_POSTAL;PRO;REGION;PAYS;POP;SUP
10;10;GEROMPONT Avenue des Déportés 74;GEROMPONT ;25122C11-;Gérompont;Ramillies;1367;Brabant Wallon;Région Wallonne;BELGIQUE;82;0,099368;

​@fmetutorial Could you share (part) of the CSV file ?

You should be able to make amendments in the advanced settings to prevent the field being quoted and to allow the ; that is part of the SUP attribute to be written

 

Thans for your answers.
​@lambertus , i’ve linked part of my CSV file

​@ebygomm , Which transformer are you talking about to access advanced settings ?

Thanks for help !

The advanced settings are in the csv writer

​@ebygomm I could not see those options in my writer. Do you mind sharing the whole window instead ?

 

 

Reply


Community Stats

30,144
Posts
114,422
Replies
37,786
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.