Table Transformer - underscore replaced in Hyperlink

[Shikha Saka]

Hello, 

I am using Table transformer to generate a hyperlink and have tried both methods below. For whatever reason, the generated link replaces 2 underscores in the original URL with asterisks (*). Does anyone know why and how to get it working?  

FORMATWIKI("[Click here|" + T1.'Task Link' + "]") AS 'Check the required info',

FORMATWIKI( "[Bla-bla link|" + T1.'Task Link'->tfView->match("href=([^ >]*)")->1->slice(1, -1) + "]" ) AS 'New Link',

Generated link has below replacements but some other underscores are not replaced.  

https://YYYY.com/req*ticket....task*query...
https://YYYY.com/req_ticket....task_query..

Thanks for help. 

[Katerina Rudkovskaya [Stiltsoft]]

Hi @Shikha Saka,

Please try to use commas instead of pluses for your SQL query - it may help to preserve initial cells' formatting.For me the original query somehow works fine regarding your example link, the underscores remained as they were.