The first argument in the method InputStringVariable.Split(argumentAsArray, second argument) should be an ARRAY not a string.
Instead of using “\r\n” (which loses its special meaning inside double quotes), either use vbCr+vbLf or vbNewLine OR as most have suggested, Environment.NewLine
I am now trying to concatenate strings with line breaks instead of splitting them.
I want to create a multi-line delimiter to split a text document.
The overall delimiter looks something like this.
\r\n is the actual carriage return and line feed, they are shown here as escape characters for visualization purposes.
Address\r\n
Line 1\r\n
Line 2\r\n
Line 3\r\n
To create this delimiter, I have to put together two strings.
“Address”
“Line 1\r\nLine2\r\nLine3\r\n”
How do I concatenate the two strings together with the \r\n in the middle? (only one line break)
I tried using Environment.NewLine but I printed this out in a message box, the concatenated result is a two line break.
I tried using vbCrLf etc. but I get the same result as well
It seems like I tried all the options listed (vbNewLine, vbNewLine, vbCrLf, Environment.NewLine) but I can’t get the exact results. I keep getting double line break instead of single line break when I try to print the result in a message box.