allowing numbers but not special characters and space

[dmistry]

Hi,

i am using an expression below for a sp list connected text box control.

Below is the expression syntax:

"KL-" & DataCardValue35.Selected.Value & DataCardValue36.Selected.Value &"-" & Concat(MatchAll(DataCardValue10.Text, "\p{L}+"),FullMatch)

the matchall works perfect and does not allow special characters as well as white space but I need to include numbers/digits from 0-9. Can someone help how I should modify to allow numbers? Many thanks in advance. 

[GarethPrisk · Accepted solution]

Tweaking one of the samples:

Concat(
    MatchAll(
        DataCardValue10.Text,
        "(?!^[0-9]\*$)(?!^[a-zA-Z]\*$)([a-zA-Z0-9])"
    ),
    FullMatch
)

This was the 'strong password' example, without the 8-10 character requirement. This will require an alphabet character, and a digit, but could be tweaked as needed.

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-ismatch#regular-expr...

[v-xiaochen-msft]

Hi @dmistry  ,

Has the problem been solved?
Is there anything else I can help?

Best Regards,

Wearsky