Hi, anyone know how to check for certain decimal places? I think I could use the Regex Matching step but not sure how to incorporate that step into my plan using simple scoring.
Can you please describe it in a use case project or give us an example?
If you’re looking to match any number with a decimal in it, this regex will return what you want to the $0 element:
…but if you only want to match numbers with 2 decimal places in it, check of “Partial Match” and use…
All this assumes your input value is only numbers. If there are non-numeric characters in there, it will interrupt the matching
The Regex Matching step can write $0 to an output column, which you can use in a subsequent Simple Scoring step.
You can also use the matches() function in Simple Scoring to see if an input entirely matches some regex function.