We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Endofline / end of row delimeter?

tmb088
6 - Meteoroid

Good Afternoon,

 

I have an output of a csv file.  I need to add an EOL  indicator string such as '<rowsep>' is there anyway I can do that....I managed to do custom column separators/delimiters.  Is there a way to add that? 

4 REPLIES 4
DataNath
17 - Castor
17 - Castor

Hey @tmb088 - usually '\n' is used to denote a linebreak/end of row. Will that work for you?

FinnCharlton
13 - Pulsar

Hi @tmb088 , do you mean you want to replace EOL with a tag? You can do it like this:

 

image.png

tmb088
6 - Meteoroid

in this case it needs to be <rowsep> as it will then be imported in other software which requires it.   But im still interested to know how to add '/n' per row

tmb088
6 - Meteoroid

thanks I will try that.

 

Currently the csv is output as:

Name<colsep>Surname<colsep>Mobile<colSep>  

Name2<colsep>Surname2<colsep>Mobile2<colSep>  

 

<colsep> is the delimiter of the csv output.

 

at the end of each line I need to have <rowsep>

 

Name<colsep>Surname<colsep>Mobile<colSep> <rowsep> 

Name2<colsep>Surname2<colsep>Mobile2<colSep><rowsep>  

Labels
Top Solution Authors