Extract Data

[warrenk]

I am trying to extract a number from a url. Basically I am trying to extract the data between '-p-' and '.html'. Is this possible? If so, can I do this in a Microsoft Access SQL?

IE.
Field1 =

http://www.website.com/red-widget-p-2831.html

Field2 would be 2831.

Thanks for any help!
Warren

 

[PHV]

What about this ?
Val(Mid(Field1,InStr(Field1,"-p-")+3))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[randy700]

field2 = Mid(field1, Len(field1) - 8, 4)

Randy

 

[warrenk]

PHV,

This is exactly what I was looking for. Works great!

Appreciate your help!
Warren