What happened to this line?

Question

I'm trying to delete everything "from a string named s1, I have this string

s1=replace (s1, """, "")

But I get a compilation error saying what the list separator expects or)

How can i fix this? Thanks in advance.

Answer 1

Your second line will not be correctly split. If you want to use quotation mark ( ") inside your string, you need to double it. Since your string consists only of quotation marks, it looks like this:

• Sign of the quotes to start the line ".
• Double quotation mark, which is a single row within the quotes, "".
• Trailing quote ".

In short:

s1 = Replace(s1, """", "")

Answer 2

- , , /.

s1 = Replace(s1, Chr(34), "")

- - , 256 ASCII, Chr().

http://msdn.microsoft.com/en-us/library/4z4t9ed1%28v=VS.80%29.aspx

Answer 3

Are you really writing """? You need to avoid "in the middle - just double it, like:

replace( s1, """", "" )

Answer 4

Commonly used syntaxes:

s1=replace (s1, "\"", "")
s1=replace (s1, """", "")
s1=replace (s1, '"', "")