Unusal double quote


I have this string saved in a data table that I ham scraping from a website:

“Christmas Season- “See You Zoom See You Soon” Online English Storytelling”

I am now trying to replace the double quotes around the “See You Zoom See You Soon” but I can’t seem to be able to do that.

I have tried looking for the following either inside a Contains or Replace function:

But nothing seems to be working.

Can anyone help?

Thanks in advance

Actually, those double quotes are different than programming double quotes.

Just use copy that double quote and paste in replace.

Example :


Just copy paste above as it is and change with your string variable

try regex to replace:

output = System.Text.RegularExpressions.Regex.Replace(your_String,"(“|”|\")","")

Preview link: regex101: build, test, and debug regex

Thanks for the quick response,

I have tried your approach but it didn’t seem to work:

Thanks for the quick response, I have tried to use this but it’s giving me a compiler error:

Ok, try this:

output = System.Text.RegularExpressions.Regex.Replace(your_String,"[^a-zA-Z -]","")

Preview link: regex101: build, test, and debug regex


Hi @Radap

Please try this

Regex Pattern : [\w\d/_$%()&-\]+

And in assign activity store the text

strText - string
mtchColl - matches activity output

strText = string.join(" ",mtchColl.Cast(of match).Select(function(d) d.ToString).toarray)

But it will remove all numbers and other characters than words… Unless he is ok with it…

You have right,
possibly it will be better:

output = System.Text.RegularExpressions.Regex.Replace(your_String,"[^[\p{L}|\p{N}|\s|-]","")

Preview link: regex101: build, test, and debug regex

varStr.Replace(ChrW(&H2018), String.Empty).Replace(ChrW(&H2019),String.Empty).Replace(ChrW(&H201C),String.Empty).Replace(ChrW(&H201D), String.Empty)

This will definitely work. Try and let me know

1 Like

Thanks, I have tried this and albeit it might work for the specific string it was excluding other characters present in other strings. ended up using Pravin’s approach at the end.

Thanks for your support, RegEx is something I need to spend some time on.


this worked for me.

Thanks a lot for your help

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.