Is there "\n" equivalent in VBscript?

Question

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?

@David actually prefer to use `vbNewLine` which isn’t environment specific (will match `vbCr`, `vbLf` and `vbCrLf`). — user692942, Sep 17 '20 at 06:56
Replace of "\n" like in Java strings you have to use vbLf as equivalent, "\r" is then vbCr and "\r\n" is vbCrLf. — VBWebProfi, Jan 26 '23 at 09:08

score 54 · Accepted Answer · edited Feb 09 '21 at 09:10

54

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).

edited Feb 09 '21 at 09:10

Roberto Caboni

7,252
10
25
39

answered Feb 04 '10 at 22:31

Fionnuala

90,370
7
114
152

2

I remember that some line breaks where only `chr(13)`, some only `chr(10)`, and some `VbCrLf`. – Zohar Peled May 25 '15 at 16:06
I appreciate the 2nd meanings in your example (Replace the STRING of VB's STUPID CR/LF's with empty string `""`) – bobobobo May 18 '18 at 19:30
@ZoharPeled in which case use `vbNewLine` instead to cover both scenarios. – user692942 Sep 17 '20 at 06:57

ChrisF · Answer 2 · 2021-02-09T09:35:22.933

16

This page has a table of string constants including vbCrLf

vbCrLf | Chr(13) & Chr(10) | Carriage return–linefeed combination

edited Feb 09 '21 at 09:35

answered Feb 04 '10 at 22:32

ChrisF

134,786
31
255
325

score 10 · Answer 3 · answered Feb 04 '10 at 22:34

10

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).

answered Feb 04 '10 at 22:34

T.J. Crowder

1,031,962
187
1,923
1,875

score 6 · Answer 4 · answered Nov 29 '16 at 12:45

6

Tried and tested. I know that this works:

Replace(EmailText, vbNewLine, "<br>")

i.e. vbNewLine is also the equivalent of \n

answered Nov 29 '16 at 12:45

iOSAndroidWindowsMobileAppsDev

2,846
30
32

score 4 · Answer 5 · edited Feb 09 '21 at 09:11

4

I think it's vbcrlf.

replace(s, vbcrlf, "<br />")

edited Feb 09 '21 at 09:11

Roberto Caboni

7,252
10
25
39

answered Feb 04 '10 at 22:30

David

3,519
1
24
30

score 4 · Answer 6 · answered Apr 29 '15 at 05:47

4

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>")

answered Apr 29 '15 at 05:47

Rit Man

51
2

Is there "\n" equivalent in VBscript?

6 Answers6

Linked

Related