Post reply

Parsing data using carriage returns

  • March 9, 2004 at 6:11 am

    #101904

    I need to pull data out of a tabel and parse it on carriage returns selecting only the data after the last carriage return.

     

    example

     

    blah blah 1 blah blah (carriage return)

    blah blah 2 blah blah (carriage return)

    blah blah 3 blah blah (carriage return)

    blah blah 4 blah blah (carriage return)

    blah blah 5 blah blah

    I only want it to return the

    blah blah 5 blah blah


    Darrell R. Whalen Jr.

  • March 9, 2004 at 7:17 am

    #497961

    SELECT RIGHT(colname,CHARINDEX(CHAR(13),REVERSE(colname))-1)

    FROM

    Far away is close at hand in the images of elsewhere.
    Anon.

  • March 9, 2004 at 8:45 am

    #497984

     

    Okay it is giving me an error that ntext is an improper argument for these functions.  Any idea on how to get around that?


    Darrell R. Whalen Jr.

  • March 9, 2004 at 8:54 am

    #497988

    Sorry never mind i used a convert and it works fine.


    Darrell R. Whalen Jr.

  • March 9, 2004 at 8:56 am

    #497990

    Okay so how do I give you credit for this?


    Darrell R. Whalen Jr.

Viewing 5 posts - 1 through 5 (of 5 total)

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