TimeStored Blog

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

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

Log In Register Lost Password
Viewing 1 post (of 1 total)
  • Author
    Posts
  • April 10, 2013 at 8:53 pm #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.

  • Author
    Posts
Log In Register Lost Password
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.