modifying poi files

I am actually doing the same thing to my c330.....in order to localize you poi's you must know the lat and long of your city, then open the poi files, paste them into word and sort them in order i.e.

-43 344.56 33445653 --- ------------------------ -34.....
-41 233.33 23525345 ---------- ----------------- -41
-75 254.44 36435423 --- ------------------------ -43
-34 432.33 33242344 This list will become... -75

Then pick the ones out that match your city (i just go by the first two digits) and paste them back into your gps poi file. Maybe i am doing something crazy that no one else has done...maybe someone knows a better way. The part that will get you is the files that are too big for Word to handle....then you gotta split up files....a little patience was required for my system...but in the end it worked. Hope this helps.

before you do that stuff anyways and make sure that too much info will slow down your gps. Maybe it's a different issue.

You might find it easier to open the .csv file in Excel. You should not hit the limit you experienced (I open files with 15,000 items). You can do your sort easily, and then just delete the rows above and below the data you are interested in.

Always a better way!! I am not too keen on excel....I guess the demand is there now. You seem to be the excel wiz...you know where I could find a tutorial?? Anything will help....I tried to use excel yesterday but it jumbled all my lines together when I opened the finished product in notepad.

There are many tutorial books on the market for Excel. However, for the usage discussed here, it is very simple. (most likely, you did not save the excel file as the proper type, see step 4.)

1. Open the .csv file in Excel. You should see either 3 or 4 columns of information. The left column, column A, is the longitude.

2. Sorting the data is done in a two step procedure. Select all of the data (if you click the open square between the headers for rows and columns i.e. to the left of A and above 1, that will select the entire sheet. Then, under the menu item DATA, select sort and choose the appropriate criteria, in this case, Column A with no headers.

3. Deleteing rows is also simple. Highlight the rows you want to delte by clicking and dragging in the column where the row numbers are located. Right click and then delete.

4. Finally, save the file. When you go to save the file, you must choose CSV (comma deliminated) as the type. If you had jumbled data, you may not have saved it as the proper type. It should now open properly in notepad.

Thanks for the step by step....I just did one with all the subdivisions in the southeast (800 pages of lines), cut out all but Knoxville within about 7 minutes. Thanks a bunch!!!