Will every instance of that field contain that text? Your example does not
'D317AB' is not contained in 'DEF317AB'
Jeff Darling
Can you add some more examples?
Is the data something like this?
DEF317AB DGH317AC DIJ317AD
Assuming that the code always contains "D something 317A something"
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
jerryb30
Just to be clear:
Must have a 'D' in string occurring before '317A'? And only strings before the 'D' and after the '317A'?
So in sample you cited, you want 'B ETC.ETC.'
Jeffrey Coachman
Svgmassive
This is why I always ask for a sample db and:
"a clear graphical representation of the *Exact* results you are expecting, based on the sample data."
;-)
Jeff
Flyster
Oops! My solution is for Excel, not Access. Must read those titles closer :)
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
=LOOKUP(99^99,--("0"&MID(A
Flyster