Export - Group Buttons

Scriptcase 9 General
#1

Hi everybody :)…
Again asking for your kindly help…

My doubt is about the option to export an excel file…
I have in my grid a field with a link to their respective page in another system. External system… Each record has its own link…
But I’m not showing the complete URL but a word to click on it.

Like this:
$var_link = ‘www.google.com’;
{MyField} = ‘<a style=“color:#C00; font-weight:bold; text-decoration:none” href="’ . $var_link . ‘" target="_blank">’ . ‘++’ . ‘</a>’;

When exporting the file, this field shows the entire code:
<a style=“color:#C00; font-weight:bold; text-decoration:none” href=“www.google.com” target="_blank">’ . ‘++’ . '</a>
Instead of only showing:
www.google.com

Is there a way to modify the export to make it show the variable instead of the complete code?

Hope I made myself clear and someone can help me!!

Regards,
Janneth

#2

Try to type it in in Excel and export to txt to see what text needs to be in the file to have it recognized as a hyperlink. The re-import to check. If it works you can adapt your code to the right syntax as appearantly your code is not recognized being html. (You could try to put http:// in front of it, but I don’t think it will do the job)

#3

Hi Albert…

As usual thank you for your answer…
I’m not sure I understand what you are saying… appreciate if can explain it to me again…

Regards!!