Always getting "query error: near "~": syntax error" error about q

[jgclark]

I've now found a way to get the CSV into a SQLite file.
All my previous queries are now running OK, with only changing the filename they are working on.
Therefore the installation seems OK ... but there's still something funny odd going on with my CSV files?

[harelba]

Hi,

(Assuming I understand the issue properly, if not please write again and i'll help as much as i can).

Unfortunately, I haven't made q aware of the home folder ~ character, you would need to provide the full path and not use the ~ shortcut.

[jgclark]

Thanks. However I'm not using ~ as part of filenames when calling q. See example above.

[jgclark]

I had another look, and I think I've found where the ~ symbols are creeping in.
I'm running on macOS, and despite in the shall I'm only working in the current directory, it's doing full path expansion. And that starts '/Users/jonathan/Library/Mobile Documents/com~apple~CloudDocs/.
So, it's still not about the "home folder character", but it is about that character breaking q's processing in filepaths.