I would like a dictionary that replaces one specific string with another, but any other string should be replaced by -BLANK-. I think this is easy but I can't figure it out!
RD101 -> recurring
I wasn't 100% sure of what the outcome would be in that scenario, so I tested it and it doesn't work. The dictionary will not blank out the already populated date value. I see that you are currently in communication with our support team regarding the pricing and implementation of the customization, so please let them know if you'd like to move forward with that.
Assume that I want to replace everything but "one" and "two words" with a blank
|Replacement Value||Value to Match|
...CONTINUE LIST... |
make sure to click "use regular expressions"
The first part VALID$1 and ^(one)$ will add "VALID" to the beginning of a value that matches "one".
So after step 1 the value is now VALIDone. This is repeated for all of the values that you enter in here making sure to enclose the whole value in parentheses.
The second part $2 and ^(VALID|.*)(.) will put either VALID or .* (the whole string) into $1 and then what is left over in $2. The key here is that if the string does not start with "VALID" then all of the string goes into $1. Only if the string starts with "VALID" will there be anything left over in $2.
After step 2 the value is now back to one since it had been appended a VALID in step 1. If you try to type "two" then that will not get a VALID from step 1 and so will be blank after step 2
Give it a shot!
Can I do something like that, but using a field from the fields mapping as the value to be replaced?
If gift aid = yes ==> add the date from imported spreadsheet on column C
If gift aid = no ==> skip and leave it blank
I can't see how to do that using a dictionary and if I don't use one, it adds the date to all the records!
Amanda asked me to help with that regex so it's probably best if I explain it.
Value to match on: (?(.*a.*)b|c)