I've been looking through the forums for a solution but I can't find anything that really matches this scenario that I understand enough to be able to modify.
I need to create a dictionary which will replace data with BLANK for fields where the data begins with 08/+618/02/+612/07/+612/03/+613 and keep the value if the data begins with 04/+614
Then I need to have a dictionary that does the exact opposite - replaces with BLANK for 04/+614 and keeps the data for the rest.
Would anyone be able to help?
Hello Debbie, sorry to take so long to get back to you.
I misunderstood the question from the beginning!
Now I see that you want to replace anything that starts with 04 or starts with +614. I had understood that it would start with "04/+614"
Anyways, the solution is this:
Same idea with the others. The issue was that + is a protected symbol in regular expressions so you have to "escape" it with a leading \ in order for the regular expression engine to interpret it as a literal character instead of the function +.