| View previous topic :: View next topic |
| Author |
Message |
southfield69
Occasional Visitor
Joined: Aug 12, 2006
Posts: 1
|
 Posted: Thu Aug 14, 2008 7:21 am Post subject: POI lists with phone numbers formatted scientific notation! |
 |
|
| To name just one of many examples, the free POI list for Supermarkets - Budgens is almost wholly unusable from a phone number point of view. The phone numbers have been reformatted (presumably by excel) into scientific notation.... |
|
| Back to top |
|
 |
Anita
Pocket GPS Moderator
Joined: Mar 15, 2006
Posts: 3219
Location: Windlesham, Surrey
|
| Posted: Thu Aug 14, 2008 10:38 am Post subject: |
|
|
What device are you using?
The Budgens phone numbers are fine on my TomTom 720.
_________________
Anita
TomTom VIA 135 - App 12.075
UK map 1125.12264
Samsung Galaxy S21 |
|
| Back to top |
|
|
GerryC
Pocket GPS Moderator
Joined: Mar 01, 2005
Posts: 1513
Location: West Mids
|
| Posted: Thu Aug 14, 2008 7:19 pm Post subject: |
|
|
If you are looking at the data on Excel, widen the column. If the number is too big for the column width to show, it goes into scientific notation.
Probably best to import it as text as well as I'm not sure how it likes the leading 0. 
_________________
Gerry
TomTom730T
Cameralert for Android
Brodit ProClip mount |
|
| Back to top |
|
|
mikealder
Pocket GPS Moderator
Joined: Jan 14, 2005
Posts: 19638
Location: Blackpool , Lancs
|
| Posted: Thu Aug 14, 2008 7:46 pm Post subject: |
|
|
| Don't use Excel for this as it can mess up the data, if you want to open a file right click it and choose pen With "Note Pad" this will display the files true contents - Mike |
|
| Back to top |
|
|
Oldboy
Pocket GPS Moderator
Joined: Dec 08, 2004
Posts: 10641
Location: Suffolk, UK
|
| Posted: Thu Aug 14, 2008 9:06 pm Post subject: |
|
|
| GerryC wrote: | | Probably best to import it as text as well as I'm not sure how it likes the leading 0. |
There shouldn't be a leading 0 on the number.
The CSV files should be +44xxxxxxxxxxx.
The OV2 files uses a 'great than' symbol instead of the '+', because that's what the TT needs.
_________________
Richard
TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120 |
|
| Back to top |
|
|
GerryC
Pocket GPS Moderator
Joined: Mar 01, 2005
Posts: 1513
Location: West Mids
|
| Posted: Thu Aug 14, 2008 10:03 pm Post subject: |
|
|
Sorry Richard. I'd forgotten about the + as I use the ov2 format 'greater than' and couldn't think why that would cause a problem. Of course, the + will be ignored by excel. 
Back to southfield69, personally, I'd go with Mike's suggestion and open the csv file with notepad. 
_________________
Gerry
TomTom730T
Cameralert for Android
Brodit ProClip mount |
|
| Back to top |
|
|
|
![]() Posted: Today Post subject: Pocket GPS Advertising |
|
|
We see you’re using an ad-blocker. We’re fine with that and won’t stop you visiting the site.
Have you considered making a donation towards website running costs?. Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!
|
|
| Back to top |
|
|
|
Forum FAQ
Search
Usergroups
Profile
Log in for private messages
Log in
