How to use replace for double quotes

Help Studio
, ,
1

Hi Everyone ,

My requirement is i need to replace the different types of double quotes

“ - “
” - ”
" - &quot

i have to replace these garbage values with quotes

eg: row1(“Col0”).Tostring.Replace(“””,“”") i am getting error for this @Palaniyappan @Gokul001 please help

Thanks in advance

2

Hi,

The following post might help you. Can you try to use ChrW(8220) and ChrW(8221)?

Regards,

3

Protoyped the replacing with replacing to # for visual reasons
grafik

strPattern = String.Format("({0})", String.Join("|",{"""",ChrW(8220),ChrW(8221),"""}))
 strPattern
 "(\"|“|”|")"
 strText
 @"“ - “
 ” - ”
 “ - ”
 "" - ""
 "" - ""
 Regex.Replace(strText, strPattern,"#")
 @"# - #
 # - #
 # - #
 # - #
 # - #"
4

No , i need to replace &#8220 with “ or ” or " , not the other way around

5

@kavya.s16 , Could you provide us with sample inputs that contain these kind of values that we need to replace?

We want to identify if it follows a particular pattern or is it always the same value.

6

Company Holdings Advisors (Beijing) Company Limited (“BJWFOE”)

Is being extracted as Company Holdings Advisors (Beijing) Company Limited ("BJWFOE")

so i am trying to replace it
HTML 4.0 Special Entities according to data in this link

“ - & #8220;
” - & #8221;
" - & quot;

i have to replace them respectively

7

As showcased above

  • define an array of characters/strings you want to replace
  • get from this the regex pattern
  • replace it with Regex.Replace
8

can u provide the xaml if possible please!!

9

could u tell how to replace it with quotes instead of #

& #8220; ------- “
& #8221; --------”
& quot; -------"

@Palaniyappan @Gokul001

10

Hi @kavya.s16,

As @supermanPunch suggested, please provide both

  1. Your input sample strings
  2. Your required output after the replace

This way the forum members get a better idea what your inputs and expected output are. In such forums, asking questions clearly is important to get your problem resolved quickly.

11

image
image943×307 10.8 KB

above are the extracted data with garbage value/html entities
below is the actual data , so i need to use replace function @Palaniyappan @Gokul001 @jeevith @supermanPunch @ppr

12

@kavya.s16 , In that case, could you provide us with this Excel File, it would help us faster to work on the solution/suggest the steps required.

13

apologies , uploading file from client machine is restricted , i could just provide screenshot :frowning:

14

Lets Crosscheck If HTML entity Decoding will better serve for the case

1 Like
15

Hi,

FYI, the following is ppr’s way.

image

System.Web.HttpUtility.HtmlDecode(yourString)

Regards,

1 Like
16

do i need to install any package to use this?

17

Hi,

Nope, we can use this method in default settings.

Regards,

18

@kavya.s16

for using

HttpUtility.HtmlDecode(yourString)

we will modify the XAML file in some cases, when the statement is not recognized by the compiler

  • Take a backup from your file in advance
  • open the xaml within a text editor (e.g. notepad++)
    add following line to it
    grafik
    grafik704×79 29.2 KB

    <AssemblyReference>System.Web</AssemblyReference>
    reopen it in Studio

find starter help here:
EncodeDecodeStrings.xaml (5.5 KB)

19

Hi @Yoichi , i need to replace with this string “ which is left double quotation mark

I used HttpUtility.HtmlDecode(““”).Replace(“)
but it says string constants must end with double quotes @Palaniyappan @ppr

could u please help

20

Hi,

Do you want to replace double quote with left double quote? If so, the following will work

yourString.Replace(Chr(34),ChrW(8220))

Regards,