Multirow formula te check if the string has alpha characters

[soncoku]

if

>>>>>>>>Here I want to check if the [Field1] has alpha characters (a,b,c,d....)<<<<<<
then [Field1]
else
[Row-1:Group Title] endif

Any ideas?

[atcodedog05 · Accepted solution]

Hi @soncoku 

Here is a workflow for the task.

IF REGEX_CountMatches([Field1],"[[:alpha:]]" )>0 
THEN "Has Alpha" ELSE "No Alpha" ENDIF

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[messi007 · Accepted solution]

Dear @soncoku,

below the solution with mutirow formula:

Hope that helps !

Regards,

[atcodedog05]

Happy to help 🙂 @soncoku 

Cheers and Happy Analyzing 😀