Skip to main content
Question

Export as CSV without " "

  • November 15, 2024
  • 6 replies
  • 43 views

fmetutorial
Contributor
Forum|alt.badge.img+1

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;

6 replies

lambertus
Enthusiast
Forum|alt.badge.img+15
  • Enthusiast
  • November 15, 2024

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


ebygomm
Influencer
Forum|alt.badge.img+38
  • Influencer
  • November 15, 2024

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

 


fmetutorial
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • November 15, 2024

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 !


ebygomm
Influencer
Forum|alt.badge.img+38
  • Influencer
  • November 15, 2024

The advanced settings are in the csv writer


fmetutorial
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • November 15, 2024

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

 


ebygomm
Influencer
Forum|alt.badge.img+38
  • Influencer
  • November 15, 2024

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings