How can i keep Excel formula in Alteryx

[vishal_masharuwala]

HI, i just shifted to Alteryx and leaning as well. i want to use some existing formula like =IFERROR(SEARCH("/",A2),0) in Alteryx

can you please let me know how can i use

thanks

[neilgallen]

Welcome!

The closest analog is going to be “contains” where the format would be

Contains([field],”search string”). This returns a true false value, so you could include it in an if statement to account for missing values.

[BrandonB]

Alteryx has the "findstring" function which can return the character position when the text is found

[DiganP · Accepted solution]

@vishal_masharuwala There are a couple of ways you can do this. Have you looked at the Regex_CountMaches() function? You can also use the contains() functions.

Input: Apple

- I want to count how many p's are in there

- Formula: REGEX_CountMatches([Field1], '[p]')

Output: 2

Here's a complete list of all the functions.

[vishal_masharuwala]

thanks a lot Digan,

it works