Unanswered

Reg Exp to match characters ANYWHERE in string

(0) Share

Report

Posted on by StevieC

137

I want to see if a special character appears anywhere in a string so I have the reg exp: [!$%]+ this works fine here Online regex tester

But in Power Apps this only matches if the string only contains a ! or $ - ie it matches !$!!$!$! 0r ! or $$$ but not !try or test$

code: If(IsMatch(DataCardValue2.Text, "[!$]+"), Set(vError, true), Set(vError, false))

Any ideas what's going wrong?!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @StevieC

You can use the in operator to achieve your needs. You can write the expression as below:

If("%" in DataCardValue2.Text,Set(vError, true), Set(vError, false))

Here, you have to replace % with the special character you are looking for.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@StevieC

Please consider changing your Formula to the following:

Set(vError, !IsBlank(Match(DataCardValue2.Text, "[!$%]").FullMatch))

This will set your vError to true if there is a match of any one of the characters in the string and false if not.

I hope this is helpful for you.

Was this reply helpful? Yes No
StevieC 137 on at

Like (0)

Report

Perfect - thanks Randy. Much neater way of setting the Bool too!.

Was this reply helpful? Yes No
StevieC 137 on at

Like (0)

Report

Quick follow up - how would i get the following to work:

Set(varError, !IsBlank( Match(DataCardValue2.Text, "([!$%])").FullMatch Or IsMatch(DataCardValue2.Text, "^[^a-z]+$")))

The looks for the special characters OR all the text being in CAPS
cheers 🙂

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@StevieC

I believe you are saying you want to make sure the text entered is all UpperCase CAPS? Maybe I have it backward.

If so, then set your formula to:

Set(varError, !IsBlank(Match(TextInput3.Text, "[!$%]").FullMatch) || !IsBlank(Match(TextInput3.Text, "[a-z]").FullMatch) )

If it was the opposite, and all should NOT be Uppercase, then use this formula:

Set(varError, !IsBlank(Match(TextInput3.Text, "[!$%]").FullMatch) || !IsBlank(Match(TextInput3.Text, "[A-Z]").FullMatch) )

Was this reply helpful? Yes No
StevieC 137 on at

Like (0)

Report

Not quite either - more the second one though! I dont want ALL caps - so I dont want ABC or ABC! or A!BC OR !!! but Abc or aBc or abc is fine

The second option you gave above is true for ABC but also for ABc

cheers

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@StevieC

Okay...got it now. And that makes things a little simpler (for some reason....I consider myself a "begintermediate" with regular expressions, so I struggle through them but use them often).

Use this formula:

Set(varError, !IsMatch(DataCardValue2.Text, "^(?=.*[A-Z])(?=.*[a-z])(?!.*[!$%]).*") )

I vetted this out here and it seems to meet all the conditions you mention.

Was this reply helpful? Yes No
StevieC 137 on at

Like (0)

Report

Thats amazing - just had to add a slight tweak to allow numbers, but its all working perfectly now - thanks for all your help, ill pick though it and understand what it all means 🙂

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@StevieC

Excellent!! When you figure it out, let me know...LOL 🤣🤣 Actually, that one was fairly understandable in my head and again, I'm still a begintermediate with reg ex.

Was this reply helpful? Yes No
StevieC 137 on at

Like (0)

Report

I get most of it - dont think i would have every got there on my own though! There is one small issue - if the first character is a letter (not a number) it wants a capital! Not a major issue as most people start with a capital anyway 🙂
thanks again

Was this reply helpful? Yes No