Maybe it's split...
I want to be able to take data from a textbox containing carriage returns to split the records into an array so that I can add each line as a new record in a database. I want to try to avoid delimiting it by spaces, comma, and any other special character. I know that the data will be consistent with a line return.

Anyone have an idea?

you mean splitting a text and use line break as the delimiter?

if so, I'm not sure because I haven't tried it but how about =split(yourstring,chr(13))

Yeah, that's what I mean. Thanx I'll give it a try.

You may have better luck with split (your_string, vbCrLf) . I usually find it catches more line breaks that way.

Thanks Adam. That's actually what I ended up with. I replaced it with a comma and then split it as I thought this would be safer...?

txt = replace(request.form("multiNum"), vbcrlf, ",")
txtSplit=Split(txt, ",")
For i = LBound(txtSplit) TO UBound(txtSplit)
   'call function to insert records into database.
Next

Two things on that piece of code, Dan:

1) Your lower bound on a split array is always 0. So LBound (txtSplit) can be safely replaced with 0, and your script will perform somewhat faster (since no call to an ASP function is necessary.)

2) As far as your comma idea goes, I'm going to do something silly to illustrate a point. The reason I'm doing something silly is because your users will too.

Hello, my name is Adam.
I like cars, boats, and planes.

If you use the comma character as your split point, you'll end up with something like this:

Hello
my name is Adam.
I like cars
boats
and planes.

Which is probably what you don't want.

Good point and I probably wouldn't do something like this for a large scale app, but it's actually a very small web app for work and there is really only one way we will enter data. We generally have a list of numbers that are dynamic and other fields are pretty much static. So, to help increase efficiency, we can take just the list of numbers and have the server populate the other (relatively) static fields. I can also do some validation, but I don't think it'll be necessary.

Great catch and thanks again Adam!

No probs, dude. Good luck to you!