I am working on a data flow to clean invalid characters from incoming data. I am using a derived column , and adding a column pattern, for each column that matches type=='string', with a column name expression of $$, all of which is fine. For the value expression, I need something like this - replace(replace($$,"Á","a"),"Â","a"))
If I hard code this, it works great replacing all instances in all string fields with a lower case a. But we have a table of 60+ characters in a sql table that we don't allow , and I have a stored proc that generates a multiple replace statement like the one above. But when I pass it as a parameter from the data factory it adds escape characters before each double quote. I get this - replace(replace($$,/"Á/",/"a/"),/"Â/",/"a/"))
which doesn't evaluate. Does anyone know of a way to NOT escape double quotes?