Multirow formula te check if the string has alpha characters

Question

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 Answer

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 Answer

Dear @soncoku,

below the solution with mutirow formula:

Hope that helps !

Regards,