Home Forums SQL Server 2008 T-SQL (SS2K8) How do delete multiple CHAR(9) at end of string RE: How do delete multiple CHAR(9) at end of string

  • October 15, 2013 at 6:05 pm

    #1658760

    Angelindiego (10/10/2013)

    turns out that there are spaces and tabs at the beginning and end of the file. Issue is to strip out all of this and just leave what is valid.

    If there are no tabs embedded in the useful data, just replace all occurances of CHAR(9) with nothing and then do an LTRIM/RTRIM to get rid of leading and trailing spaces.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)