IF Replace specific place of a string

Stuey

Hi

I'm trying to sort out some manually entered UK postcodes. 

The sample I have should be in the format a/a/n/n n/a/a OR a/a/n n/a/a      a=alpha n=numeric

For example: XZ18 7BB and S10 0AB

In the data set some of the postcodes have been incorrectly entered and have Os instead of 0s - and vice versa. I was wondering if there is a way to pick a particular part of the string and say that if it is "X" replace with "Y". 

In my case, replace "o" with "0".

E.g. NB25 OAT ---> NB25 0AT

Is this possible?

Thanks

Stuart

benakesh

Hi @Stuey ,

Try  regex parse  ( to  split string ) and regex replace .

regex1.yxmd