SOLVED
Extract numbers/Special characters from a string value
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
Cfdiaz2103
8 - Asteroid
‎05-10-2021
10:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi everyone!
Is there any way to take numbers or special characters from a record?
For example:
Input Data:
Column A |
Tax Discount 9/100 |
Carlos 14.5/100 Miami |
Output Data:
Column A | Output Column A |
Tax Discount 9/100 | 9/100 |
Carlos 14.5/100 Miami | 14.5/100 |
Thanks for your response.
Solved! Go to Solution.
Labels:
- Labels:
- Developer
6 REPLIES 6
apathetichell
19 - Altair
‎05-10-2021
10:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
try this one.
If it's always number/number there are easier ways so I wasn't sure of the complexity of what you are looking for. Takes any special character/number or period in a row and tokenizes them. If the resulting field is empty (ie a string of spaces) it will filter them out. it filters out standalone punctuation by then searching for only strings that contain at least number.
17 - Castor
‎05-10-2021
10:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎05-10-2021
10:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
17 - Castor
‎05-10-2021
10:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎05-10-2021
10:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
apathetichell
19 - Altair
‎05-10-2021
10:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Good to hear - but @mceleavey 's solution was definitely more awesome. Regex tokenize based upon non-matching was definitely the way to go.
