Json string have dobbelt quotes ("" ""), cant make it to single quote (" ")

Help Studio
, , , , , ,
1

Hallo.
I have an json string, when i write it to the console or workbook it looks correct.
But when i try to use it in UiPath, it gives me dobbelt quotes like this:

@"[
{
““FullName””: ““Tonmmy Dehl””,
““PhoneNumber””: "“111111111"”,
““Day””: true,
““Night””: false
},
{
““FullName””: ““Deas Dem””,
““PhoneNumber””: ““22222222"”,
““Day””: false,
““Night””: true
}
]”

I have tried different things using .replace() but nothing is working, can someone please help :slight_smile:

it should look like this:

@“[
{
“FullName”: “Tonmmy Dehl”,
“PhoneNumber”: “111111111”,
“Day”: true,
“Night”: false
},
{
“FullName”: “Deas Dem”,
“PhoneNumber”: “22222222”,
“Day”: false,
“Night”: true
}
]”

2

@christian.bendtsen

Assign activity
To: correctedJsonString
Value: jsonString.Replace("""", """").Replace("““", """").Replace("”", """")
3

Hi @christian.bendtsen

Check the below thread,It might helps you

4

in_StrContactInfo.Replace(“”“”, “”“”).Replace(“““”, “”“”).Replace(“””, “”“”) gives me an error like this:

Error ERROR Validation Error Compiler error(s) encountered processing expression “in_StrContactInfo.Replace(”“”“, “””“).Replace(”“““, “””“).Replace(””“, “””“)”.(1) : error BC30027: ‘End Function’ expected.
(2) : error BC30648: String constants must end with a double quote.
(3) : error BC30198: ‘)’ expected.
(3) : error BC30198: ‘)’ expected.
(2) : error BC30516: Overload resolution failed because no accessible ‘Replace’ accepts this number of arguments. Misc/Misc_SentDataToAPI.xaml

5

hey :slight_smile:
I have already seen that, but i can make it work, can you give an example?

6

@christian.bendtsen,

This is from Immediate/Local panel right?
It’s normal thing. No need to replace it. Pass this to whatever activity you are trying to pass. There should not be an issue.

If any issue, put that here.

Thanks,
Ashok :slight_smile:

1 Like
7

Hi @christian.bendtsen ,

Could you show us a screenshot of how/where you get the visualization in the format same as provided by you ?

8

@christian.bendtsen

jsonString.Replace("“", """").Replace("”", """").Replace("""", "").Replace("""", "")
9

Hey Ashok

It is from the Immediate/local, reason why i think thats the problem is bacause, when i pass a normal string in with the correct json format, to the API, then it works fine…

10

@christian.bendtsen,

Any specific error you are getting with this format?

11

replaceCom…xaml (5.3 KB)
text.txt (301 Bytes)
regex.txt (23 Bytes)

Please try this workfloaw, i think it should work fine

image
image953×705 25.6 KB

inside of regex file is

””|““|””|““

inside of the text file

`[
{
““FullName””: ““Tonmmy Dehl””,
““PhoneNumber””: ““111111111””,
““Day””: true,
““Night””: false
},
{
““FullName””: ““Deas Dem””,
““PhoneNumber””: ““22222222"”,
““Day””: false,
““Night””: true
}
]

after you have read the files, input is the string from text file and regex is the string from regex file, add those two vrbl in assign activity System.Text.RegularExpressions.Regex.Replace( input, regex,"""")