Remove new line characters

Echo

Hi all,

I am trying to remove new line characters present in the data.

Currently we are using the "formula" macro and input Regex_Replace([FIELD], "\r*\n*", "") for each and every field.

When working with 100+ columns it becomes very cumbersome.

Is there a way to remove new line characters in one go from all columns?

Thanks.

Join

Accepted answers

s_pichaipillai

In multi filed toold-->configuration --> select the "text" fileds as you have the New lines in string fileds

it will display all the string fileds then click on All

in the exp, Please the " Regex_Replace( [_CurrentField_], "\r*\n*", "")"

where _CurrentField_ is for all selected string fileds

Refer the below image

All comments

danielbrun2

Hi,

I would consider to transpose all the columns and then remove it from the
data column. After removing new line chars you can then crosstab the data
back to normal. To transpose data you can watch this video.

https://vimeo.com/146105160

Best regards,
Daniel

--
Daniel Brun
+45 21 25 61 20 <++45+21+25+61+20>

a.Flæsketorvet 68, 1711 København Ve.daniel@inviso.dkt.@DanielPBrun
l.linkedin.com/in/danielbrunw.inviso.dk
Prøv Tableaueller Alteryxgratis i dag

s_pichaipillai

Echo,

try with "Multi-Field Formula" tool, then choose the fileds you want to remove new lines something like this Regex_Replace( [_CurrentField_], "\r*\n*", "")

i hope this way you can apply the same logic for multiple fileds in one go

Echo

Hidanielbrun,

Thanks for your reply.

The problem is that new line characters are present in the headers as well as the data.

So transposing won't help.

Any other suggestions?

Echo

In the "Multi-Field Formula" tool, what syntax do we use to select all fields in the expression box??

Regex_Replace( [_ALLField_], "\r*\n*", "")

What do we use in place of ALLFIELDS?

nicho_x86

The new line can be treated as a character when specifying the standard assigned integer to it.

The following will remove new line from the current field (10 is the code for new line):

ReplaceChar([_CurrentField_],CharFromInt(10),"")

JesterOne

My Solution

Spoiler

challenge_16_start_file SOLVED.yxmd

NicolasSz

Hey,

Just a quick update on this for those that want to replace the carriage return by another character.

You should be using : Regex_Replace([FIELD], "\r*\n", "") and not a * after the n.

Else it matches with all char.

Regards

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

Aguisande 317