How to escape a single quote in a dynamic expression with functions?

azure-data-factory-2
jamesbascle picture jamesbascle · May 16, 2018 · Viewed 7.7k times · Source

Need to insert a parameter into a string using the dynamic data function from the pipeline parameters. Have tried backslash, double backslash, double single quote,@, @@, and other such nonsense. Just need a simple way to escape a single quote in a string.

Answer

jamesbascle picture jamesbascle · May 16, 2018

I actually found out. It's 2 single quotes apparently. IO forgot to do it in both places, I had a single \ in the second place!

Related questions

Azure Data Factory v2 using utcnow() as a pipeline parameter

For context, I currently have a Data Factory v2 pipeline with a ForEach Activity that calls a Copy activity. The Copy Activity simply copies data from an FTP server to a blob storage container. Here is the pipeline json file : { "…

Read More
How to run SQL Script in Azure Data Factory v2?

There is NO Sql Script activity in Azure Data Factory V2. So how can I create a stored proc, a schema in a database? What are my options?

Read More
How to read files with .xlsx and .xls extension in Azure data factory?

I am trying to read and excel file in Azure Blob Storage with .xlsx extension in my azure data factory dataset. it throws following error Error found when processing 'Csv/Tsv Format Text' source 'Filename.xlsx' with row number 3: found …

Read More