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.
Re: carriage returns within text qualifiers affecting import
Here is an example with a few lines from the text file
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1