Start a new topic

RegEx Help - Skip Row if cell = TRUE

Hello everyone,

I'm looking for a regular expression that will allow me to skip the row if the cell contents equal "TRUE" and to process it if it equals "FALSE"

 

Thank you for any assistance you can provide!

 

Alyson 

1 Comment

Hi Alyson,

 

You actually don't need a regular expression dictionary for this, a normal dictionary will do the trick.  This dictionary replaces "True" with the value "skip row" and there is a check box next to "Create Exceptions (Skip Row)".  If the value is false it is set to replace with blank, and there are no check boxes checked.

image

image


 

For more information on the skip row feature you can refer to our online user guide

 

Thank you so much! I really appreciate the help!
Login or Signup to post a comment