Tab Delimited Files

scarymonkey · Posted: Fri Dec 12, 2008 2:38 pm Post subject: Tab Delimited Files

I may have missed this but I have been trying to use the Sygic POI Convertor to convert the speed camera files from here into the UPI format McGuider works. I am being hampered because the files in the ASC and CSV format are all comma delimited (which confuses the convertor). Without me downloading loads of other formats, does anyone know if any of them are in a tab delimited text format?

The main reason for trying to use the Sygic convertor is down to the problem MavAV had with his own POI files convertered using ov2upi. The fix was to convert them using Sygics convertor from tab delimited txt files.

Oldboy · Posted: Fri Dec 12, 2008 7:02 pm Post subject:

Do you have Excel?

If so, Open the File with Excel and then Save as Text (Tab Delimited)(*.txt). Just change the extension to .CSV or .ASC

Word, and some other wordprocessing applications, will also let you search for commas, and replace them with a Tab.
_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120

scarymonkey · Posted: Fri Dec 12, 2008 7:06 pm Post subject:

Oldboy · Posted: Fri Dec 12, 2008 7:23 pm Post subject:

Is that with Word?
_________________
Richard

TT 910 V7.903: Europe Map v1045
TT Via 135 App 12.075: Europe Map v1120

scarymonkey · Posted: Fri Dec 12, 2008 7:50 pm Post subject:

No in Excel. In terms of time difference there isn't much difference between the word and excel methods. The problem is more the amount of files to change (currently 30 for speed zoned).

I will also be contacting Sygic to ask for bulk conversion options to be made available in their convertor (as well as support for comma and tab delimiting). The main issue is likely to be the graphic to be associated with the upi file. It appears the file name to use is referenced in the upi file itself.

	PocketGPS
	Web