You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2016/04/06 20:50:23 UTC

[Issue 61891] CSV text files could not be read as Text

https://bz.apache.org/ooo/show_bug.cgi?id=61891

damjan@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|CONFIRMED                   |RESOLVED
         Resolution|---                         |NOT_AN_ISSUE
                 CC|                            |damjan@apache.org

--- Comment #3 from damjan@apache.org ---
(In reply to bhavbhuti from comment #2)
> I tried your suggestion but there is a serious problem as far as my ltd.
> knowledge goes:
> 
> This is the txt file
> 
> Comany, Address, City
> "Comp Name", "Address Lane, Address Apt", "CityName"
> 
> The mergering for address shows "Address Lane" and city shows "Address Apt"

In CSV files, you cannot have spaces between commas that separate fields and
quotes that begin quoted fields. What you are observing is valid behaviour. You
table should look like this:

Comany,Address,City
"Comp Name","Address Lane, Address Apt","CityName"


Resolving not an issue.

-- 
You are receiving this mail because:
You are the assignee for the issue.
You are on the CC list for the issue.