Start a new topic

Need to create a regular expression for skip row in the dictionary

We need to create skip rows for a Luminate Team Raiser Import.  The first 11 characters are the same, but then there is a string of different characters and I'm looking for a how to create a regular expression for this.

devnull+fbba7am3pruciufsda_3tzha-erkidsse4jclb412w5wdnu@convio.com
devnull+fbbakqreindr0uk6irb4em0rdrvbrk4kuo5wgbwgljiff6g@convio.com
devnull+fbbavwkuuqaihwlg8yl0woqp0hkycyqgevf9rv9y20iw8lw@convio.com
devnull+fbbabvhriizmdkowcrecfk7zprjewssg1jhu57rlba-1mua@convio.com

Thank You,

Debbie

1 Comment

Hi Debbie,


These instructions are assuming you want to skip anything that begins with "devnull". If you need the full first 11 characters, replace "devnull" with "devnull+fbb".


For the replacement value, you will enter:

Skipped because devnull


Then make sure to select the Regex checkbox and the Skip Row Checkbox


In the Value to match on you will enter:

^devnull.+$


Best,

Kristen



Login or Signup to post a comment