REGEX_MATCH

[carterfleming]

My Regex_Match function is not working for some reason. I've used it in other flows before and can't figure out why it's not producing the desired result.

I'm trying to say if the Txn Type column is "Void" and the Purchase Amt column is "0" (zero) then to remove the column. I've checked the Type to ensure that both are V_String. 

[IraWatt · Accepted solution]

Hey @carterfleming,

Why use regex match? why not just write:

[Purchase Amt] = "0" AND [Txn Type] = "Void"

 Would you be able to show an example of your formula not working?

Thanks,

Ira

[MarqueeCrew]

Hi @carterfleming ,

A small puzzlement:

Contains([Txn Type],"Void") AND REGEX_MATCH([Purchase Amt],"\d+")

I assume that void can be part of the field contents rather than == "Void".

The Purchase Amt field doesn't have a decimal place?

"[\d\.]+"

That modification will allow you to match numbers like:  123.45  (it will also match 1.2.3.4.5, but does it matter?).

"\d+\.{0,1}\d{0,2}"

That will match 1 digit followed by 0 or 1 decimal points followed by 0,1, or 2 digits.

Cheers,

Mark