Creating a more specific search if replace function.

Occasional Contributor

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.

1 Reply

@stedmana Perhaps something like in the picture below would work for you.

Screenshot 2021-12-10 at 07.33.46.png