SOLVED
Remove all data in field after character '='
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
bh1789
8 - Asteroid
‎10-24-2022
07:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 =
Solved! Go to Solution.
Labels:
- Labels:
- Parse
5 REPLIES 5
apathetichell
19 - Altair
‎10-24-2022
07:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
regex_replace([field1],"^(.*\=)(.*)","$1")
binuacs
21 - Polaris
‎10-24-2022
07:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
‎10-24-2022
07:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎10-24-2022
09:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
how would I use this solution in a multi line dataset so that line after line would clean after the "=" character?
‎10-24-2022
09:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thank you very much, that worked
