I want add a 0 in the beginning for all the mobile numbers in a phone number column of a data table if the mobile number only has 9 digits and starts with 4. I’m basically cleaning up the phone number column.
For instance if the mobile number is 0412345678, then no action required.
If the mobile number is 4312345678, then the result should be 0434182062
As I am having around 70,000 rows, I don’t want to use a for each. Please help if anyone has a solution for this.