: Can the POI name be modified and changed by eliminating the following in the title: USA, Canada and other unnecessary items not required.
Example when the voice discription for Murphy_USA the disription becomes one messed up word.
This happens to most descriptions and they become jumbled and very confusing.
Need to make changes.
Open the Murphy file using Excel.
Change the name of the first entry.
PASTE to every entry in the column.
Save your work.
As they are all text files, you can use the replace function in any text editor as well. Just perform a search for the unwanted characters replacing them with the desired ones (or none at all). and let the system do the replacements.
In the Murphy file, how would I select & delete everything except MURPHY in the file?
I think you can do that in MS Excel, through the use of filter and sort..
It's the same procedure in that you copy the text and paste it into the REPLACE function. The dialog normally comes up with an entry for the input string and another for the output string. That assumes all the entries are the same.
As the Murphy file hasn't been updated in 4 years, why not use the Wal-Mart file instead? It lists those locations that have fuel.
My point is that each entry in the Murphy IS unique. How would I do that in a text editor?
the other question is why are you using this particular file when it hasn't been updated in almost 4 years?
The find and replace only works with strings which are identical. So it could be used to delete everything except the store number - which personally I feel is useless information in a POI. The same goes for fax numbers and email/web addresses. I'm not going to use these from my GPS - are you?
He specifically asked about the Murphy file. I answered his question. In your first post you implied that a text editor was better. I wanted to know how it worked, as in the Murphy file. So I'm guessing it will not. Is that correct?
Using find and replace in any program including Excel requires an exact match. But the question still remains even for the OP - why are you using a 4 year old file or is it because you didn't realize the updated information was in the Wal-Mart file?
Using find and replace in any program including Excel requires an exact match.
Notepad can only do simple search and replace, but other text editors like UltraEdit can use pattern matching methods such as Regular Expressions. Also, Excel 2010 Help says that it supports the * and ? wildcard characters for searching.
Still I have to agree that the Murphy file is sufficiently stale that this is all rather academic.
terms | privacy | contactCopyright © 2006 - 2015