Skip to main content

Types of Data You Can Clean

These are the data types currently supported. We’re working on expanding what you can clean next!

Updated over 2 months ago

Phone Numbers

  1. US Standard: (123) 456-7890

  2. Slash separators: 123-456-7890

  3. Dot separators: 123.456.7890

  4. No separators: 1234567890

Dates

  1. MM/DD/YYYY

  2. MM/DD/YY

  3. M/D/YY

  4. DD/MM/YYYY

  5. DD/MM/YY

  6. D/M/YY

  7. YYYY/DD/MM

  8. YY/DD/MM

  9. YYYY/D/M

  10. MM.DD.YYYY

  11. DD.MM.YY

  12. YYYY.MM.DD

  13. YY.M.D

  14. YYYY-MM-DD

  15. DD-MM-YY

  16. M-D-YYYY

  17. YY-MM-D

  18. MM DD YYYY

  19. DD MM YY

  20. YYYY MM D

  21. YY M D

  22. MMDDYYYY

  23. DDMMYY

  24. YYYYMMDD

  25. YYMD

  26. Mon Day, Year

  27. Day Mon, Year

  28. Mon Day, Year

Addresses

  1. Title Case: 123 Main St, Anytown, CA 12345

  2. Lowercase: 123 main st, anytown, ca 12345

  3. Uppercase: 123 MAIN ST, ANYTOWN, CA 12345

Cities

  1. Title Case: New York

  2. Lowercase: new york

  3. Uppercase: NEW YORK

  4. Abbreviation: NY

  5. Abbreviation w/ Periods: N.Y

Names

  1. First Name Last Name in Title Case: John Smith

  2. Last Name, First Name in Title Case: Smith, John

  3. First Initial. Last Name: J. Smith

  4. Uppercase: JOHN SMITH

  5. Lowercase: john smith

Currency

  1. Symbol first: $ 9,999.99

  2. Before amount: USD 9,999.99

  3. After amount: 9,999.99 USD

  4. Before amount: US Dollars 9,999.99

  5. After amount: 9,999.99 US Dollars

Did this answer your question?