Comma-separated values: a rudimentary plain-text spreadsheet.
1
vote
1answer
13 views
Generate CSV/TXT file from named zone file
I am in need of generating a csv/txt file from a zone file on a named DNS server.
For examples I would like to generate a list of the hostname and IP from the zone file
From this
monkey A ...
0
votes
1answer
16 views
Having formatting problems when exporting table from phpMyAdmin
I'm having some trouble in exporting some data directly from phpMyAdmin. I'm selecting a table in phpMyAdmin, from a specific database, and then I'm exporting that table in Excel based CSV format.
...
2
votes
1answer
56 views
Any way to have Excel 2010 treat a quoted value “08540” as text not number when opening a CSV
I have a CSV with data like this:
"08540",1,"PRINCETON","NJ"
I know that it is possible to specify "Text" when using the Import Wizard and defining columns. But is there a way to tell Excel to ...
0
votes
1answer
31 views
Unintelligible result opening csv in excel
When I open a .csv file in excel this is what is showing up:
Maxtor Encryption ver 2.0.1.1.0 ³§o rkDV’)cÿA®T7B‡LôŠì£\% i¼r1 ØÕë—„×½é¿wjd ´Íâ¿…Öö?HÐ)vM!W« Va<žÒ LåRpµI©ô ...
0
votes
1answer
34 views
Using Command Prompt to create Retina Vulnerability Report CSV
I have scanned several computers on my network which have been flagged as needing certain fixes. I am able to generate reports in Retina fine using the GUI report view, however, I would like to be ...
1
vote
1answer
42 views
Database workflow advice? [closed]
I've got a product database that I need to update a couple of times a week and am looking for some advice on what workflow I should setup. I can export my database from my online store as a CSV, I ...
2
votes
2answers
37 views
Split view of a CSV in Bash
I'm trying to view large CSV files in a terminal (not huge; simply more than can be displayed in the terminal window at once).
The best solution I've currently got is this:
column -s, -t -n < ...
0
votes
0answers
37 views
How do I export to CSV without decimals using MS Access 2010?
Is there a way to export numeric data to csv file in MS Access 2010 without decimals? I am using ImportExportText in my macro. I don't see anywhere where you can specify this.
The macro is ...
1
vote
3answers
55 views
Generate an alphabetic index from a spreadsheet
I have a text file of lecture topics from my physics class that looks like this:
1/14,Galilean relativity,Einsteinian relativity,Minkowski space,Henri Poincare,,
1/16,Lorentz transformations,Velocity ...
2
votes
1answer
78 views
How can I convert a .txt file to .csv format without using Excel?
I have a .txt file consisting of very long paragraphs, with a single newline character separating each paragraph. I would like to convert this to a .csv format so that the file effectively has one ...
-3
votes
1answer
46 views
Deleting the first column of csv via batch commands [duplicate]
Is there a way to delete the first column of a csv using a batch command file? I have data in this first column but I want to get rid of it and output a new file starting at the 2nd column.
Thanks!
1
vote
0answers
86 views
Import a CSV File in a database w/ powershell jobs
I am trying to import a CSV file into a database with PowerShell but so far I have no luck.
This is my code (based on this source):
Start-job -Name 'ImportingData' `
-InitializationScript ...
0
votes
2answers
130 views
How a batch file overwrite contents of output each time?
Basically I have this batch file below, which will return the first x rows from the input .csv file parameter. However, the only issue now is that this batch file will be called several times to ...
2
votes
2answers
131 views
Excel CSV import treating quoted strings of numbers as numeric values, not strings
I've got a web application that is exporting its data to a CSV file. Here's one example row of the CSV file in question:
28,"65154",02/21/2013 00:00,"false","0316295","8316012,8315844","MALE"
...
1
vote
1answer
59 views
Adding Multiple users from .CSV via batch file
I wrote the following in a batch file
start cmd.exe /k net user test1 1qaz2wsx!QAZ@WSX /add /y
But I have to add a large number of users and passwords.
I have them all in an excel file, is there ...
1
vote
4answers
272 views
Can I use a batch file to remove blank columns in a .csv
I have nine columns in my current .csv file, however, the 2nd and 3rd columns are blank and I want to get rid of them. Is there a way to use batch commands to remove these empty columns from my .csv ...
2
votes
0answers
201 views
Import-CSV with powershell using a variable path
I am trying to import a CSV file with powershell in a database, with the path defined in a variable. But it doesn't seem to work.
$path = "C:\Users\Admin\Desktop\TestFolder\file.txt"
Import-CSV ...
0
votes
1answer
70 views
Export the first three rows of a .csv into another .csv using batch commands
I have a .csv file with a number of rows but I only want the first three rows and none of the rest. How can I use a batch file to export those top 3 rows of my .csv file into another file .csv file? I ...
0
votes
1answer
103 views
Get unique comma separated values from list of comma seperated values
I have a list of csv in a single cell, and I need to get the unique values from that list and put them in another cell. For example, in one cell I would have:
DIV-154, FOD-371, UDL-913, DIV-154
And ...
0
votes
0answers
37 views
Using excel to translate product names in a csv file
So I have a product list say in Chinese saved as .csv files along with other data (price, expiry date etc).
I import this into an excel workbook which also contains a table that has Chinese to ...
2
votes
1answer
81 views
How to display/monitor the tail of a growing CSV file in tabular format?
I am looking for a way to display an open, "live" CSV file under Windows 7. For example, I have a proprietary program running that is generating log data in CSV format. I'd like to keep an eye on what ...
3
votes
2answers
566 views
Import CSV file into Exchange Mail Contacts using powershell without duplicates
The Problem: A good number of people's info was added to my "Mail Contact" list in Exchange Management Console, but not all.
Summary: I'm attempting to add a list of several hundred people from a ...
0
votes
4answers
165 views
Editing CSV files in Ubuntu
What is a good way to edit CSV files in Ubuntu?
The files look something like this:
This,is,data,with,a,header
2,2,3,4,,
1,,3,,6,6
,5,3,5,5,6
1,2,,,,
1,2,3,4,8,6
1,,9,,5,9
-1,,3,4,5,6
1,2,0,4,5,6
...
0
votes
2answers
300 views
How to configure Windows to open CSV files directly in the browser?
How can I configure Windows and/or Internet Explorer so it opens online CSV files (files on the internet) directly in the browser without asking to download them?
I want the same behavior of TXT ...
-5
votes
1answer
100 views
How can I upload my CSV file and keep fonts and bold lettering [closed]
Every time I save my CSV file it deletes the fonts / underlines etc.
In my website I would like to have bold lettering, underlines preserved.
I'm using CSV Import PRO and all the options i have are:
...
0
votes
0answers
27 views
XML column shows #s instead of the content in Excel, even when exporting as CSV
I have a very large XML file of over 650,000 lines, and when I open it in Excel 2007, some cells (multiple line ones) are shown as a series of #s. When I double click on them the content appears, when ...
0
votes
0answers
157 views
Excel csv encoding default
Ok here's the deal
I exported a csv in UTF-16 format via PHP and open it in excel...All the encoding works perfectly.
My question is, suppose I edit this csv and then just hit save in excel and ...
1
vote
2answers
765 views
Increase size limit of data import from csv into Excel
I have a load of data in a csv file that I'm importing into Excel, most of it is fine, but one of my columns contains up to 1000 characters of data. Unfortunately, Excel has taken it upon itself to ...
2
votes
1answer
184 views
Export Office Excel table to csv using a macro
I'm using Excel Tables in Excel 2010. I would like to quickly export the contents of these tables to *.csv.
My current workflow:
1. Select table manually
2. Copy the contents into a new workbook
...
0
votes
2answers
86 views
windows text editor that allows csv/tsv data column sorting
I thought I remember reading that there is a text editor that exists for windows that allows the sorting of data, treating the csv/tsv similar to how it is treating when one sorts in excel.
Any ...
1
vote
2answers
167 views
Edit csv file with Excel without reformatting
I have some csv data file that looks like this
1,2,3
5,6,7
I open it with Excel 2010, do some change (change some value, delete a column, or anything), and then re-save the file still as csv. But ...
2
votes
1answer
58 views
Print from CSV file, row by row
I have a CSV file. I need to print this file row by row.
For example, each row contains name, surname, email, profession and so on, many columns. First row contains the column titles. I would like to ...
0
votes
3answers
304 views
Batch script to append record to csv files
I have a bunch of stock data in csv's that I am backtesting trading strategies on. The problem is that my strategy buys the open market price if a signal was found yesterday, unfortunately my data is ...
1
vote
2answers
150 views
Open a .csv file in Excel and have it update whenever .csv file changes
Hi I'm working with some web scrapping and the data on my csv files will be constantly changing. I want to open these files on Excel to view and also have it refresh whenever the csv source changes ...
0
votes
4answers
179 views
How to prevent the number increase in the excel for Autofill?
I want my column to look like
number
30/31/32/33/34
30/31/32/33/34
30/31/32/33/34
30/31/32/33/34
......
eg: The content in each cell is 30/31/32/33/34. I want to fill all of the cells in the column ...
0
votes
0answers
26 views
How to grab data from nbtscan to csv file
I am using nbtscan -s , 192.168.0.1-254 -t 20000 to return the list fo machines that I need to export to csv but it is returning a different number of columns when I use a regex in PHP echo ...
0
votes
1answer
57 views
universal text data format converter
I'm looking for a bidirectional file serialization format converter: xml, json, csv, sql table, excel, html, etc.
I've only found tools that performs unidirectional conversion from one format to ...
3
votes
1answer
127 views
Outlook 2007 export contacts including list info
I want to export all contacts in outlook 2007 for import to gmail. Many of the contacts are members of various distribution lists, but there are no info in the exported csv-file as to which ...
0
votes
2answers
60 views
Is there any way of preventing .csv files being converted into excel format
I'm trying to work with an automated testing tool which can use .csv files as its data sourse.
After saving a notepad file containing a number of fields and data seperated by commas as .csv it ...
0
votes
1answer
108 views
mongoexport csv output array values
I'm using mongoexport to export some collections into CSV files, however when I try to target fields which are members of an array I cannot get it to export correctly.
command I'm using:
...
2
votes
3answers
200 views
How to edit the header of a huge CSV file in-place?
I have several huge CSV files in which I want to swap two column names.
I do not want to modify/copy/rewrite the data.
The operation is very cheap in C: fopen the file, fgets the header, fseek or ...
2
votes
1answer
123 views
read excel sheet into jagged array
I am a programmer but recently new to both powershell and vba. I found this simple but effective command in powershell to read in a csv file and you can then immediately access "columns" by their ...
0
votes
1answer
43 views
How to clear up all commas after deleting all the data in CSV in Excel software?
I have this raw item.CSV file:
Name,Price,date
"item1",10,2012-11-21
"item1",10,2012-11-21
"item1",10,2012-11-21
I open it in Excel, it looks correct:
Then I clear all the data except the ...
2
votes
1answer
127 views
CLI program for xlxs -> csv conversion?
Is there an foss command line program that can convert between Excel (.XLXS) and Comma Separated Value (.CSV) files?
0
votes
1answer
230 views
Set row delimiter in Excel
How can I use row delimiter other than \n?
CSV fields contain \n and the row delimiter is \n\n\n\n, to separate line breaks in fields from the row delimiter.
I'm using Excel 2010, and in need to ...
1
vote
1answer
284 views
How to force Excel to treat dates in CSV as text in a macro
I have a macro that lets the user select a CSV file and then manipulates it. However, it treats cells that contain things like 1/2/12 as a date. I need to keep these strings as text, not dates.
I ...
1
vote
1answer
121 views
Manually “draw” data for chart, output to CSV
I need a service that will allow me to draw a chart line by hand and generate data points for what I drew. This might sound crazy, but I need some data (preferably in CSV output) that will only ...
2
votes
1answer
169 views
Interactive console based CSV editor
Although spreadsheet applications for editing CSV files on the console used to be one of the earliest killer applications for personal computers, only few of them and even less documentation about ...
1
vote
1answer
299 views
How to plot 3D graphs in Excel from CSV data?
I have data formatted like this in a csv file:
a, 1, 4, 6.0
a, 2, 42, 16.0
a, 5, 14, 69.3
a, 11, 4, 7.0
b, 1, 45, 6.0
b, 2, 45, 1.9
b, 9, 2, 4.4
b, 11, 4, 7.9
lines with first parameter a is one ...
0
votes
1answer
263 views
Numbers imported into Ubuntu Libreoffice calc from text or csv files are coming in as text
I working in Libreoffice 3.6.0.2 in Ubuntu. I have a text file that has some columns of text and columns of numbers. When I import them into Calc either by copying and pasting or saving as a csv and ...
