SOLVED
Remove text after comma
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
sericson
8 - Asteroid
‎06-17-2024
11:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have data that depending on the input can produce duplicates in one box, I need to be able to remove everything from the first comma and over while keeping the data in other rows that are not duplicates. I have tried several formulas, RegEx etc.. I can't seem to get it quite right.
example of how it is formatted now
Install type
Reallocate
Mapping
Reallocate,Reallocate,Reallocate
Example of how I need it to look
Install type
Reallocate
Mapping
Reallocate
Solved! Go to Solution.
Labels:
- Labels:
- Community
2 REPLIES 2
griffinwelsh
12 - Quasar
‎06-17-2024
01:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
21 - Polaris
‎06-17-2024
04:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@sericson
We can also try the RegEx
![](/skins/images/03E14B015E5210679CFB65D9FFC7B381/responsive_peak/images/icon_anonymous_message.png)