Queries :: Query To Copy Hyperlink

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?

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