SOLVED
REGX Match and Addition Formula
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
harinder1301
8 - Asteroid
‎11-10-2021
03:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Heelo everyone,
I would like to get assistance in writing a reg ex formula . When the match occurs , i want to pick the value from field S and add it.
I have created a formula to count the comma separated values . But
REGEX_CountMatches([A], ",") + 1
But I want to add the values if the count is greater than 2.
Desired output is in Column B. Please see attached file.
Many Thanks
Harinder
Solved! Go to Solution.
Labels:
- Labels:
- Data Investigation
- Regex
1 REPLY 1
Christina_H
14 - Magnetar
‎11-10-2021
03:32 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
