Dec 09 2021 07:58 PM - edited Dec 09 2021 08:00 PM
I have an issue were I'm merging two databases.
Our database lists all mobile numbers as starting with 04
The merger databases majority of numbers start with 61 the area national code.
I need to use a function or formula that will change the 61 to 0 in all numbers that start with 61, however if 61 is somewhere else in the number that has to remain, I only need to change the first 2 digits to 0 IF they actually are 61.
This is why a normal replace or search find replace isn't sufficient.
This way I can run a duplicate search so I'm not adding logs already listed in a our current database.
Dec 09 2021 10:36 PM
@stedmana Perhaps something like in the picture below would work for you.