walberty
Posts: 1
Joined: Tue Apr 14, 2009 1:15 pm
Location: Australia

Coverting complext CSV files

Tue Apr 14, 2009 1:17 pm

I have a CSV which contains data collected during a WLAN site survey. This files contains "header" records for each location, and multiple san records recording informatino about the various WLAN sources found. I want to only convert the lat/long fields in the "header" records. Is there a way to do this with CoordTrans? Here is a sample of the CSV file:

GPSPosition,-41.6780733333333,171.876368333333,0,24/03/2009 5:18:49 p.m.
GPSSpeed,0,24/03/2009 5:18:49 p.m.
EnableScan,24/03/2009 5:18:50 p.m.
ScanStart,24/03/2009 5:18:50 p.m.
ScanComplete,0,0,0,0,24/03/2009 5:18:50 p.m.
ScanResult,SELGC1_FMS_No_Unauthorised_Axess,0023042D4710,49,-75,-100,24/03/2009 4:18:50 a.m.,24/03/2009 5:18:50 p.m.
ScanResult,SELGC1_FMS_No_Unauthorised_Axess,00233316F820,49,-70,-100,24/03/2009 4:18:50 a.m.,24/03/2009 5:18:50 p.m.

Return to “CoordTrans”