Replace "\" in SQL Table Transformer

Dhiraj Kr_ Gupta

Replace ( T1.'Link', "\", "%5C") is showing error in the SQL table transformer. is there way to do this.

\\name is giving output 

\

ame

 

Stiltsoft support

Hi @Dhiraj Kr_ Gupta ,

You may check this Community thread regarding similar question: https://community.atlassian.com/t5/Confluence-questions/Where-statement-with-apostrophe-within-value/qaq-p/2043412

For your case I believe that \ is CHAR(92), so the query will look smth like this: REPLACE(T1.'Link', CHAR(92), "%5C")