The recipe will perform the following:
- Change phone number to integer
- Remove – from phone number
- Remove invalid code from phone number
- Append 60 to phone number that has 9 digits (Malaysia phone number)
- Append 6 to phone number that has 10 digits and start with 0
- Split full name to first name and last name
- Convert First Name and Last Name to proper case
- Create a new column and put a constant value