Post reply

Filed with Return Carridges

  • May 8, 2017 at 7:24 am

    #325373

    Hi There, 

    I have a field in my database table called ADDRESSFORMAT
    1,The Lodge
    Street
    Town
    Postcode
    Where the contents are seperated by a CHAR (13) and CHAR (10)
    How would I go about creating fields in a query that would only pull back either the first line, second line...and so on?

    Thanks

  • May 8, 2017 at 7:33 am

    #1941585

    Have a look at this article, and see whether you can get it working with CHAR(10) + CHAR(13) as a delimiter.

    John

  • May 8, 2017 at 8:54 am

    #1941602

    John Mitchell-245523 - Monday, May 8, 2017 7:33 AM

    Have a look at this article, and see whether you can get it working with CHAR(10) + CHAR(13) as a delimiter.

    John

    Last I checked, the standard was CHAR(13) + CHAR(10).   Not that I've never seen alternatives, but those have been rare - at least here in the USA anyway.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

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

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