By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,536 Members | 2,165 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,536 IT Pros & Developers. It's quick & easy.

re String Validation/ or something...

P: n/a
Hi there Bob,

To answer your questions:

1. I'm using MS SQL Server V8.0
2. Yeah there will be money, date/time data. All the DB will be

Its pretty tricky. Using the code Ray gave me and a bot of my own I
was able to populate the DB to an extent. The extent being *one*
insert per loop. So I ended up filling one field in a row, moving to
the next row and filling another field etc.

I've written out what I think *may* work in pseudocode but I'm new to
asp and can't turn it into code proper.

something like


if readline includes "[" then
this is a *tablename*
so until next "["
all readlines are "fieldame = data"
-->smlArray = split(readline, =)
-->store all smlArrays into bigArray
-->so until loop finds another "["
-->bigarray should be bigarray(smlarray0, smallarray1,smlarray2, etc)
then using bigarray construct insert as
insert into *tablename*(bigarray.smlarray1(0), bigarray.smlarray1(0),
values (bigarray.smlarray1(1), bigarray.smlarray1(1),etc)


Or maybe I'm completely wrong.
I don't know if said or if i merely implied but there a numerous
different tables. The file *will* hold data that will reflect the DBs

I'll post some more sample data in a differnt post, as this one seems
a tad long for usenet!

I appreciate any help you can give me.

Bob said:

Disregard my previous reply. I see what you're after.
1. What is the type and version of database you are using.
2. Your example data is all character (string) data. Will there be
or date/time data provided by these text files? Will the corresponding
fields be the same datatype (numeric or datetime)? Or are all the
character fields?
Jul 22 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.