We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.
Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

Export to csv issue with spaces

Comments

3 comments

  • Avatar
    Gerard Cafaro

    The Output csv/delimited node trims excess trailing and leading spaces per field. Since your LINEOUT variable is acting as a single field, adding the extra comma to the end "protects" the spaces from getting trimmed. 

    While testing this internally, I also noticed that the Output csv/delimited node uses RFC-4180 as its default csv definition. RFC-4180 says trailing and leading spaces shouldn't be trimmed, so I'll check internally on this too, but in the meantime, if you're able to add any extra character after the spaces, that will keep the spaces in-tact.

    0
    Comment actions Permalink
  • Avatar
    Geoff

    for the moment, i have added quotes... "   " thanks for checking on it, It would be nice if it acted the way the LAE version did so in the event the spaces are truly needed, it will leave them

     

    Thanks!

    0
    Comment actions Permalink
  • Avatar
    Adrian Williams

    We have created a development request to modify the node to allow surrounding white space characters to be retained or trimmed from values when writing the data

    0
    Comment actions Permalink

Please sign in to leave a comment.