Ask Your Question

Importing CSV into Calc without quotes

asked 2015-05-20 18:01:55 +0100

colion gravatar image

I have .csv files that contain text, numbers, and dates. I want to import these files into LO, operate on the rows and columns and then save them as .csv files for use by another program. However, everything that I have tried results in text and dates being quoted which cannot be used by my other programs. Please advise how to do what I want.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2015-05-20 20:37:03 +0100

karolus gravatar image

at one stage in Csv-export should be an Option []set Filter-options -- check it! -- and set in next Dialog the appropriate Options

edit flag offensive delete link more

answered 2015-05-20 21:58:00 +0100

colion gravatar image

I do get "Edit Filter Options" in the Export Text File-Field Options dialog box when I enter the Save As mode. However, this only appears to offer the option of using " or ' quotation marks when the "Save cell content as shown" is unchecked as required because text and dates are quoted in Calc. I ran through the options and everything puts either " or ' or "" around text and dates. I assume like other programs LO has the ability to output an unquoted file so I must be doing something wrong and would appreciate your advising what option settings I should use.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-05-20 18:01:55 +0100

Seen: 166 times

Last updated: May 20 '15