I am trying to use a dictionary to replace a value if the field imported is blank. According to this document, it should be possible (look for #19 - https://omaticsoftware.freshdesk.com/support/solutions/articles/28000006124-what-are-some-commonly-used-regular-expressions-). However, testing it has proved fruitless. Any ideas?
That's a pretty common dictionary. Can you post a screen shot of yours so we can figure out the error?
Sure! I am not receiving an error - it's returning no value at all. Here is an image of the dictionary:
Your dictionary is looking for the word 'Employee' in the incoming data, and changing it to a blank field. My guess is that you want it the other way around
Yes, haha, that's it. Sorry, still new to ths! Thanks for your help!