lab2gpx icon indicating copy to clipboard operation
lab2gpx copied to clipboard

Cachetur Export - extra special characters

Open vpdjgeo opened this issue 4 years ago • 1 comments

Love the Cachetur export - appreciate your quick turnaround - however it is not usable - since it contains special characters - ° and ′

LCGXNL01;lab;N 39° 45.455′ W 077° 34.873′;[L] Waynesboro History Tour : S1 Joseph J. Oller House

If you could remove those 4 special characters, this would work much better.

Thanks

VPDJ - Paul J

vpdjgeo avatar Jan 01 '22 02:01 vpdjgeo

Caused by UNICODE characters not recognized by EXCEL when opening the CSV file - workaround is to open the CSV file in Windows NOTEPAD and copy/paste from there.

Google says to add BOM character before the output may fix this: $bom = sprintf( "%c%c%c", 239, 187, 191); // EF BB BF file_put_contents( $file_name, $bom . $csv_string );

vpdjgeo avatar Dec 22 '22 16:12 vpdjgeo