Post reply

Storing Carriage returns \ new line chars in a field

  • April 21, 2010 at 12:27 pm

    #144241

    Hi Guys,

    Im starting to work on an old db that was upsized form access and stores the address data in a single field with carriage returns \ new lines separating each bit of the address.

    I've tried using "+ char(13) + char(10) +" to go to the next line, but those chars seem to be stripped out when written to the table.

    Print 'LINE1' + char(13) + char(10) + 'LINE2' works fine.

    but:

    Select 'LINE1' + char(13) + char(10) + 'LINE2' doesnt. It strips the chars out and leave the strings on the same line.

    How do I go about storing the chars in a field?

    Thanks

  • April 21, 2010 at 12:51 pm

    #1155595

    The data is still there, you just probably doing a select using grid view. Change to "Results to Text"

    Also, ZZZZ + Char(10) + Char(13) + XXXX

    will be:

    ZZZZ

    XXXX

    just use char(13), no need to include the 10

    Run this statement with "Results to Grid" then with "Results to Text"

    select 'AAA' + char(13) + 'AAA'

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

  • April 21, 2010 at 1:03 pm

    #1155600

    GregoryF (4/21/2010)

    The data is still there, you just probably doing a select using grid view. Change to "Results to Text"

    Also, ZZZZ + Char(10) + Char(13) + XXXX

    will be:

    ZZZZ

    XXXX

    just use char(13), no need to include the 10

    Run this statement with "Results to Grid" then with "Results to Text"

    select 'AAA' + char(13) + 'AAA'

    Thanks for your quick reply.

    You're right.

    I've just tested exporting it back into Access and it looks great.

    Thanks again for the help.

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

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