Splitting Text into an Array

[nvanhaaster]

Quick question, I need to split a large amount of text into an array
everytime there is an enter (meaning line down) what is the code for
the delimiter i would use..

Example text

Hello
This is some sample
text that needs to be put
into an array
by everytime
we go to the next line

sample code

Array = Split(sampletext,?)

[Bob Barrows [MVP]]

nv*********@caitele.com wrote:

Quick question, I need to split a large amount of text into an array
everytime there is an enter (meaning line down) what is the code for
the delimiter i would use..

Probably vbCrLf, but it could be vbCr or vbLf. You'll need to try them to
see which works.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ray Costanzo [MVP]]

Try using vbCrLf

theArray = Split(sampletext, vbCrLf)

It's the VB[S] constant for carriage return + line feed.

Ray at work
<nv*********@caitele.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Quick question, I need to split a large amount of text into an array
everytime there is an enter (meaning line down) what is the code for
the delimiter i would use..

Example text

Hello
This is some sample
text that needs to be put
into an array
by everytime
we go to the next line

sample code

Array = Split(sampletext,?)