Query to Copy Hyperlink

[pmontalto]

Hello. I have a table called [Attachments Table], which has the fields:

AttachNbr as autonumber
Task ID as number
FileN as hyperlink
URLText as long text

I want to copy the URL of the hyperlinks stored in the FileN fields to the URLText fields. However, when I run an update query I am getting the full hyperlink code and not just the address.

Example: FileN will appear as a hyperlink like JR1020.pdf, which is obviously formatted as JR1020.pdf#URL#

How can I copy just the plain URL (the stuff between the hash marks) without the hyperlink text names?

This is my query now

UPDATE [Attachments Table] SET [Attachments Table].URLText = [Attachments Table].[FileN];

Thanks

 

[spikepl]

HyperlinkPart

 

[pmontalto]

HyperlinkPart

Thanks. I'm just having a bit of difficulty. What would the query look like then?