POI Names and Voice Identification
Mon, 06/11/2012 - 12:04am
|
12 years
|
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.
Bohica157
Yes
Open the Murphy file using Excel.
Change the name of the first entry.
Highlight it.
Select COPY
PASTE to every entry in the column.
Save your work.
1490LMT 1450LMT 295w
use "Search and Destroy"
Open the Murphy file using Excel.
Change the name of the first entry.
Highlight it.
Select COPY
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.
Illiterate? Write for free help.
NotePad
Open the Murphy file using Excel.
Change the name of the first entry.
Highlight it.
Select COPY
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?
1490LMT 1450LMT 295w
MS Excel
Open the Murphy file using Excel.
Change the name of the first entry.
Highlight it.
Select COPY
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..
same procedure
Open the Murphy file using Excel.
Change the name of the first entry.
Highlight it.
Select COPY
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?
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.
Illiterate? Write for free help.
Doesn't really answer my question.
My point is that each entry in the Murphy IS unique. How would I do that in a text editor?
1490LMT 1450LMT 295w
and
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?
Illiterate? Write for free help.
Back to the OP
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?
1490LMT 1450LMT 295w
not in this file
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?
Illiterate? Write for free help.
Actually,
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.