SOLVED
Extract Specific Data from a Cell after Certain Criteria
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
JTB76
8 - Asteroid
‎06-10-2021
02:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All - Need to extract data elements from a cell after certain criteria:
Compass - 1234 - RTO24
Compass - 1234 - RTO 24
In the example above, I want to only have RTO24 or RTO 24 extracted.
What is the best way to achieve this?
Thanks in advance.
James
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
- Datasets
- Output
2 REPLIES 2
‎06-10-2021
02:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Meant to say that I still need the original data in the cell its currently in, but need the RTO24 etc., in another separate cell as well.
17 - Castor
‎06-10-2021
08:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @JTB76
Here's two approaches, one with string functions and one with regex.
Side note, you might get quicker answers posting in the designer forum rather than server. This is more of a designer question.
