Remove "#" from text fields

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Hi,
I am trying to integrate data from an Access DB into our
new accounting software. I have a hyperlink field in the
source .mdb file, however when I export the field as a
Field Type=Hyperlink, it exports a leading and
trailing "#". If I change the Field Type to text, it
displays as text again with the leading and trailing "#".
I thought there used to be a "Replace" function, but that
is not a valid function. If I use the "Find and Replace"
and specify to find #, it finds every number, but not the
#. If I specify "#" or '#' it finds nothing, even though
the record shows the #.

Any suggestions out there?

Thanks!
Jim
 
Allen,

Tried that and I get a "Type Conversion Failure" whether
the field is a text or hyperlink field type. If I use just
#, I get an "Invalid Date" error, if I use "#", I get
the "Type Conversion Error".....

Any other thoughts?

Thank you for reply, by the way....

Jim
 
Hum, just use in your query builder:

Ndata:(hyperlinkpart([yourfield name])

So, just build a query, and then export that query in place of the table.
 
Back
Top