Is there a wildcard function in triggered actions?
I want to extract a number from a string but the number is not always in the same place. e.g. in both "strength of product is x percent" and "product strength x percent" I want to find x.
I've tried using 'contains', 'find pattern' and 'find substring' but none of them respond to any of the normal wildcards. Surely there is a way to do this without having to have a formula field in the table.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Felix
Hi everyone,
Is there a wildcard function in triggered actions?
I want to extract a number from a string but the number is not always in the same place. e.g. in both "strength of product is x percent" and "product strength x percent" I want to find x.
I've tried using 'contains', 'find pattern' and 'find substring' but none of them respond to any of the normal wildcards. Surely there is a way to do this without having to have a formula field in the table.
Thanks for your help
Felix
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.