I am using the example here to load a csv file...
https://code.kx.com/q/learn/tour/csvs/
But changed it slightly as I need to do this via a remote connection.
I know the file is where it needs to be...where con
is the remote connection
q)con "\\cat /temp/example-mount/example.csv"
"id,price,qty"
"kikb,36.05,90"
"hlfe,96.57,84"
"mcej,91.34,63"
"iemn,57.12,93"
"femn,63.64,54"
"engn,94.56,38"
"edhp,63.31,97"
"ggna,72.39,88"
"mjlg,12.04,58"
..
But when I try to load the file...
q)con "t:(\"SFI\";enlist\",\") 0: `:/temp/example-mount/example.csv"
'/
[0] con "t:(\"SFI\";enlist\",\") 0: `:/temp/example-mount/example.csv"
^
Anyone know what might be wrong with the syntax? I'm guessing it has to do with escaping but I can't get it to work after changing it from the link. I tried via pykx with similar results.
You cannot create a symbol containing special characters such as -
without creating as a string with ""
and then casting to symbol `$
q)`:/temp/example-mount/example.csv
'/
[0] `:/temp/example-mount/example.csv
^
q)`$":/temp/example-mount/example.csv"
`:/temp/example-mount/example.csv
Try
con "t:(\"SFI\";enlist\",\") 0: `$\":/temp/example-mount/example.csv\""