Export CSV hyperlink field

[Guest]

I am exporting my database to a CSV file and on the hyperlink field, the
export puts a # sign at the beginning and end of every record. Is there an
Update Query or Macro I can setup to remove the # character?

Thanks so much for your help!

 

[John Nurick]

Hi Zadok,

Use the HyperlinkPart function in a calculated field in the query.
Something like
fFieldName: HyperlinkPart([FieldName], 5)

If that doesn't give the exact result you want, try other constant
values instead of 5. To see the options, open the VBA editor, hit F2 for
the Object Browser, and search for acHyperlinkPart.

 

[Guest]

John,
This is the first time I've posted and I am impressed--this forum is a
lifesaver. Thank you so much!