Export CSV hyperlink field

  • Thread starter Zadok @ Port of Seattle
  • Start date
Z

Zadok @ Port of Seattle

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!
 
J

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.
 
Z

Zadok @ Port of Seattle

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