I want to use the Replace
function in VBScript to replace all line breaks in a string for "\n"
. I come from Java, so using \n
inside a string means a line break.
Is there an equivalent in VBScript?
36 Answers
For replace you can use vbCrLf
:
Replace(string, vbCrLf, "")
You can also use chr(13)+chr(10)
.
I seem to remember in some odd cases that chr(10)
comes before chr(13)
.
This page has a table of string constants including vbCrLf
vbCrLf
| Chr(13) & Chr(10) | Carriage return–linefeed combination
As David and Remou pointed out, vbCrLf
if you want a carriage-return-linefeed combination. Otherwise, Chr(13)
and Chr(10)
(although some VB-derivatives have vbCr
and vbLf
; VBScript may well have those, worth checking before using Chr
).
Tried and tested. I know that this works:
Replace(EmailText, vbNewLine, "<br>")
i.e. vbNewLine
is also the equivalent of \n
I had to use vbLf only in an ASP script where the original data was POSTed from a PHP script on a cPanel box over to ASP on a win server
(VBScript)
EmailText = Replace(EmailText, vbLf, "<br>")
I think it's vbcrlf
.
replace(s, vbcrlf, "<br />")
ncG1vNJzZmirpJawrLvVnqmfpJ%2Bse6S7zGiorp2jqbawutJoaWtoY2x%2BcXvIrGStoJWnsm66jJ6orqGmlrmmutNmoKdlppfApL7Iqas%3D