Regular Expression Dictionary Help Needed :

How can we help you today?

Start a new topic

Regular Expression Dictionary Help Needed

Rachel Ellis

started a topic about 4 years ago

We need to parse out a single value from a very long string of values like this:

Business Alumni (1041) Opt Ins,Education Alumni(1042) Opt Outs,Nursing Alumni (1043) Opt Outs,Viewpoint Online (Alumni E-Newsletter)(1044) Opt Ins,DS - 2018/03/08 12:00:39 - New - Task 1752676964

We need a separate dictionary for each of these opt-in and opt-out categories, to record each of these interests individually. The dictionary we came up with is below, but doesn't work on this string. I think it is because of the parathesis in the strings. Can anyone advise?

No Nursing Alumni E-Communications	.Nursing Alumni (1043) Opt Outs.	TRUE	FALSE
	^(?!No Alumni E-Communications).*$	TRUE	FALSE

1 Comment

John Shephard

said about 4 years ago

Hi Rachel,

Sorry for the delay in your post getting posted! Your first line should be .*Nursing Alumni $1043$ Opt Outs.* It also looks like you're missing Nursing in your value to match on in the second line. You have No Alumni E-Communications and it should be No Nursing Alumni E-Communications.

Thanks!

John