Hi All,
Background:
Using the following within RegEx tool's Regular Expression field:
000$|000.00$
Input data using Text Input tool and using the Select tool to transform AMOUNT's data type from Double to String:
| TYPE | AMOUNT |
| PURCHASE | 525 |
| SALE | 25000 |
| PURCHASE | 950.00 |
| PURCHASE | 3000.00 |
| SALE | 40000 |
Inquiry:
What needs to change within the RegEx field, or otherwise, to output matches for the AMOUNT field containing values that end in "000.00" or "000"?
I solved for this using the EndsWith() function within the Filter tool although I wanted to find out if I'm using the RegEx tool correctly.
