In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Remove all data in field after character '='

bh1789
8 - Asteroid

if I have several lines of data in one column:

 

V6ZncXfFmyTEUG= <br> <br> 

qQtR+Dpdp43zXznoU15Gtw2jQhw= <br><br>

aQ5zEgMOkmtbAaoqQI8DpjsjtHU=<br>

 

how would I remove everything after the =

 

5 REPLIES 5
apathetichell
19 - Altair

regex_replace([field1],"^(.*\=)(.*)","$1")

binuacs
21 - Polaris

@bh1789 One way of doing this

binuacs_1-1666621742647.png

 

 

DataNath
17 - Castor
17 - Castor

Here's one way of approaching this with a couple of regular string functions:

 

DataNath_0-1666621722927.png

bh1789
8 - Asteroid

how would I use this solution in a multi line dataset so that line after line would clean after the "=" character?

 

bh1789
8 - Asteroid

thank you very much, that worked

Labels
Top Solution Authors