Post reply

derived column syntax error

  • October 25, 2012 at 8:19 pm

    #269104

    hi,

    i am using this expression

    substring([Column 0],findstring( [Column 0],"TH",1),findstring( [Column 0],"\",1))

    now i am getting error at "\", if i replace it with any other character ,its fine

    whats solution

  • October 26, 2012 at 12:03 am

    #1553043

    The backslash is a special character, you need to escape it with another backslash.

    substring([Column 0],findstring( [Column 0],"TH",1),findstring( [Column 0],"\\",1))

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 26, 2012 at 6:56 am

    #1553140

    thanks got solved

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply