Jump to content
  • 0

Wildcard in Triggered Actions?!


Felix
 Share

Question

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

  • 0

Do you mean the 'Find Pattern' block on the triggered actions?

I was able to use it properly using this as a reference: https://www.w3schools.com/sql/func_sqlserver_patindex.asp

My idea was to first, find the location of the first number using this: 

PATINDEX('%[0123456789]%','test1234colmsd')

 

It should return 5 so I know that the first number is located on the 5th position.

Now this time, reverse the text and use the same formula

PATINDEX('%[0123456789]%',reverse('test1234colmsd'))

Now this will return 7

If we combine them all on this setup:

substring('test1234colmsd',PATINDEX('%[0123456789]%','test1234colmsd'),(LEN('test1234colmsd')-PATINDEX('%[0123456789]%',reverse('test1234colmsd'))+2)-PATINDEX('%[0123456789]%','test1234colmsd'))        

You can rebuild this on a trigger or use it on a formula field. If you are going to use a formula field approach, replace the 'test1234colmsd' with the field reference of the one carrying the values.

substring([@field:valueholder],PATINDEX('%[0123456789]%',[@field:valueholder]),(LEN([@field:valueholder])-PATINDEX('%[0123456789]%',reverse([@field:valueholder]))+2)-PATINDEX('%[0123456789]%',[@field:valueholder]))      





 

Link to comment
Share on other sites

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.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...