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