parsing multiline textbox

[arby]

I need to split a multiline textbox into separate lines. I tried parsing it using instr(vbcrlf,textbox1.text) in a loop to locate the end of each line but no success

Does anyone have a solution?

 

[Rocky Moore]

Have you tried the string "Split" method? It will build an array of all
lines.

--
Rocky Moore
www.RJSoft.com
www.HintsAndTips.com - Share your tips with the world!
~~~~~~~~~ Developer Tips Welcome! ~~~~~~~~~

I need to split a multiline textbox into separate lines. I tried parsing

it using instr(vbcrlf,textbox1.text) in a loop to locate the end of each
line but no success.

 

[Jos]

I need to split a multiline textbox into separate lines. I tried
parsing it using instr(vbcrlf,textbox1.text) in a loop to locate the
end of each line but no success.

Does anyone have a solution?

You swapped the arguments for Instr.
Use:
InStr(textbox1.text, vbcrlf)

Anyway, Rocky's solution is better.

 

[arby]

Thanks! The string.split method works great. I ended up using something like

strAnswers = Replace(txtAnswers.Text, vbLf, "").Split(vbCr

Since each line is actually split by 2 characters, 1 LF and 1 CR, this code snipet gives you very clean results (ie. no embedded LFs or empty array elements)