cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

how can remove/validate TextBox for Pre,Post-commas and consecutive comma/dots in TextBox

Hi Mates,

we have text-box, As per the requirement user should not enter per-commas before number in text-box means like below

1. Users can enter 90,8.5 but not ,90, here comma should remove automatically if they enter like Pre-Post Comms.

2. Consecutive comma/dots: users should not enter ,, or .. before or after or even in between also

ex: ,,12,15,, or ,,12,15.. or ..12,,15,, etc   Means users can enter Single/One Time Dot (.) or Comma between the Numbers but not before and after.

As of now i am using below formula on Text-box, On-change property, but this is allowing consecutive commas and dots.

Set(resetvar,If(IsMatch(TextInput.Text,"^[1-9]\d*([.,]\d+)?$"),false,true))

 

How can i meet the above two requirements in text-box control.

 Highly appreciated if some one can help here. 

0 REPLIES 0

Helpful resources

Announcements
secondImage

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

Top Kudoed Authors
Users online (58,307)