Cleaning HR Titles: Removing Abbreviations and Pronouns Easily

Giedrius · 2025-03-19 09:38:27.141985+00

hi team, im going after HR/People titles and a lot of the surnames have abreviations like FCIPD, MCIPD, or even He/Him, She/Her etc etc. Is there an easy way to clean the surname?

While we don't have a specific tool for cleaning surnames, you can use our data cleaning functions to address this issue. Here's how: 1. Navigate to the enrichment panel and find the "Tools" section. 2. Look for our pre-built functions under the AI options. 3. Consider using the "Text Whitespace" normalization tool to ensure consistent spacing. 4. You might also explore other text manipulation functions available in Clay. For more complex cleaning, you may need to use our "write to table" feature with a custom formula to remove specific abbreviations or pronouns. If you need further assistance with this specific task, please request human support by clicking on "Talk to a person".

Sources: Data Cleaning + Normalization [Automated Outbound] - Clay University Data Cleaning + Normalization [CRM Enrichment] - Clay University

2 comments