+ Reply to Thread
Results 1 to 2 of 2

carriage returns within text qualifiers affecting import

  1. #1
    Registered User
    Join Date
    11-05-2010
    Location
    Austin
    MS-Off Ver
    Excel 2007
    Posts
    2

    carriage returns within text qualifiers affecting import

    I'm trying to import a text file into excel. The file is tab delimited and uses double quotations as a text qualifier. One of the fields in the text file is a note field and every now and then the person entering the note uses a carriage return (hits the enter key) while doing so. When this comes through in the text file it looks like this...

    "this is a note.
    this is the second line of the note"

    My understanding is that everything between the two instances of text qualifers should be treated as a single value and the carriage return disregarded. However when I import it the data comes in exactly as it is above which causes field types and column headings to not match up.

    Can anyone tell me a way around this short of manually deleting each carriage return?
    Last edited by AWetzel; 11-05-2010 at 06:01 PM.

  2. #2
    Registered User
    Join Date
    11-05-2010
    Location
    Austin
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: carriage returns within text qualifiers affecting import

    Here is an example with a few lines from the text file
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1