Customer Data Cleaning

Trim leading / trailing whitespace Standardize to proper title case Remove special control characters Remove honorifics (Encik, Puan, Cik)

Remove RM currency symbols Standardize 2 decimal places Fill empty values with 0.00

Auto detect mixed date formats Standardize to DD/MM/YYYY MY format Flag dates older than 10 years

Convert all to lowercase Fix common typos (@gamil.com etc) Remove disposable temporary emails Validate email syntax format

Remove hyphens, spaces and brackets Standardize +60 international prefix Remove leading zero after prefix Exclude landline numbers

Detect exact duplicate rows Fuzzy match similar names Keep most recently updated entry