RegEx

[phackely]

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.

[DanielG · Accepted solution]

@phackely --- would this do it?  (\d+000\.00$|\d+000$)

REGEX_Match([Field], "(\d+000\.00$|\d+000$)")

[phackely]

@DanielG, yes that works thanks for the insight.