Need Help Extracting Alpha Numeric Data

#1 (**permalink**) 01-Nov-2005, 13:40 PM

Your assistance will be greatly appreciated:

In a field named "Comments" I need to extract a error code that begins with
E and a four digit number. (i.e E2301 and E1003)
I am trying to use the instr command (Error:
Mid([Comments],InStr([Comments],"E"),5)) but I can't figure how I can add
the various digits that may appear. The valid codes will appear from E0000
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6298-need-help-extracting-alpha-numeric-data.html
to E9999.
As you can see in the first line will produce a result ERROR and not E2301
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6298
as I would like.

COMMENTS
PC#18644728379 VOD ERROR E2301 CCI STATED PREVIOUS TECH WRITE
C# (864)313-6362 VOD E1003 CANT GET INTO ME

#2 (**permalink**) 01-Nov-2005, 13:40 PM

"E####"

"jturner" wrote:

> Your assistance will be greatly appreciated:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6298
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6298
>
> In a field named "Comments" I need to extract a error code that begins with
> E and a four digit number. (i.e E2301 and E1003)
> I am trying to use the instr command (Error:
> Mid([Comments],InStr([Comments],"E"),5)) but I can't figure how I can add
> the various digits that may appear. The valid codes will appear from E0000
> to E9999.
> As you can see in the first line will produce a result ERROR and not E2301
> as I would like.
>
> COMMENTS
> PC#18644728379 VOD ERROR E2301 CCI STATED PREVIOUS TECH WRITE
> C# (864)313-6362 VOD E1003 CANT GET INTO ME
>
>
>
>
>