Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Purgechar(URL, '#') will remove all occurrences of # in the URL data.
This is best done in the load script.
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".
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?
Do you wan the URL to have # before and After, Is that a requirement or that how your data is ?
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.
replace(MaxString(URL),'#','') & '<URL>' & replace(MaxString(URL),'#','')
you have to use this in the expression , Not load statement
replace(MaxString(URL),'#','') & '<URL>' & replace(MaxString(URL),'#','') as URL
gives me an invalid expression error
I don't think you need the MaxString statement. Try:
Replace(URL,'#','') & '<URL>' & Replace(URL,'#','')
Purgechar(URL, '#') will remove all occurrences of # in the URL data.
This is best done in the load script.