Concatinate string in azure data factory

Question

0.00/5 (No votes)

See more:

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"}

Appreciate for help

What I have tried:

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

Posted 26-Mar-24 17:08pm

Vamsi Krishna from Unknown, Somewhere in France

Updated 26-Mar-24 19:11pm

Dave Kreskowiak

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Pete O'Hanlon · Answer 1 · 2024-03-26T20:53:00

Solution 1

If you are trying to get rid of \ without, that part of the @replace should be '\'. Your example has a space in the replace part, which would only match entries that have \ followed by a space. So, at this point, your replace would look like this:

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

As for creating the string output you are after, that's as simple as adding extra parts into the strings in your concat like this:

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

Posted 26-Mar-24 20:53pm

Pete O'Hanlon

Updated 27-Mar-24 5:31am

v3

Comments

Vamsi Krishna from Unknown, Somewhere in France 27-Mar-24 10:46am

thanks for the reply but I still see the same result with back slash added to it.

Pete O'Hanlon 27-Mar-24 11:05am

That was my mistake - I copied your original code in and left the space in '\ '. I've just updated the answer. Also, if you post what you're actually getting back, that would help.

Vamsi Krishna from Unknown, Somewhere in France 27-Mar-24 11:09am

sure, I am getting "Syntax error: Missing enclosing parenthesis"
I try adding and changing parenthesis positions but still getting same error. I used below string
@replace(concat('{','"','value,'"','}:','"',variables('requiredvalue'),'"','}'),'\','')

Pete O'Hanlon 27-Mar-24 11:32am

I have simplified the string. I was getting too cocky with the input and miscounted the ' characters.

Vamsi Krishna from Unknown, Somewhere in France 27-Mar-24 13:22pm

Got it, not sure where I am missing but still getting same output