[DivineProgramming]

Title pretty much says it all.

I have about 1900 .txt files ranging from 120.0000 to 2 million lines each. They all say the same thing about a game character, but the structure is different.

Example: they all contain ID, playername, player item a to z and experience

But for somehow in a different order.

Any ideas?

[Charger]

Split the files into smaller sizes first off.

[c00lkid66]

I can help, but you need to post a few lines of each.

[DivineProgramming]

I can help, but you need to post a few lines of each.

Hey, i am on windows if that makes a difference.

The mysql database is a remote connection.

If you could help me with just email:password then that would save a lot of time. I could just upload the gamedatafiles manually.

[Backbone]

Do you have API's for that, or just a bare mysql connection?

[Jam1e]

Title pretty much says it all.

I have about 1900 .txt files ranging from 120.0000 to 2 million lines each. They all say the same thing about a game character, but the structure is different.

Example: they all contain ID, playername, player item a to z and experience

But for somehow in a different order.

Any ideas?

Would you be able to provide a little more information, please?
For example, can we see a couple of the different structures that you mention?

[DivineProgramming]

I wrote a python script for this. Thanks for the tips thougj