Good to know why this syntax works. It brings back fond memories of using MS Access 😊
-----Original Message----- From: Even Rouault <[email protected]> Sent: Friday, April 19, 2019 10:42 AM To: [email protected] Cc: Moskovitz, Bob@DOC <[email protected]>; John Baumgartner <[email protected]> Subject: Re: [gdal-dev] OGR SQL on CSV file with field name with parentheses? On vendredi 19 avril 2019 16:05:14 CEST Moskovitz, Bob@DOC wrote: > Thanks John, it worked perfectly! oh, indeed. Turns out SQLite is rather permissive in that area: https://gcc01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.sqlite.org%2Flang_keywords.html&data=02%7C01%7CBob.Moskovitz%40conservation.ca.gov%7Cf0ba36de77384ea4297108d6c4ee6494%7C4c5988ae5a0040e8b065a017f9c99494%7C0%7C0%7C636912925503570904&sdata=8dT7SGvGNq3lscnpcOkOhA4t2QNkh7UL9B7eiDW7Sxk%3D&reserved=0 (that said, OGR SQL only accepts double quotes when identifier quoting is needed) -- Spatialys - Geospatial professional services https://gcc01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.spatialys.com&data=02%7C01%7CBob.Moskovitz%40conservation.ca.gov%7Cf0ba36de77384ea4297108d6c4ee6494%7C4c5988ae5a0040e8b065a017f9c99494%7C0%7C0%7C636912925503570904&sdata=2PT287%2BeOJIl9i73dhes%2BVuh4AD%2BPnn1MswgWO3eHk0%3D&reserved=0 _______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
