URL from Access

[NickHoff]

I'm putting a URL in a straight table, and enabling the references a link, but the formatting of my url is preventing it from working.  Currently it's formatted with # before and # where it ends like: #http://www.blah.com#.  Is there a work around to get the link to work?

[Josh_Good]

The syntax is LinkName<URL>Link as in Google<ULR>www.google.com  you will need to strip out the # on each end.  Also don't forget to set the expression to "Link".

[NickHoff]

Would you use something like:

textbetween('<Table.TuppleName>','#', ') on the load to strip the #'s, the field in the database has thousands of different links, so when I preform the load for the straight table how do I get it to show all the links without going into each one to change the syntax?

[#4]

Do you wan the URL to have # before and After, Is that a requirement or that how your data is ?

[NickHoff]

The URL is stored that way in the data.  Preferably I would like to remove the # and have a clickable URL in a straight table in a field called URL.

[#6]

replace(MaxString(URL),'#','')  &  '<URL>'  & replace(MaxString(URL),'#','')

you have to use this in the expression , Not load statement

[NickHoff]

replace(MaxString(URL),'#','')  &  '<URL>'  & replace(MaxString(URL),'#','') as URL

gives me an invalid expression error

[Josh_Good]

I don't think you need the MaxString statement.  Try:

Replace(URL,'#','') & '<URL>' & Replace(URL,'#','')

[Colin-Albert · Accepted solution]

Purgechar(URL, '#')   will remove all occurrences of # in the URL data.

This is best done in the load script.