Print Page | Close Window

Textarea Different Format

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=9895
Printed Date: 29 March 2026 at 6:02am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Textarea Different Format
Posted By: nsf247
Subject: Textarea Different Format
Date Posted: 17 February 2004 at 12:17pm

Thanks all for your help on that previous question. Now if i can tap your brain once more with something similar. Been reading up on multi-dimensional arrays. All examples seem to have hardcoded arrays.
My data will always be different with really no limits. But i have a format question and how to split this array into two variables. Say I have a text area. I need people to type a name and a number next to each other seperated by a space.

<Textarea>
PETER 1<ENTER>
PAUL 15<ENTER>
MARY 32
</textarea>

Now how can I split NAME and the number next to it, seperated by the space as a delimeter, put name into one array and number into another array and tell my database that I need the number next to that name(which is already in the database) to be placed into the number column next to it's corresponding name.

Although the actual ACCESS database table is a little more complex, essentially, It would look like this for this example before any data was submitted.

NAME      NUMBER
PETER
PAUL
MARY

We need the table to look like this after submit.
NAME NUMBER
Peter      1
Paul       15
Mary      32

I guess I'm asking how do i grab both sets of data submitted in the format described in the text area into two arrays and then into they're own seperate variables that I can call into an INSERT String and then i guess i'll have to figure out how to compare. Man, I'm confusing myself. Confused

I think this might be clear, if not let me know and I'll try to extrapolate. Thanks all.

 

 

 




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net