Questions tagged [csv]
Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.
991
questions
1
vote
2
answers
14k
views
What should I do with the newlines in this CSV file so it will import properly into a database or spreadsheet?
I have a .csv file which was exported from a proprietary electronic health records database system. I was a subscriber to their service but upon ending my subscription this is how I get to keep my ...
1
vote
1
answer
740
views
Display-only Column Formatting in Vim for Character-Separated Value Files
I would like to be able to nondestructively align columns when I am editing csv files in vim.
I know of various ways to tabularize/align columned data in vim, but they all modify the file itself ...
1
vote
2
answers
723
views
Unix copy multiple folders based on a specified CSV list using rsync
I have done some research and it appears that rsync is the only method that can possibly help me achieve this. I want to specify a list of folders in a CSV which can tell rsync to copy them to ...
1
vote
3
answers
19k
views
d/m/yyyy to dd/mm/yyyy
I want to change the data such as 9/4/2012(some cells with, green arrow in the right corner. ) into dd/mm/yyyy.
I want to standardize all the data of such column into dd/mm/yyyy , I format the ...
1
vote
2
answers
26k
views
excel: merging to data sets based on a common field
I have two excel .csv files that have a single numerical field in common, FIELD_A.
What I'd like to be able to do is to leverage this common field in order to merge data between the two, so that I ...
1
vote
2
answers
3k
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
2
answers
868
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 ...
1
vote
3
answers
7k
views
OpenOffice ruined my CSV file - (how to save CSV on Linux with OpenOffice?)
I am running OpenOffice 3.2 on Ubuntu.
I had a CSV (comma separated value) file which I had manually created. I opened it in OpenOffice, and entered about 100 items (to make use of using formulas to ...
1
vote
2
answers
835
views
Software to convert an EPS file to a vector format?
I've got an EPS file (provided by Ordinance Survey) which I'd like to convert into a vector file (2D points) for processing by another software application. I'm not fussed what final format it takes, ...
1
vote
4
answers
719
views
XY Diagram/Data Browser for mid-sized CSV files
I have a set of CSV files with about a 100k records in them. The records need to be visualized in an x-y diagram.
Specifically, I'm looking for:
Seamless zooming in and out of the data
Navigation ...
1
vote
1
answer
92
views
regex for searching a word in a word
i have a csv file which i need to filter mails marked with the word 'spam'
lines look like this
email;text;somestatus;mailserver status response; response message
[email protected];mx.mail.com;2;...
1
vote
1
answer
39
views
How do I use an API to extract to CSV? [closed]
Sorry, I've tried reading up on it but I just don't understand any of it.
There is an organisation, ALISS.org, which has a section with their API that lets you interact with their database of local ...
1
vote
1
answer
368
views
How to tell Excel to change right encoding in opened file?
Can somebody tell me please how to tell Excel to set up right encoding for csv file? It seems it is not possible without any annoying steps. I would like to see something like Libre office or Open ...
1
vote
1
answer
696
views
Excel: How to search for values from a column within a cell that has comma seperated values
I have one column with text in seperate rows, and a cell that has comma seperated values within the singular cell, as below.
One
Two
AB
AB, EF
CD
...
I'd like a formula to return True if any text ...
1
vote
1
answer
70
views
data recovery empty csv file created by arduino
Last week we launched a rocket, in which an Arduino saved the data of the sensor in a csv file. Every 30s the programme used myFile.close() and a new file was created.
But even if the chute deployed, ...
1
vote
2
answers
2k
views
How do you open/import a CSV file with Unicode characters encoded as numeric character references?
In Excel, I tried to import (using Data > Import) a CSV file with Chinese characters. The characters are represented as Unicode numeric character references (NCR); for example 香&#...
1
vote
1
answer
4k
views
Open UTF-8 csv files by double-clicking in Excel
I want to open UTF-8 coded csv- or text-files directly in Excel 2016 or later.
Of course I am aware of the import option, but I want to do this with a simple double-click.
Problem is that this way ...
1
vote
1
answer
948
views
How to save filtered results in Procmon to a .csv file?
I have included the entire script below. It works without this added piece at line 16. If I remove the added code at line 16, the script will complete but does not save the filtered information.
/...
1
vote
1
answer
2k
views
Make a copy of an Excel file as a CSV without having Excel "re-open" the file as a CSV
I have several dozen Microsoft Excel files in xlsx format. These files are the "master" copy for editing and include various formatting to make them easier to edit.
However, the data from ...
1
vote
1
answer
998
views
Splitting files in Mac and then adding .csv extension removed them?
I have been following the methods from this YouTube video.
Method:
cd /Volumes/Seagate/Work/Tickets/Thirdticket/Extinction/species_all.df
split -b 10000m species_all.csv
for i in *; do mv "$i&...
1
vote
1
answer
715
views
Csv file - User permission needs to be created after each save
For context, I'm uploading a csv file to a Postgres database via the psql command line. The cmd can only access the file after I add Everyone to its permissions and allow full control.
The weird thing ...
1
vote
2
answers
537
views
Opening csv file with notepad with two different desktop running both windows gives different results
Opening csv file with notepad with two different desktop running both windows gives different results
One of the desktop when opened, it's kind of lined nicely with newline, but somehow the other one ...
1
vote
1
answer
807
views
How to rearrange columns when you don't know their initial positions (UNIX, BASH)
I'm having an issue to rearrange columns of a csv file (separator ";").
I know where the columns should be, but not where they are in the first place.
Example of file:
first_name ; age ; ...
1
vote
2
answers
596
views
Does Tableau Public support live connections?
Are live connections available in Tableau Public? I have seen a "Live connection" checkbox in a few tutorials, but it is missing from Tableau Public 2020.3.1 - is it missing from the Public ...
1
vote
1
answer
1k
views
Import emails from Outlook to Gmail
I have emails in my desktop Outlook and want to transfer them in Gmail (G Suite if it matters).
I exported a folder in a CSV file, however, cannot find a way to import them in Gmail. The solutions I ...
1
vote
1
answer
8k
views
How can I escape commas in a CSV file?
I thought there were two ways to do this: either enclose the field containing the comma in quotes, or place a backslash before the comma. However neither of these is working; when I load up the CSV ...
1
vote
1
answer
156
views
Merge CSV Files Error 1004
So I am trying to make a macro that will merge multiple .csv files into one excel worksheet. I used the following tutorial for it:
vba code
However, once I put in the correct path to the .csv files, I ...
1
vote
1
answer
3k
views
How to retain date format from raw csv file as is when opened via MS-office Excel?
I have data given to us via email/hard drive which has randomized future dates (ex: 21/02/2200) in multiple formats.
During data transfer 1st mail, the file sent has date format in DD/MM/YYYY.
...
1
vote
1
answer
464
views
Excel and Google Sheets calculate different .csv column totals to MySQL and LibreOffice
I have a .csv file with 9273 rows.
I have one column of whole numbers and one column of decimal numbers with values like 0.0001752.
I totalled these columns using Excel's sum function and got totals ...
1
vote
1
answer
67
views
Can I get this Perl command on Windows to not generate dates with apostrophes in LibreOffice?
Based on the help I got on this question, I have this Perl command that I run in Windows 10 PowerShell:
ls |% { $_.Name } | perl -pe 's/(.)(.*)_(\d{4})(\d{2})(\d{2})_(\d+).jpg/\u$1$2,$3-$4-$5,$6,$&...
1
vote
1
answer
2k
views
Return a row if a column has a partial or perfect match with CSV in Powershell
Basically, I want to search for a string and return any full or partial matches in a CSV format.
Let's say I have an object $Shoes that looks like:
"Brand","Style","Color","Price"
"Reebok","...
1
vote
3
answers
344
views
How to make in CSV First and Last name in one
I have one CSV that looks like this:
Versand Vorname;Versand-Nachname;Versand-Zusatz;Versand-Firma;Versand
Thomas ;Lellig ; ; ;Brunnenstrasse
I want to ...
1
vote
1
answer
359
views
Excel is adding = in front of cells containing @ mark when importing from CSV
I'm not sure why, but since a few days ago when I import a .csv it is adding a "=" infront of cells which begin with an @.
It should be like this:
But now it is doing this:
I've compared all ...
1
vote
1
answer
571
views
Windows CMD sort retaining header?
Need to sort in Windows a large CSV-like file with a header row (~7 million rows). Can successfully do this with a CMD command sort, but it includes the header row in the sort. I would like to keep it ...
1
vote
1
answer
254
views
Replacing Date Format in multiple Columns
I am trying to edit a CSV file in Notepad++.
I have about 500 lines of dates in a format that I need to change to a different format, so basically, in the CSV file in Notepad, the dates are shown as ...
1
vote
3
answers
3k
views
Display multiple CSV columns that have space on one line
I have a CSV file with first and last names. The headers are "First Name" and "Last Name". I can get it to display, but it puts the first and last name on separate lines.
Question: How can I get the ...
1
vote
1
answer
325
views
FFMPEG Split Mp3 using CSV in Shell, parsing doesn't seem to work
Task: Split one mp3-files to several mp3-files, use a CSV-File with Starttime, Endtime, and Title.
Errors: Skipped Parts, some parts with wrong naming, randomly accruing errors:
Invalid duration ...
1
vote
1
answer
523
views
OpenOffice Calc import special characters in CSV incorrrectly?
I'm trying to import a CSV file to OpenOffice Calc, but the program is reading special characters incorrectly.
For example, one of the fields in the CSV is "Puma La Cerámica", but Calc imports it ...
1
vote
3
answers
4k
views
How can I convert multiple XML files in CSV automatically [closed]
I have about one hundred of XML file (with the same structure) and I want to import them in SAS. Unfortunately in doing that I have some issues relatated to the MAP file of the XML files (I have not ...
1
vote
1
answer
4k
views
Excel removes blank lines when saving in csv format
I have an Excel file with blank lines at the start. When I save as a CSV file from within Excel, the blank lines are being removed from the saved CSV file, but the Excel view of the file, i.e. ...
1
vote
2
answers
3k
views
How to join/merge 2 worksheet tables from time-series in Excel?
How do you join two datasets in excel from time-series, but the observations have been made at different times. How would you combine the observations in one table with the second?
Example:
table 1:
...
1
vote
2
answers
1k
views
How do I copy specific selected data between cells in a CSV file in Excel or Notepad++?
I have to download media file databases on a daily basis and modify metadata from a csv file so that the unique numerical prefix in column B is added as a suffix to the cells in column C.
Is there a ...
1
vote
2
answers
3k
views
Trying to export single column's data from large CSV file
Problem: I am trying to export a single column of a .CSV file that is 7 gigs in size (large enough that I can't open the entire file in excel... or most text editors for that matter) to a smaller file ...
1
vote
1
answer
1k
views
Import from tab delimited text file in Excel - CR character in quote marks is ignored
I have a large TXT file delimited with TAB.
Text is enclosed with quotation marks, but Excel still breaks the values into two rows when a CR character appears within the encapsulated string.
Is there ...
1
vote
1
answer
497
views
.csv file from Excel vs .csv file from Libre Office
I created a simple .csv file with Excel which looks like this:
I also created the same .csv file by using Libre Office.
Both .csv files are looking absolutely the same at TextEdit:
id, questions
1,...
1
vote
1
answer
2k
views
Find a string at the beginning of all lines in a file and save to another file
I have tried quite a few options with no luck for this task. I would really like to do this as batch file but my attempts fail to get the desired result.
I have tried a lot of different commands with ...
1
vote
2
answers
2k
views
Read CSV for variable and check the cells on that line for another variable
I am trying to create a batch file to read a CSV file to find a username that will be a variable then check the next 10 cells on that line if they match another variable which will be a number.
...
1
vote
1
answer
238
views
Parsing errors due to special characters in dns txt records
I have trouble parsing dns txt records retrieved by a script I wrote. The script takes a records, ns records and txt records and writes them to a .csv file. I am using semicolon to separate entries ...
1
vote
1
answer
152
views
Excel- combining multiple CSVs into one
Excel 2016 on Windows 10:
I have 120 CSV documents each containing 10 columns of text data (A-J). None of the CSVs have any column headings- Row 1 contains the first row of data rather than headings.
...
1
vote
3
answers
2k
views
Where does the @{ } come from in this foreach loop?
I'm building a script to take a IP addresses from a CSV and then attempt to ping/connect to them. Eventually I will run some commands against them and output all of it as extra data in the CSV. ...