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.
User | Count |
---|---|
263 | |
110 | |
92 | |
55 | |
41 |