gettingstarted
[Top] [All Lists]

Re: text

To: Getting Started <gettingstarted at lists dot realsoftware dot com>
Subject: Re: text
From: Norman Palardy <npalardy at great-white-software dot com>
Date: Thu, 28 Sep 2006 10:43:57 -0600
Delivered-to: listarchive at realsoftware dot com
Delivered-to: gettingstarted at lists dot realsoftware dot com
References: <be5 dot 498ad58 dot 324d5496 at aol dot com>

On Sep 28, 2006, at 10:38 AM, GAmoore at aol dot com wrote:

There is probably a simple answer for this, but I am importing a tab
delimitted text file into my program. It reads things items in the columns of the original spreadsheet as "Boston" or "3.4". But on a column where I have "Jones,
Jim", it inputs it with double quotes around it. This is what I see :


Boston     3.4     "Jones, Jim"
Chicago     4.1    "Smith, Steve"
Omaha      3.7     "Adams, Art"

Does anyone know why the double quotes appear when there is a comma? Is this the fault of Excel for somehow making different formats in the columns?

Excel does save it differently
If you open that text file with a text editor (or just double clink on it in the project) you'll see that Excel does this

_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>


<Prev in Thread] Current Thread [Next in Thread>