It would be really great to be able to match a pattern of text with regular expression in contains() and snip()
For example, If I have a URLhttp://www.google.com/account/gmail/532905jfkdsaandhttp://www.google.com/account/maps/5723utiregmailfjdk
If you use IF(contains("gmail",{url}),"Gmail","other")
It will return gmail for both because both contain gmail even though I am only looking for /account/gmail.
If I wanted to just find the account number (in this example) I could use something like /(\d+\w+)/g
Mark shared this idea · Jan 27, 2015
Comments
1 comment
Hi Mark,
In TrackVia, you can use both the if() and contains() function. We tested the scenario provided to find you can return "Gmail" in a calculated text field that contains that formula.
Please give this a try and submit a support ticket from your account if it does not work as expected.
Thanks,
DJ
Please sign in to leave a comment.