View Single Post
  #236  
Old 06-25-2008, 11:27 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

Quote:
Originally Posted by GeorgeS View Post
and the spells are all delimited by "^", and that was done for all the tools and required extensive work. I forgot the reason I changed it, but it must have been important then...lol

GeorgeS

LOL, if you use excel, you can make changes like this in a matter of seconds. Last night, I renamed your spells.txt file (didn't delete in case I had to roll back to it) and then took the spells_us.txt that my server runs which has about 20k lines, and converted it to replace the spells.txt in your resource directory. It took about 5 minutes. After all of the spell file work I did in the past, I learned to use textpad instead of notepad and also to use Excel when needed.

In order to convert the spells_us.txt file to the spells.txt file for your tools and to sort it alphabetically, all I had to do was open the spells_us.txt with Excel and import it as ^ delimited so that it separated the ID, Name and other columns. Next, just delete everything in columns C through HH or whatever it goes up to. Then, do a sort on column B (the name column) to sort them alphabetically. Then, just save the file as TAB delimited txt. Last, open the file up with textpad and do a replace on all TABs and change them to ^ again. Save the file and Viola!

Note that I use textpad (search google for it, it's awesome) for doing huge replaces like this because notepad takes FOREVER on the spell file lol.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote