Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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