select substring of column, removing characters - Kdb+ / qStudio

Home Forums Kdb+ / qStudio select substring of column, removing characters

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #215

    Dave
    Guest

    What support does kdb have for string manipulation?
    In particular I want to substring a column to remove the first 3/4 characters?

    q)select name from mytable
    name
    ————–
    “NYSE-101031”
    “LSE -3012304”
    “LSE -2139405”
    “NYSE-1239485”

    I want just the numeric values from this column.

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.