Forum Discussion
String concatination in ADF
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 .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.
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?
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 .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.
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\"}"
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.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.