Remove this symbol "

[fredrerik84]

Hi I have quick question. Ive run into a problem I dont know how to remove this symbol from a string "

Ive tried this:

sTitle = Replace(sTitle, """, "")

Anyone know how I can replace this symbol with nothing ?

frederik

 

[Rick Rothstein]

Here is a small sample that shows how it is stored in excel

<a href=http://www.filedropper.com/strangebehavior><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br /><div style=font-size:9px;font-family:Arial, Helvetica, sans-serif;width:127px;font-color:#44a854;> <a href=http://www.filedropper.com >share files free</a></div>

I no longer try figure out which download button or link is the right one from sites like the one you posted on... my suggestion would be to post it on DropBox.

 

[fredrerik84]

Ok rick. Ill remember that for future reference

 

[Rick Rothstein]

Its not styled,, Its scraped from a web pages and it looks like multilinetext in one cell but in not able to split it with this code:

sTitle = Trim(Split(sTitle, vbCrLf)(1))

It's not CHR(13), it's CHR(10)

Actually, vbCrLf is a two character sequence... a Carriage Return followed by a LineFeed, that is, a Chr(13) followed by a Chr(10). That character sequence is what PC's use to mark the end of a line (record) in a text file.

 

[Scott Huish]

Not disagreeing, but VBA returns the same ASCII code for both.

In the immediate window,

? ASC(vbcr) returns 13
? ASC(vbcrlf) returns 13

However, doing a direct comparison returns FALSE
? vbcr = vbcrlf
False

 

[Rick Rothstein]

Not disagreeing, but VBA returns the same ASCII code for both.

In the immediate window,

? ASC(vbcr) returns 13
? ASC(vbcrlf) returns 13

However, doing a direct comparison returns FALSE
? vbcr = vbcrlf
False

The ASC function returns the code for the first character in a text string even if that text string has more than one character in it.