Post reply

carriage return

  • December 5, 2005 at 4:27 pm

    #166433

    Hi,

    I am extracting data in comma delimited format and one of my rows has gone to the next line.  I think it is because the data in that column may have a carriage return at the end of it, but I can't see this in the table.  How can I check to see if there are any non-displayable characters in my data?

    thanks...

     

  • December 5, 2005 at 5:51 pm

    #607841

    REPLACE(Replace(OutputString, CHAR(13), ''), CHAR(10), '')

    For everything else use double quotes.

    _____________
    Code for TallyGenerator

  • December 5, 2005 at 6:16 pm

    #607846

    thanks for your help, this worked...

     

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

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