Search code examples
csvkdbq-lang

kdb Q column name with spaces


I am importing a csv file to a table, but some columns have spaces in their names. Is there anyway around this or do I need to rename the columns before importing?


Solution

  • To remove spaces from column names in table t:

    t:xcol[`$ssr[;" ";""]each string cols t;t]