I need to know how to make a qualification based on a field if it contains a
certain word. My field always contains an email address, and I want the
filter to run only if the address contains a certain word. I tried using
"%word%" and "$word$", but it didn't work. I had to put the whole address
is (ie: "word@whatever.com", which is a pain because it can vary.

Any suggestions?

(A quick response would be appreciated as I'd like to wrap this up within
the hour - I realize it's a Saturday, though.)

Thanks,

Anne


Unsubscribe to: Text is: unsubscribe arslist

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Anne Hengen-Brown
Sent: Saturday, March 18, 2000 11:16 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: "Run if" statement for filters/active links


Hi everyone,

I need to know how to make a qualification based on a field if it contains a
certain word. My field always contains an email address, and I want the
filter to run only if the address contains a certain word. I tried using
"%word%" and "$word$", but it didn't work. I had to put the whole address
is (ie: "word@whatever.com", which is a pain because it can vary.

Any suggestions?

(A quick response would be appreciated as I'd like to wrap this up within
the hour - I realize it's a Saturday, though.)

Thanks,

Anne


Unsubscribe to: Text is: unsubscribe arslist


Unsubscribe to: Text is: unsubscribe arslist

From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Anne Hengen-Brown
Sent: Saturday, March 18, 2000 11:16 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: "Run if" statement for filters/active links


Hi everyone,

I need to know how to make a qualification based on a field if it contains a
certain word. My field always contains an email address, and I want the
filter to run only if the address contains a certain word. I tried using
"%word%" and "$word$", but it didn't work. I had to put the whole address
is (ie: "word@whatever.com", which is a pain because it can vary.

Any suggestions?

(A quick response would be appreciated as I'd like to wrap this up within
the hour - I realize it's a Saturday, though.)

Thanks,

Anne


Unsubscribe to: Text is: unsubscribe arslist


Unsubscribe to: Text is: unsubscribe arslist

Try $Field$ Like (("%" + "word") + "%" )

That should do it.

John Gould


At 03:29 PM 3/18/00 -0500, you wrote:
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Anne Hengen-Brown
>Sent: Saturday, March 18, 2000 11:16 AM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: "Run if" statement for filters/active links
>
>
>Hi everyone,
>
>I need to know how to make a qualification based on a field if it contains a
>certain word. My field always contains an email address, and I want the
>filter to run only if the address contains a certain word. I tried using
>"%word%" and "$word$", but it didn't work. I had to put the whole address
>is (ie: "word@whatever.com", which is a pain because it can vary.
>
>Any suggestions?
>
>(A quick response would be appreciated as I'd like to wrap this up within
>the hour - I realize it's a Saturday, though.)
>
>Thanks,
>
>Anne
>
>
>Unsubscribe to: Text is: unsubscribe arslist
>
>
>Unsubscribe to: Text is: unsubscribe arslist
>


Unsubscribe to: Text is: unsubscribe arslist

I need to know how to make a qualification based on a field if it contains a
certain word. My field always contains an email address, and I want the
filter to run only if the address contains a certain word. I tried using
"%word%" and "$word$", but it didn't work. I had to put the whole address
is (ie: "word@whatever.com", which is a pain because it can vary.

Any suggestions?

(A quick response would be appreciated as I'd like to wrap this up within
the hour - I realize it's a Saturday, though.)

Thanks,

Anne


Unsubscribe to: Text is: unsubscribe arslist


Unsubscribe to: Text is: unsubscribe arslist

Try $Field$ Like (("%" + "word") + "%" )

That should do it.

John Gould


At 03:29 PM 3/18/00 -0500, you wrote:
>-----Original Message-----
>From: Action Request System discussion list(ARSList)
>[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Anne Hengen-Brown
>Sent: Saturday, March 18, 2000 11:16 AM
>To: ARSLIST@LISTSERV.VISTAIT.COM
>Subject: "Run if" statement for filters/active links
>
>
>Hi everyone,
>
>I need to know how to make a qualification based on a field if it contains a
>certain word. My field always contains an email address, and I want the
>filter to run only if the address contains a certain word. I tried using
>"%word%" and "$word$", but it didn't work. I had to put the whole address
>is (ie: "word@whatever.com", which is a pain because it can vary.
>
>Any suggestions?
>
>(A quick response would be appreciated as I'd like to wrap this up within
>the hour - I realize it's a Saturday, though.)
>
>Thanks,
>
>Anne
>
>
>Unsubscribe to: Text is: unsubscribe arslist
>
>
>Unsubscribe to: Text is: unsubscribe arslist
>


Unsubscribe to: Text is: unsubscribe arslist


Unsubscribe to: Text is: unsubscribe arslist

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:ARSLIST@LISTSERV.VISTAIT.COM]On Behalf Of Anne Hengen-Brown
Sent: Saturday, March 18, 2000 11:16 AM
To: ARSLIST@LISTSERV.VISTAIT.COM
Subject: "Run if" statement for filters/active links


Hi everyone,

I need to know how to make a qualification based on a field if it contains a
certain word. My field always contains an email address, and I want the
filter to run only if the address contains a certain word. I tried using
"%word%" and "$word$", but it didn't work. I had to put the whole address
is (ie: "word@whatever.com", which is a pain because it can vary.

Any suggestions?

(A quick response would be appreciated as I'd like to wrap this up within
the hour - I realize it's a Saturday, though.)

Thanks,

Anne


Unsubscribe to: Text is: unsubscribe arslist


Unsubscribe to: Text is: unsubscribe arslist


Unsubscribe to: Text is: unsubscribe arslist