How do I import a pipe delimited file with text that contains a few commas?
I have a pipe delimited file, which has commas in some of the text. This file that I am importing is a .txt file and I am finding that when I import it all of the information is in the first column just how it should be apart from when there is commas in any of the sentances of the information that I had imported it places the text after the comma in the next cell.
How can I stop that from happening or how can I change it back to commas from tabs.
I hope you can help me here, as I have tried doing a script for it using PHP, but I am not having much success at doing that either.
I throught that I would just reply to saying that I have now solved the problem with the columns by uploading my data using a .csv file instead of a .txt file.
The only problem that I have now is that it is not importing the rows of data from the .csv that contain a quote (")
Could someone please tell me how I may resolve that issue.
Last edited by john928; 02-09-2005 at 10:32 PM.
Reason: I have run into another problem!
Can somebody please, please help me. I have been trying to figure this out for a while now.
I hope that this is what you are looking for:
Open the text file - either .csv or .txt
The "Text Import Wizard" starts
First screen, select "Delimited"
Second screen, uncheck all Delimiters, then check "Other" and enter | (the pipe)
Text Qualifier, select the double-quote
Third screen, specify any data formats as apropriate
Did that work?
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