Scenario:
The above sample using Find() doesn't work. Neither does Search().
Any other ideas?
THank you!
Solved! Go to Solution.
So say if the only two formats allowed are whole number or with one decimal place, you could use something like:
If(Value(Match(Label28.Text, (Digit & "\." & Digit)).FullMatch)>3 || Value(Match(Label28.Text, "\d+").FullMatch)>3, Red, Gray)
Here is a demo:
You can easily factor in other formats if needed, like 2 decimal places or even 3 by adding more OR conditions.
Let me know if this helps.
---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!
Hardit Bhatia
https://www.thepoweraddict.com
Hello @PowerAddict , I appreciate your quick response. The answer is no, the content is not structured in a way to utilize string manipulation.
A quick demo:
---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!
Hardit Bhatia
https://www.thepoweraddict.com
Hi @PowerAddict . Thank you.
I see the solution working in your demo, however porting it to my application doesn't seem to work.
lblGalDuration is the label in the gallery. As you can see, it holds a value of "0.25" in the label. I've lowered the value in the function to "0.1" but it does not trigger...
1. Yes, lblGalDuration is where my text is stored. It is a multi-line label.
a. I just changed the value to a whole number, 3. It flagged the "10.9" value, but not the "3.7" value.
b.
2. Placing Match(lblGalDuration.Text, "\d+").FullMatch in a label shows nothing, just blank.
3. Numbers may be whole or decimal.
User | Count |
---|---|
183 | |
110 | |
88 | |
44 | |
42 |
User | Count |
---|---|
226 | |
108 | |
103 | |
68 | |
68 |