Frequently, our user base is looking to identify junk data and ways to fix it or get rid of it. PowerGrid offers various filters to find junk data, formulas to fix it and a delete record option to remove it.
| Available Filters to Find Junk Data | Formulas |
| Sounds Like Word Sounds Like No Word Characters All Vowels No Vowels No Lowercase Characters No Uppercase Characters 5+ Vowels in a row 5+ Consonants in a row Invalid US Zip Code Invalid Email Address Junk Keyboard Entry Repeating Characters |
Normalize US Address ProperCase Name ProperCase Name IC Upper Case Lower Case Country Match 2 Char Country Match 3 Char Country Match Long NA Phone Fix Zip Code Clean State Match Short State Match Long Click here to learn more about these formulas |
| ** The delete record option is found by right-clicking on the row of the record to delete. Multiple records can be selected for deletion by using the ctrl key and a mouse click or dragging the mouse click. | |
Filter Definitions:
- Sounds Like:A fuzzy (phonetic) comparison of the Value specified in the filter against the values in the specified field in the grid
- Word Sounds Like: Similar to Sounds Like except, it looks at each word in the field individually vs. the entire string as a whole
- No Word Characters: Finds field data that does not contain letters or numbers
- WILL find: $^%#&
- WILL NOT find: $%($*abc - or - &^88(
- All Vowels: Finds field data that contains ONLY vowels
- No Vowels: Finds field data that DOES NOT contain any vowels
- No LowerCase Characters: Finds field data that DOES NOT contain any lowercase characters
- No UpperCase Characters: Finds field data that DOES NOT contain any uppercase letters
- 5+ Vowels in a row: Finds field data that has 5 or more vowels in a row
- 5+ Consonants in a row: Finds field data that has 5 or more consonants in a row
- Invalid US Zip Code: Finds zip codes that are not in a valid US zip code format (i.e. contains letters, contains less than 5 digits)
- Blank values are NOT flagged as invalid
- Invalid Email Address: Finds improperly formatted email addresses
- Blank values are NOT flagged as invalid
- Junk Keyboard Entry: Attempts to find bad keyboard input data, i.e. looking for the same keys typed in a repetitive fashion
- WILL find: Asdf, Asdasdasd, Qweqweqwe, Jkl;, Zxzxzx
- Repeating Characters: Finds field data that contains the same character 3 or more times in the same word
- WILL find: aaa, zzzzzzzzzzz
- WILL NOT find: aa a – or - Angoss Software
