Beast mode CONCAT() for creating a dynamic link in a table

I have a field in my dataset which I want to use to create a new field which is a URL in the below format - 

 

<a href="www.example.com/[`DatasetField`]" target="_blank">www.example.com/[`DatasetField`]</a>

 

Where `DatasetField` is a column in my dataset. 

 

I am doing CONCAT like on the lines I have mentioned but it does not escape quotes - 

 

CONCAT('<a href=','\"',"www.example.com/",`DatasetField`, "" target="_blank">https://www.example.com/",`DatasetField</a>)

 

I know I am missing something and not doing it right. Any help with this would be really appreciated.

 

Thanks.

 

Comments