Home PageFacebookRSS News Feed
PocketGPS
Web
SatNav,GPS,Navigation
Pocket GPS World - SatNavs | GPS | Speed Cameras: Forums

Pocket GPS World :: View topic - Editing POI file ??
 Forum FAQForum FAQ   SearchSearch   UsergroupsUsergroups   ProfileProfile   Log in for private messagesLog in for private messages   Log inLog in 

Editing POI file ??

 
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Points Of Interest (POIs)
View previous topic :: View next topic  
Author Message
paulthetool
Occasional Visitor


Joined: Nov 21, 2005
Posts: 45
Location: Clacton on sea, Essex

PostPosted: Sat Nov 26, 2005 3:44 pm    Post subject: Editing POI file ?? Reply with quote

Hi all,
is it posible to edit EVERY line in a POI file in one go without doing it line by line?
I would like to edit the description of every line in the gatso file
just to leave the speed. IE from GATSO:1518@60 to just 60 ?
this will allow me to show the speed next to the cam icon on the map
without the GATSO:1518@ bit cluttering up the map

Paul

paulyoung04@aol.com
Back to top
View user's profile Send private message Send e-mail MSN Messenger
Pocketgps
Lifetime Member


Joined: Nov 16, 2004
Posts: 2145
Location: Midlands, UK

PostPosted: Sat Nov 26, 2005 8:08 pm    Post subject: Reply with quote

If you load it into Excel then you could remove that column and replace it with whatever you require.
Back to top
View user's profile Send private message
paulthetool
Occasional Visitor


Joined: Nov 21, 2005
Posts: 45
Location: Clacton on sea, Essex

PostPosted: Sat Nov 26, 2005 8:23 pm    Post subject: Excel Reply with quote

I know I will be able to remove the whole colum with excel but it will also remove the speed part at the end !

Paul
Back to top
View user's profile Send private message Send e-mail MSN Messenger
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Dec 08, 2004
Posts: 10642
Location: Suffolk, UK

PostPosted: Sat Nov 26, 2005 8:29 pm    Post subject: Reply with quote

You could use something like Word to Find & Replace. Don't save it as a .doc file though.
_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120
Back to top
View user's profile Send private message Visit poster's website
Tim Buxton
Pocket GPS Moderator
Pocket GPS Moderator


Joined: 14/09/2002 20:56:18
Posts: 5231
Location: Surrey, United Kingdom

PostPosted: Sat Nov 26, 2005 8:30 pm    Post subject: Reply with quote

But then you'd have so many hundred(?) POIs called 30, which might confuse the software somewhat.
_________________
Tim
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Oldboy
Pocket GPS Moderator
Pocket GPS Moderator


Joined: Dec 08, 2004
Posts: 10642
Location: Suffolk, UK

PostPosted: Sat Nov 26, 2005 9:26 pm    Post subject: Reply with quote

... and also which one had been removed/changed etc.
_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120
Back to top
View user's profile Send private message Visit poster's website
Pocketgps
Lifetime Member


Joined: Nov 16, 2004
Posts: 2145
Location: Midlands, UK

PostPosted: Sun Nov 27, 2005 4:12 pm    Post subject: Re: Excel Reply with quote

paulthetool wrote:
I know I will be able to remove the whole colum with excel but it will also remove the speed part at the end !

Paul


You can select via the different menus within Excel what to remove in each column, you can break down each column and split it how you require, so no it does not remove all of the data.

You can put column breaks where ever you require, that's the whole point of Excel.
Back to top
View user's profile Send private message
paulthetool
Occasional Visitor


Joined: Nov 21, 2005
Posts: 45
Location: Clacton on sea, Essex

PostPosted: Sun Nov 27, 2005 4:54 pm    Post subject: Excel Reply with quote

I am trying to do this in Excel, but not sure what function to use ? Confused
Back to top
View user's profile Send private message Send e-mail MSN Messenger
JLee
Regular Visitor


Joined: Dec 11, 2005
Posts: 139
Location: Barnsley UK

PostPosted: Thu Dec 29, 2005 11:02 am    Post subject: Re: Excel Reply with quote

paulthetool wrote:
I know I will be able to remove the whole colum with excel but it will also remove the speed part at the end !

Paul

Just create a new column next to it and use a formula to leave the speed at the end. This assumes that the original column is A, the new column is B and the speed at the end is 2 characters:

1. Click in cell B1 and type the formula =Right(A1,2) and press enter.
2. Highlight all cells in column B down to row n where n is the last row that is filled in in column A (so if data in column A goes down to A350 highlight cells B1 to B350).
3. From the menu select Edit>Fill>Down.
4. Highlight the whole of column B and Edit>Copy, followed by Edit>Paste Special>Values.
5. That should give you what you want so just delete column A
Back to top
View user's profile Send private message Visit poster's website







Posted: Today    Post subject: Pocket GPS Advertising

Back to top
Display posts from previous:   
Post new topic   Reply to topic    Pocket GPS World Forum Index -> Points Of Interest (POIs) All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Make a Donation



CamerAlert Database

Click here for the PocketGPSWorld.com Speed Camera Database

Download Speed Camera Database
22.061 (05 Jun 24)



WORLDWIDE SPEED CAMERA SPOTTERS WANTED!

Click here to submit camera positions to the PocketGPSWorld.com Speed Camera Database


12mth Subscriber memberships awarded every week for verified new camera reports!

Submit Speed Camera Locations Now


CamerAlert Apps



iOS QR Code






Android QR Code







© Terms & Privacy


GPS Shopping