Pulling Text Out of String

[Newsgroup_User]

I need to pull some text out of a database string

the string returned is
0]Nx

Where "N" is an integer, single digit (i believe, but could be more).

Can somebody help me with direction on how to obtain everything between ]
and X?

--

Thank you,

Jon Parkhurst
PriivaWeb
PO Box 1114
Sedalia, MO 65302-1114
660.826.5600

[Guest]

use the string functions ... depend on what is ur database is .. but anyway u can use substring or mid ..
if u wanna know more just search the help for String Functions and read how to use them ...
Good Luck

[Newsgroup_User]

.oO(Mohnd)

>use the string functions ... depend on what is ur database is .. but anyway u
>can use substring or mid ..

Or a regular expression:

0](\d+)x

Micha

[Newsgroup_User]

Thanks guys!

"Michael Fesser" <netizen@gmx.de> wrote in message
news:i9bi4211ijm33g9dmt8imo592at9jmvmhe@4ax.com...
> .oO(Mohnd)
>
>>use the string functions ... depend on what is ur database is .. but
>>anyway u
>>can use substring or mid ..
>
> Or a regular expression:
>
> 0](\d+)x
>
> Micha