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.