Find a string within a string

S

shank

I'm strying to update a field based upon the type of email address is in
another field.
In short, if anyone has an email domain like what's in
[DomainString]![DomainString] (below), I'm update with either Text or HTML.
However, I'm not having much luck. I've tried StrComp, InStr, and now
InStrRev.
Anny thoughts?
thanks!

IIf(InStrRev([Import
List]!(e-mail address removed)
 
J

Jen

Hi There,

Should be....

IIf(InStrRev([ImportList]!,[DomainString]!
[DomainString]) > 0,"Text","HTML")

Those darned parenthesis will get you every time...

Regards,
Jen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the value in a string 2
Find and replace a set of strings in Powerpoint 1
Trimming a dynamically changing string 2
SQL strings with quotation marks or apostrophes trouble! 2
Option Group value to string 8
find text in a string 5
Find matching record based on partial string 6
Option Compare Database 3

Top