Hi,
I’m trying to do a regex to exclude double quotes after the character }. Right now, I have the following regex:
This regex matches }". But I want to exclude the } character from it.
Do you know how to achieve this?
This regex matches }". But I want to exclude the } character from it.
Do you know how to achieve this?
If would you like to remove the double quote after every close curly braces }, Then use the below expression
System.Text.RegularExpressions.Regex.Replace(Input.toString, "(?<=\})\""", "")
Above expression will remove the double quote after every }
Hope it helps!!
try below regex
System.Text.RegularExpressions.Regex.Replace(yourString, “[}]”, “”)
Instead of regex simply you can use
yourstring.replace(“}”,“”)
System.Text.RegularExpressions.Regex.Replace(Input, “(?<=Quote)”“”, “”)
Please try this.
if it is working then please mark it as solution!!
happy automation!!
Please try this
str_Output = System.Text.RegularExpressions.Regex.Replace(str_Input,"}(?="")","")
Regards,
Your text snippet looks like JSON and we recommend processing it also with JSON related options.
So, what is your overall goal?
1 Like
Hello @Catarina_Fantasia_Valente
As Peter suggests above, you could use native activities for handling JSON.
For example use Deserialize JSON and afterwards grab the values from the object that you seek.
Example file:
Example extraction:
Regards
Soren
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.