small problem

[Hole]

hello

 

I just wanna ask how can i do this.

 

The problem is i have a database that looks like this

 

#232323

xxxxx xxxxx xxxxx xxxxx

xxxxx xxxxxxx xxxxxxxxxxxxxxxx

xxxxxxxx xxxx

 

#233224

 

I need to get the xxxxxx into a field in a database. If there is a nice way already present on the board please point me to it, cos im new to VB.net.

 

There are around 3000 such sets in a txt file.

[bungpeng]

database looks like this? I don't understand what is xxxx xxxx xxxx....

[Hole]

the xxxxxx are numbers, but i posted xxx instead of them and they are separated by space :)

[Nerseus]

Do you mean you have a text file that looks like:

#232323
xxxxx xxxxx xxxxx xxxxx
xxxxx xxxxxxx xxxxxxxxxxxxxxxx
xxxxxxxx xxxx
#233224

 

And you need to parse the numbers into individual fields and save them to the database?

 

-nerseus

[Hole]

yes

[Nerseus]

How much programming do you know? Do you know how to connect to the DB and save records? Do you know how to read text files? Do you know how to read in strings and possibly use regular expressions (or just Substring method calls)?

 

-Nerseus

[Hole]

i know how to connect to a database and thats about it. I do know a little about the rest but not enough to write the programm myself.

[Nerseus]

Well, we don't write programs for people here. We expect you to try and write the program. As you go along and run into specific problems, we love to help out!

 

I would start by writing a few test apps. Try updating a database table (assuming you already have a table created). Make sure all that code works.

 

Next try reading from the text file. Look at the various classes in System.IO - there are plenty to choose from. Getting to know them so you know which is best is half the fun of programming.

 

Finally, you'll need to parse what you read. You could use simple substring and fixed offsets, or various methods to split the string based on a space, or maybe use Regular Expressions. If you want to try regular expressions, search these forums and the help files for examples.

 

-ner

[Hole]

will do, thx for the help and ill get back here when i hit a problem i cant solve.