Comma-separated values are a widely-supported and easy-to-parse rudimentary plain-text spreadsheet which is commonly used for exchanging data between programs. In general, data is separated by a delimiter (comma, pipe |, semi-colon ;, etc..) that will trigger a break in the data by the application ...
0
votes
0answers
7 views
Conversion of GRIB and NetCDF to my database
image: http://i.imgur.com/lgV9A.png (my first question, so I can't atach it yet)
I have downloaded "High Resolution Initial Conditions" climate forecast data for one day, it was in extension .tar.gz ...
0
votes
0answers
46 views
Linux replace ^M$ with $ in csv
I'm working on migrating from MDaemon to Google Apps. As part of this process I'm exporting the contacts and calendars for all of our users into CSV files then reading them into a perl script and ...
1
vote
2answers
93 views
Is there a way to do an inner join in Excel between 2 csv files?
This seems like a simple concept, yet I can't figure out a way to do it without writing some code. Does Excel have a function that will let me join columns from 2 different csv files (say Orders and ...
0
votes
2answers
19 views
Excel changes numbers from CSV
Suppose I have a following string in a .csv file which I am trying to open in Excel 2010:
1073741824;1073741824;1073751824;1073741832;1152921513196781569
However, when I actually open it, the value ...
1
vote
2answers
99 views
Notepad++ replace doesn't work for Regular Expression
EDIT
Proof that it should work: http://regexr.com?30pf2
I'm trying to replace all occurrences of , that are not within quotes with a ~
20,72275,Epidurography,1
21,72285,X-Ray C/T Spine Disk,1
...
1
vote
2answers
30 views
CSV to map/card
I have a CSV file with 500 users in it, adresses and age etc.
I would love to have some graphic on that, importing this csv file into some sort of
map program, then display it.
I have found several ...
0
votes
1answer
46 views
Problems exporting word dashes and quotes from Excel into .csv
I'm trying to export a spreadsheet to a .csv file and when I do, it takes all of the quotes and dashes and they turn into ?'s. I realize it's trying to maintain the Microsoft standard of quotes and ...
1
vote
2answers
116 views
Easiest way to open CSV with commas in Excel
CSV files are automatically associated with Excel but when I open them, all the rows are basically in the first column, like this:
It's probably because when Excel thinks "comma-separated values", ...
0
votes
0answers
345 views
importing CSV data in Oracle (trying Apex/SQL Developer) [closed]
I am using recent versions of APEX (4.1.1) and Oracle (11.2.0.3).
I am uploading CSV data to a set of tables.
I have been trying it out and am encountering some problems which I haven’t seen before.
...
0
votes
3answers
206 views
How to export selected columns into csv file
I want to export specific number of columns from excel into .csv file. I have around 10 columns like lname, fname, phone, address, email and so on. what should i do to export certain columns like ...
1
vote
1answer
62 views
Free or Open Solution for Storing and Charting CSV data
I'm presently storing CSV files, combining them, opening them in open office, creating pivot tables and then generating charts from the spreadsheet.
I've looked at OOBase, but appending csv files to ...
1
vote
1answer
222 views
How to control CSV import into Excel 2010
When I open CSV files in Excel 2010 I get entire rows in cells, not distributed according comma separation.
How to control this?
0
votes
0answers
67 views
MS Outlook - Export distribution lists as CSV
I tried to export my distribution lists where my contact emails in Outlook 2007 are saved but it is not working. All I get is a CSV with the headers but no contact details in it. I tried this:
1. ...
0
votes
2answers
139 views
How to export a filtered set of rows from Google Docs spreadsheet?
Is it possible, when exporting a Google Docs spreadsheet into CSV, to apply this operation only to filtered set of rows? I need to get in CSV exactly the rows which are visible on the sheet after a ...
0
votes
2answers
95 views
Open CSV file in Excel having leading dash
I have a csv file which looks like this :
Ref;Code;OtherData;
"MyRef";"-arm";"something";
I think this form is valid, isn't ?
When I open the file in Excel, the "-arm" is parsed by Excel as a ...
0
votes
1answer
37 views
CSV - Microsoft office for mac 2008 doesn't add all the commas?
Let's say I have 5 column headings and I only complete the first 2 values. I then save the file as CSV (Windows). It ends up looking like this:
ID,Product,Name,Value,Interest
1,PC
Which is no good ...
0
votes
1answer
162 views
Cyrillic export from Excel to CSV
I have an application where I upload some content in CSV format, however the main document where I have my data is an Excel document.
I use Save As » CSV in order to make a CSV file, but it is not ...
0
votes
4answers
200 views
How to write null into csv from Excel for blank fields
How do I write null for blank fields when I export a csv file from Excel 2007? Is there a feature to do that.
2
votes
2answers
200 views
Merging columns in Excel with “;” separator
I'm new here and I hope to seek for your assistance on converting data format of my excel to csv.
This is my raw data in excel in different row and cells:
A B C D E F
1 2 3 4 5 6
...
0
votes
2answers
287 views
Notepad++/Regular Expression to find line with same beginning, different ending
So, I've read a bit and found NotePad++ doesn't use "normal" regex (starting to think I'll just go back to SciTE), but here's my question:
I've got an exported list of data with some redundant data ...
1
vote
1answer
265 views
Excel: change data source with macro
I'm using a CSV file (generated by a thing party program) as an external datasource, and I'd like to change its path from a macro... How can I do that ?
Another acceptable answer to my problem would ...
1
vote
1answer
681 views
What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited)
What's the difference between - CSV (MS-Dos), CSV (Macintosh), CSV (comma delimited) file types in excel 2010? They are all listed as a save file type, but ultimately are Comma Separated Value files.
3
votes
3answers
232 views
How to export multi-line cells to CSV file
I have an XSLX file where some rows have multiple lines, for example:
test
test1
test2
When I'm trying to export (using menu "Save As") this file as CSV or Excel workbook (1997-2003), Excel ...
0
votes
2answers
112 views
How to export file from excel (or other excel like software) to .CSV
I have 2 questions
Question 1.
Why is it when I try to export to csv file from excel 2007 I get a file that has a type of "Microsoft Office Excel Comma Separated Values File (.csv)"? I choose "Csv ...
1
vote
2answers
315 views
Export to CSV From Excel
I frequently use Excel to prepare data to load into a table. I create a CSV file from it and use that file for data loading. I generally find myself creating the CSV file multiple times.
My current ...
0
votes
1answer
138 views
how to plot data from csv file?
I'm looking for a way to plot data imported from a .csv file much like the pivot chart view of an Microsoft Access table.
I'm just having problems with Microsoft Access 2010 and was wondering if ...
0
votes
1answer
117 views
Export google document as csv without quotation marks
I have a google document spreadsheet that I want to export as csv. The problem is, that some cell get their content included on quotation marks:
1,1,"I don't want quote",Mee too but I'm lucky,1
To ...
0
votes
0answers
281 views
Importing a CSV table into Libreoffice Base
I'm trying to import a large CSV table into a Libreoffice Base database. From a google search it sounds like the way to do this involves opening the CSV in calc, select all + copy, paste into Base. Is ...
1
vote
0answers
83 views
Use one csv file to delete duplicates in another one
Basically the title says it all. I have a csv list that includes one e-mail address per line (and some other stuff). I want to seek those email addresses in a different csv file (also with 1 mail ...
1
vote
1answer
173 views
Change line endings and delimiter format (permanently) when saving to CSV from Excel
I'm using Excel on Mac and it's always painful to have to reopen all exported CSVs in another text editor just to change the line endings from "CR" to "LF" and the delimiter from ";" to ","
Is ...
0
votes
1answer
125 views
User Friendly CSV to MSSQL import with column match
Hi before I reinvent the wheel I'm trying find something to allow a user to take .csv files and graphically match the columns in the database table to the columns in the csv file. I know this can be ...
2
votes
2answers
315 views
How to break a spreadsheet containing CSV into multiple columns?
I'm working on preparing data for export, and the client has put all of the data into a spreadsheet. Each field of data should be its own column. The problem is that the client erroneously put ...
0
votes
1answer
172 views
Outlook 2011 Contact Import from CSV with Notes containing new lines / cr / lf
I'm trying to import several thousand contacts into Outlook 2011 for Mac. Everything is working well except the Notes field as I cannot figure out how to get new lines / carriage returns into it.
...
0
votes
1answer
105 views
CSV error on phone number
On my website I generate a CSV file from a database of users.
When I view the CSV file in my browser all the information comes up as it was submitted by the users, but when I download the CSV file ...
1
vote
3answers
177 views
Convert ZIP code to state in OpenOffice
I'm trying to move data from two of our old systems into a new system. Problem is, somewhere along the line the 'state' column of our DB was corrupted. I have a column of ZIP codes I need to ...
0
votes
0answers
59 views
Export CRM 4.0 workflows to csv or txt
Is anyone aware of a method to export the steps of a CRM 4.0 workflow to a csv file or text document? I need to document a lot of workflows, and I'd rather not do it all by hand!
1
vote
1answer
541 views
How to import (and view correctly) Chinese UTF-8 encoded CSV file with Excel 2011 on Mac OS X
I have a CSV file which I can open and view the column with Chinese letters normally with TextMate.
However, when I try to import this file into Excel 2011, the field comes with unreadable fonts. ...
0
votes
2answers
1k views
Export CSV with values enclosed with double quotes
How do I export a CSV file where the values and fields are both enclosed in double quotes (") from Excel 2004 (Mac)?
E.g.
"Name","Telephone"
"John Doe","555-5009"
0
votes
0answers
24 views
Getting Access 2000 to output CSV with quote “only where needed”
Does anyone know how to get Access 2000 to output a comma-delimited file in this format:
Good> Cat, "John, Doe", 32, $3.44, "Denver, CO", 1234
NOT like this:
Bad> "Cat", "John, Doe", "32", ...
1
vote
1answer
183 views
Batch XLS to CSV Converter
Using Windows, I need a script to convert all the (xls) files of a directory to csv.
1
vote
2answers
89 views
How to copy lines in Excel file that contain a value from a list
Description
I have a CSV file with 6000+ lines in it. I have a list of about 300 words that each appear in only one row of the CSV file.
Problem
How do I extract only the rows that contain a word ...
0
votes
2answers
240 views
Preventing Quotes from being used around text when exporting to TSV
In Excel, Is there an option to prevent quotes from being used on text strings when you export a sheet to TSV?
2
votes
1answer
429 views
Saving to CSV file always adds quotation marks in OpenOffice
I'm trying to use OpenOffice Calc for editing CSV files with TAB as delimiter. No matter what I do, Calc is insisting on adding quotation marks (") to the strings. If a cell content is number only, ...
2
votes
0answers
190 views
Can I disable Excel's warning when saving CSV files?
Excel always says
...may contain features that are not compatible with CSV
when saving CSV files. Can this be disabled, specifically in Office / Excel 2011 on Mac?
0
votes
1answer
102 views
AWK CSV stream editing, merge third columns for identical first columns when second column >= 0
I'm on Windows and have only heard of linuxes awk etc so I can only imagine that this is possible without actual scripting:
I have data like
..
162 42 A single serving
162 62 of ...
1
vote
0answers
54 views
Searching a CSV or Excel file for terms from one column of another Excel file [closed]
I have a column of data in an Excel file. I want to use it to search the contents of another CSV or Excel file and return / highlight all of the matches. How can I do that using Google Docs, Open ...
3
votes
6answers
195 views
Transform Fixed Width to CSV?
I have a whole bunch of data files with different content but identical layout. I need to convert them to CSV before importing them into a CRM application.
I usually open the tab-delimited file in ...
0
votes
0answers
35 views
Automated Emailing Application [closed]
I'm looking for a solution that will enable me to automate/schedule an email to individuals listed on a CSV file. I want to be able to embed data fields from the CSV into the message. In other words, ...
2
votes
1answer
166 views
Formatting a tab-delimited CSV/TSV to force Excel to interpret value as a string
I had a followup question to this related post -
Formatting a CSV to force Excel to interpret value as a string (not date or number)
I was wondering how does one escape text starting with " using ...
1
vote
1answer
484 views
Importing multiline cells from csv file into excel
I have a csv file (comma delimited and quoted).
When csv file is opened directly from explorer excel correctly interprets the cells that are mutliline, but it messes up the character encoding (utf-8).
...
