Unusal double quote

[Radap]

Hi,

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:
Chr(34)
\u0022
\u201C
\u201D
\u201E

But nothing seems to be working.

Can anyone help?

Thanks in advance
Raniero

[Pravin_Patil1 (Pravin Patil)]

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

Just use copy that double quote and paste in replace.

Example :

varStr.Replace("“",String.empty).Replace("”",String.Empty) 

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

[Adrian_Star (Adrian Starukiewicz)]

Hi,
try regex to replace:

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

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

[Radap]

Thanks for the quick response,

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

[Radap]

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

[Adrian_Star (Adrian Starukiewicz)]

Ok, try this:

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

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

[prasath_S]

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)

[Pravin_Patil1 (Pravin Patil)]

@Adrian_Star

"[^a-zA-Z -]"

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

[Adrian_Star (Adrian Starukiewicz)]

Yes,
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

[Pravin_Patil1 (Pravin Patil)]

@Radap

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

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

[Radap]

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.

Raniero

[Radap]

this worked for me.

Thanks a lot for your help