filter out only numbers then add prefix
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
how do I do a formula IF statement where I want it to filter out only numbers in a field , if its true add a prefix to it?
Thanks.
Solved! Go to Solution.
- Labels:
- Expression
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If
Regex_countmatches([field],"\d")) >0 then "prefix" + [field]
else
[field]
endif
this quick formula should help you.
cheers,
mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You'll want to use the isnumber() function to check in the custom filter. You don't need an IF statement. Just remember what ever you write needs to resolve to either True or False. So something like this:
IsNumber([Field Name])
Hope this helps. If it does please make sure to mark as solved so others can find it on the community!
Thanks
Joshua
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Actually @MarqueeCrew made me realize I missed a step. If you want to Filter then you can use my path but if you just want to add a prefix to specifc records then you actually don't need to really filter the records, just use what Mark gave you and update the values.....
Just trying to be clear 😉
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks both for the quick reply...works great.
![](/skins/images/6056C79A596CAB15526D64C598622101/responsive_peak/images/icon_anonymous_message.png)