Forum Discussion

krishn's avatar
krishn
Icon for Helper I rankHelper I
2 years ago
Solved

String concatination in ADF

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 w...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

krishn's avatar
krishn
Icon for Helper I rankHelper I
2 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      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 .