How to identify records that don't match the other records

[camarieschmidt]

I want to be able to identify records that don't look like what I would expect. For example in the reference column the first 5 records are all just a string of 4 characters, but the last record has a character at the end which is not expected.

[grazitti_sapna]

Hi @camarieschmidt , You can use regex to match the field as per your requirement. Please find below the solution for the use case you have submitted. In case your input is different from what you have submitted please do let me know.

[ARussell34]

Additionally, if it is rather length that is the issue, then can use a formula where If length(reference) = 4 then 1 else 0 endif. This will identify any output that doesn't meet that length of 4 criteria. 

[Emmanuel_G]

@camarieschmidt 

Find in attachement to do that.

You can also do that with string functions such as substring or Right to take the last character and check whether or not it is a letter.