Hi, I’m new to UiPath so I’m hoping someone can help me with this problem.
I want to check whether the cells in a certain column contain a valid percentage, so the format has to be 0 - 100%, where just the numbers without the “%” symbol is invalid.
So far I have read the column, but when I’m checking the cell value I’m using “row(x).toString” and that is where the problem is. When I’m dealing with a valid percentage, the value changes so 100% becomes 1, 50% becomes 0.5 etc.
I was planning on using Is Match for my check but that can’t be used now that the value changes when I use “.toString”.
Please let me know if you know how to solve this. Thanks in advance!