filter out only numbers then add prefix

[BosKev]

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.

[MarqueeCrew · Accepted solution]

If

Regex_countmatches([field],"\d")) >0 then "prefix" + [field]
else

[field]
endif

 this quick formula should help you. 

cheers,

 mark

[joshuaburkhow]

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

[joshuaburkhow]

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 😉  

[BosKev]

Thanks both for the quick reply...works great.