Remove all data in field after character '='

[bh1789]

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 =

[apathetichell]

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

[binuacs]

@bh1789 One way of doing this

[DataNath · Accepted solution]

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

[bh1789]

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

[bh1789]

thank you very much, that worked