Transactions that end in zero (or are exact dollar amounts, no cents)

[seanhickson]

Hey community

I'm trying to isolate all transactions in a dataset that are an exact dollar amount ($23.00, $23) that are exact dollar amounts without any cents (do not include $23.11). Thanks for helping!

[gawa · Accepted solution]

hi @seanhickson 

If you are familiar with Regex, try Regex_Match in Filter tool

 

[seanhickson]

Unbelievable response time! I'll have to study up on the Regex syntax but a quick copy/paste worked for me. I very much appreciate your help.