topic Re: String concatination in ADF in Pipelines

String concatination in ADF

krishn — Wed, 27 Mar 2024 04:21:12 GMT

we are trying to concatinate three strings including " in it, but Azure data factory adding as ". Question is how do we get rid of \ character. I Have one set variable returning value ABCDEFG and I wanted to concatenate with other data to populate like below in a variable. {"value"}:{"ABCDEFG"}

I am using the syntax in set variable like @replace(concat('{','"','value:',variables('requiredvalue'),'}'),'\ ','') and I am getting output value as "value": "{"value:ABCDEFG}"

Appreciate for help

I am using the syntax in set variable like @replace(concat('{','"','value:',variables('requiredvalue'),'}'),'\ ','') and I am getting output value as "value": "{"value:ABCDEFG}"

expected output {"value"}:{"ABCDEFG"}

Re: String concatination in ADF

Anonymous — Wed, 27 Mar 2024 05:29:54 GMT

Hi krishn ,

Thanks for using Fabric Community.
Can you please try this expression?

@concat('{"value"}:{"', variables('requiredvalue'), '"}')

Let me know if this works or not?

Re: String concatination in ADF

Anonymous — Thu, 28 Mar 2024 08:26:56 GMT

Hello krishn ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .

Re: String concatination in ADF

krishn — Thu, 28 Mar 2024 16:22:15 GMT

I tried this in first place but we are betting the below resule added \ to it, we also validated priting the same string but is still there. Ultimately we wanted to get rid of \ added

"{\"value\"}:{\"ABCDEFG\"}"

Re: String concatination in ADF

Anonymous — Thu, 28 Mar 2024 17:14:51 GMT

Hi krishn ,

\ is an escape sequence inorder to preserve " in string and it will not include when you print the output.

Escape Sequences | Microsoft Learn

For Example:

Hope this is helpful. Please let me know incase of further queries.

Re: String concatination in ADF

krishn — Thu, 28 Mar 2024 19:25:07 GMT

This is helpful, so we are planning to pass this variable to another web activity as input variable as a parameter in relative string. So we don't have to exclude \ correct. Appreciate.

Re: String concatination in ADF

Anonymous — Thu, 28 Mar 2024 19:36:12 GMT

Yes there is no need to exclude \ as this is considered as escape sequence. Inorder to achieve your goal, you can use this -

@concat('{"value"}:{"', variables('requiredvalue'), '"}')

I hope this answers your query. Please let me know incase if you have further queries.

Re: String concatination in ADF

Anonymous — Mon, 01 Apr 2024 04:01:31 GMT

Hi krishn ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

Re: String concatination in ADF

krishn — Tue, 02 Apr 2024 00:01:40 GMT

Apologies for delay, we validated the same and re-produced same result. Within the application it is excluding \ character however if we print this to a csv or txt file in blob object it is still printing the \ character. Seems we have to use StoredProcedure or Databricks activities to pars string. Appreciate for help.

Re: String concatination in ADF

Anonymous — Tue, 02 Apr 2024 03:11:29 GMT

Hi krishn ,

Glad to know that you got some insights.
Please continue using Fabric Community on your further queries.

Re: String concatination in ADF

krishn — Tue, 02 Apr 2024 14:25:46 GMT

Hi Team, as per the recommendation it is not required to eliminate \ special character from string. But we observed these special characters are printing when we copy it to CSV/text file in Blob storage. As long as value stay in Azure environment we do not have to worry about \ character. We are working on alternatives. Appreciate for help.