How do I get file names from Hyperlink string in Access

[pjmclaughlin]

I want to create a new text column based on the file name of a Hyperlink
column - i.e. I want everything within the "#" separators - anyone know how
to get these?

 

[Ken Snell \(MVP\)]

Post an example of the hyperlink string that contains the value you want to
parse out from the string.

 

[pjmclaughlin]

The string for the full Hyperlink would look like this:

Link 3#http://www.msn.com#

I would like to extract the http://www.msn.com from the string and populate
a new column within access - so extracting everything within the # signs!

 

[pjmclaughlin]

Figured it out:
The query would be:

URI:
Left$(Mid$([Hyperlink],InStr(1,[Hyperlink],"#",0)+1),Len(Mid$([Hyperlink],InStr(1,[Hyperlink],"#",0)+1))-1)

Where [Hyperlink] is the field name I wanted to parse!

 

[Ken Snell \(MVP\)]

This may be a bit simpler:

Mid(Left([Hyperlink],Len([Hyperlink]) - 1), InStr([Hyperlink], "#") + 1)

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

Figured it out:
The query would be:

URI:
Left$(Mid$([Hyperlink],InStr(1,[Hyperlink],"#",0)+1),Len(Mid$([Hyperlink],InStr(1,[Hyperlink],"#",0)+1))-1)

Where [Hyperlink] is the field name I wanted to parse!

The string for the full Hyperlink would look like this:

Link 3#http://www.msn.com#

I would like to extract the http://www.msn.com from the string and
populate
a new column within access - so extracting everything within the # signs!