Start a new topic

Value to Match if BLANK

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:


image


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!

Login or Signup to post a comment