How to identify records that don't match the other records
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.