+ Reply to Thread
Results 1 to 4 of 4

How do I import a pipe delimited file with text that contains a few commas?

  1. #1
    Registered User
    Join Date
    02-09-2005
    Posts
    12

    How do I import a pipe delimited file with text that contains a few commas?

    Hi,

    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.

    Thanks!

  2. #2
    Registered User
    Join Date
    02-09-2005
    Posts
    12
    Hi,

    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.

    Thanks!
    Last edited by john928; 02-09-2005 at 10:32 PM. Reason: I have run into another problem!

  3. #3
    Registered User
    Join Date
    02-09-2005
    Posts
    12
    Can somebody please, please help me. I have been trying to figure this out for a while now.

    Thanks!

  4. #4
    Registered User
    Join Date
    02-24-2005
    Posts
    1
    I hope that this is what you are looking for:

    Open Excel
    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
    Finished.

    Did that work?
    ~T

+ 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