Select from Middle of Data

[mohanmoni]

Hi,

I am looking query that extract word from middle of the data I have like: -

Webaddress
-------------------------------------
www.dell.com
www.microsoft.com
http://www.HP.com

I need to extract only dell, Microsoft, HP from middle of the webaddress.



Thanks.

[June7]

Consistency of structure is critical in string manipulation. Assuming all values follow the given examples:

Let x represent the data.

Mid(x, InStr(x,"w.")+2, Len(Mid(x, InStr(x,"w.")+2))-4)

[mohanmoni]

Thanks a Lot June7 but one more thing if webaddress end with .co.in or .co or .in or .sg. or .com.fr how do i extract "dell", "Microsoft", "HP" from it.