Split a string for the double quote character "

[dterlizzi (Donato)]

Hi,

I need to split a string for the double quote character " , but I can’t find a solution that works.
variable.split(“”“”) doesn’t work.

Thanks

[Yoichi]

Hi,

If you use VB, the following will work.

variable.split(""""c)

or

variable.split({""""c})

Regards,

[Krishna_Raj]

@dterlizzi
Assign: YourArray = YourString.Split(“”""c)
For example, if you have the string: This is "a sample" string , after splitting, YourArray will be {"This is ", "a sample", " string"} .

[dterlizzi (Donato)]

I just discovered that the quotes are: “ and ” different from ". But I don’t know how to insert them into the split.
Thank you

[Yoichi]

Hi,

Can you share exact character which you want to split? As this forum autoamtically convert some double quote to other quote, try to use </> menu or share text file?

Regards,

[ppr (Peter Preuss)]

@dterlizzi

“ and ” different from ".

Sample and Analysis

Split Demo

[dterlizzi (Donato)]

“   ”

Open double quote (“): U+201C
Close double quote (”): U+201D
You can represent them using their Unicode values as follows:

Open double quote (“): \u201C
Close double quote (”): \u201D

Thanks

[Yoichi]

HI,
How about the following expression?

variable.split({""""c,ChrW(&H201C),ChrW(&H201D)})

Regards,

[dterlizzi (Donato)]

@Yoichi

variable.split({""""c,ChrW(&H201C),ChrW(&H201D)})

Thanks Yoichi it works!