q check/load csv with file name including "-" - KX Learning Hub

kdb+

q check/load csv with file name including "-"

Posted by renbright on August 22, 2023 at 12:00 am

I would like to load csv files and save it to kdb. Bute file name is like file-20230818.csv, which might not be recognized by q. How can I deal with the symbol “-“?

thanks

renbright replied 8 months, 2 weeks ago 2 Members · 2 Replies
2 Replies

rocuinneagain

Member
August 22, 2023 at 12:00 am
Use `$ to cast a string to a symbol

https://code.kx.com/q/ref/cast/
```
`$":file-with-dash.csv"
```
renbright

Member
August 22, 2023 at 12:00 am

thanks a lot. that works

Log In to Reply

Log in to reply.