Start a new topic

RegEx to prefix incoming data if not blank

I'm a bit rusty on my Regular Expressions so I'm not sure how to best accomplish this, but I need to prefix my incoming text if it is not blank. I know how to replace anything that's not blank and I know how to prefix, just not sure how to combine the two into one dictionary.


Thanks in advance!!


Alison




I'm sure there is a way to do this in one line, but I honestly can't think of it at the moment, so I did it in two.


First line value to match on ^ replacement Value Omatic-

Second line value to match on ^Omatic-$ replacement value --BLANK--


Turn RegEx on for both lines

(replace Omatic- with whatever your actual prefix is)


Thanks,


John

That did the trick. Thanks John!!

Login to post a comment