Questions tagged [csv]

Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.

Filter by
Sorted by
Tagged with
0
votes
0answers
12 views

Unable to apply numeric format to column in moderately large CSV file in Excel

I have a moderately sized CSV file (195,000 rows.) For some reason, when I try to format a column of numbers as currency when opening it in Excel, it does nothing at all. If I edit the file and leave ...
-2
votes
0answers
21 views

Where can I find a computer-parseable list of *last* names in the USA? [closed]

Recently, after a lot of searching around, I finally found a semi-decent source for first names in the USA. It amounts to this ZIP file of text files: https://www.ssa.gov/oact/babynames/names.zip ...
1
vote
1answer
37 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 ...
0
votes
0answers
32 views

Extracting column A of several hundred Excel tabs into one .csv file

So, I have a quite large (approx. 20 MB) .tdms file from a LabView program that got filled with consecutive tabs, each of which only has column A filled with numerical values, and a simple text in ...
-1
votes
1answer
34 views

Create multiple text files that follow a pattern

I want to create hundreds of text files that follow a pattern like this (example): The book [title] written by [author] is about [description] ... and the variables will be extracted from a csv ...
0
votes
2answers
35 views

Get unique values from a comma separated values in a cell

In excel I have a column (actually multiple columns with ~30K rows) with each cell value looking something like this 7AA914BC, 898B70FB, 898B70FB, 15DD4C5B, 15DD4C5B, 98D2185E, 898BAC48, 98D2185E, ...
0
votes
0answers
23 views

Can't replace filtered rows/constants

I have a table which has Questions (Column A) and then multiple possible answers associated with each question (Column B). This means that for most questions there are a few blank rows in Column A as ...
0
votes
2answers
73 views

Make my Excel parse dates from CSV like everyone else's

For my work, I regularly open data in Excel 365 that comes to me in a weird CSV format that I can't control. Here's an example: "Call-off","Receiver ext.","Plant","Status","Supplier ext.","UnPt","...
0
votes
0answers
9 views

How can I export all my orders as a .csv file from Amazon UK (not the US site) [migrated]

I would like to export all my orders from Amazon UK (not the Amazon.com US site) as a .csv file. I know this is possible on the US site using this: https://www.amazon.com/gp/b2b/reports Is there an ...
0
votes
1answer
27 views

Error when importing data from CSV ,“Specific argument was out of the range of valid values”

I've been getting an error when trying to import a csv file as a data source using "from text". I do this all the time but I get this specific error with a specific very large csv file. Obviously, I ...
0
votes
1answer
51 views

Changing Outlook event via importing CSV file

I add events to an Outlook calendar by importing a CSV file that is created from an Excel spreadsheet. If I change info in the spreadsheet, and re-import the CSV, how can I ensure the original entry ...
0
votes
0answers
27 views

Import/Export Named Ranges and Expressions using text-only format

I am looking for a method to export/import "Named Ranges and Expressions" from/to LibreOffice Calc using exclusively text files. I am well aware of several methods which involve moving or copying a ...
0
votes
1answer
92 views

How to use a path listed in a csv and appending to it

The csv has a column, Install_Location. I will like to use that Instanll_Location and append to it \temp I'm having trouble extracting that row of Install_Locations and adding the additional path ...
0
votes
1answer
29 views

How to set path to file location in powershell if the file is located in github. (File is a csv)

I want to run a jenkins job using a powershell located in github. Calling the powershell script is successful. Now, a script uses Import-csv. The csv has been uploaded to github. How to reference ...
1
vote
1answer
13 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 ...
0
votes
0answers
6 views

Convert CSV data to a matrix to a heatmap in R

Doing some visualizations for a paper I'm writing and am stuck in trasfering data from a CSV-loaded table to a matrix (to be able to plot a heatmap from it afterwards). I'm doing this: data <- read....
1
vote
2answers
79 views

Splitting csv file based on column value <SOLVED>

I have this large csv (semicolon separated) file that I need to split into about 300 files based on the value in second column (file has header names).The file has about + 3 million rows and headers ...
1
vote
0answers
54 views

Excel - Manual Column(s) Beside Imported Data

In excel, how do you properly mix 'manual' data and imported data in a sheet / data range? Requirement For context, my particular use case is a sort of bare-bones data "triage" tool in excel. Ideal ...
1
vote
1answer
40 views

convert sql-excel date to recognisable format

I have a large csv file(1.1G) exported from SQL Server. I would like to do data wrangling in python, but I had a few problems doing this. The original csv file dates look like this 00:07.5, 00:08.3, ...
2
votes
0answers
19 views

Import csv file in excel scrambles characters

I'm trying to import a csv file that I created myself out of a python script. I'm struggling with encoding. The csv file is encoded in utf-8 with unix style line endings. TI"m on a german macos ...
0
votes
0answers
17 views

Creating highcharts chart and updating chart

I'm trying to create a simple higharts chart from a local stored csv file on my server. I cannot use the built in data module for csv file because I need to use a relative path for the csv so I found ...
0
votes
0answers
71 views

Corruption of zipped CSV Files when transferred via FTP from vessel

I would like to describe a problem with a Windows Service application that is installed and runs in a Server (Windows Server 2016 Standard) which is located in a vessel. Its main functionality is to ...
0
votes
1answer
28 views

Importing big bunch of files to LibreOffice Base table in one shot

I have table like this: and a bunch of CSV files like this: in per-patient directories. Please note that I need to take a Patient field from path name and Date from file name (as you see). What is ...
0
votes
0answers
33 views

How to load Excel file correctly in weka?

I am using microsoft excel 2013 ,and I have an Excel file as (.xlsx ) format ,then i saved it as (.csv) format . when i load this file in weka 3.8.0 and saved it as (.Arff) , the attributes of data ...
0
votes
1answer
78 views

Why is Unicode 1200 codepage not there in excel?

I am opening a CSV file which is created with Unicode 1200 codepage but when I bring up the wizard in excel to open it, this codepage is not there. I only see UTF-7 and UTF-8. I do need to open an ...
1
vote
2answers
92 views

Record Editor Cobol To Csv

I have a problem that I'm facing with Record Editor and trying to convert COBOL data and Copybook files to CSV. I'm stuck at a point where "Generate Code for Cobol Copybook creates a preview that is ...
1
vote
3answers
125 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 ...
0
votes
1answer
85 views

How to export/update CSV file through Excel Macro?

Thanks in advance for any help! I have a file that produces an output table that also contains a unique key for the set of data. I want to be able to export this data into a CSV file. That is easy ...
2
votes
3answers
803 views

Combine multiple CSV files by column, not by row

I have ~100 CSV files that I want to combine into one single Excel spreadsheet (everything in one tab, not in separate tabs). These CSV files are identical in format: each contains 4,000 rows and 2 ...
0
votes
0answers
40 views

Pass pipe ' | ' as an argument to a shell script

I am working on a generic shell script perform certain operations on source files. I am taking the delimiter as an input from the user as a command line argument. It is working as expected for ',' ...
1
vote
2answers
28 views

filtering CSV in Powershell

I am currently compiling a list of software installed on computers. My end goal is to filter out all baseline software so I can get an accurate report of installs. I am forced to search an area of the ...
1
vote
2answers
173 views

Batch file to remove double quotes from csv

My file is tab separated file(TSV) with 5 columns I have local drive path on my first column but each image name from path contains double quotes. Path C:\Users\magoo\"flower.jpg" C:\Users\magoo\"...
0
votes
0answers
39 views

How to change a file's encoding?

I am not sure if the question is the right one for my situation, but here is what I want to do: I've downloaded a .csv file with Chinese characters in it. When opened with MS Excel, the Chinese ...
1
vote
1answer
57 views

bat file to copy column data to another column in csv

My csv file contain 6 columns and I want to copy 6th column value inside first column path value. Path,Firstname,Lastname,Name,Description,Images C:\Users\magoo\abc.jpg,alex,ross,pvs,data,123.jpg ...
0
votes
2answers
36 views

Changing the structure of csv data

I'm trying to change data looking like this: original csv into this format: name = "The V Girl"; author = "Mya Robarts"; pages = 341; imageURL = "https://i.gr-assets.com/images/S/compressed.photo....
0
votes
1answer
32 views

Powershell ConvertTo-Csv mangles objects

Say I do $d = @{"foo"="bar"; "baz"=99.9} ConvertTo-csv $d I'd expect something like foo,baz "bar",99.9 but instead I get this: #TYPE System.Collections.Hashtable "IsReadOnly","IsFixedSize","...
0
votes
1answer
38 views

Excel Tables: Imported data from CSV files in a folder are not calculated

I have a source folder with CSV files in an identical format and data structure. The files contain monthly data from our internal system with columns named "service name", "date from", "date to", "...
0
votes
0answers
28 views

Not readable greek characters when converting xlsx to csv

My system: I run a fresh Windows 10 Pro N x64 installation on my pc, with MS-Office 2013 Professional Plus 2013 version. What I want to do: I have some huge .xlsx files with greek text characters ...
1
vote
0answers
16 views

Re-use An Import-Mapping of a CSV into SQL Azure DB using SSMS

In https://stackoverflow.com/questions/12503430/import-csv-into-sql-azure-database-using-ssms/35876305#35876305 one solution was to save the import dtsx so as to reuse. However, I cannot find how to "...
0
votes
1answer
91 views

How to extract users from multiple AD

I need to extract a file containing all of my AD's. I am trying to do so with Get-ADuser. However, since the -Searchbase does not accept multiple sources,I did something like this: 'DC=AD1,DC=net'...
0
votes
0answers
91 views

How do I upload CSV files into AWS elasticsearch if I have converted all the fields into JSON?

Need to put a csv file into AWS Elasticsearch. I have converted the fields into json and can update the index using POST in dev controls on Kibana. However, I have 300 entries and cannot do each ...
1
vote
0answers
88 views

phpMyAdmin import csv into database error

I'm trying to import a csv file into a database without having defined a table in it but I got an error. I did it one week earlier but now I am not able to import the same csv file. When I import ...
0
votes
0answers
36 views

Looking for an alternative to Google Fusion Tables’ card layout

As Google is turning down Fusion Tables next December, I'm looking for alternatives for the following: What I need: A string of hyperlinks based on values in a CSV-file, preferrably automatically ...
0
votes
0answers
27 views

Force computer logon to be all lowercase

We have a 3rd party print to cloud application that uses the user's logon name to look up their corresponding token so printed items can be uploaded to the cloud instance. The product uses the case of ...
0
votes
0answers
105 views

Using the unix sed command - sed 's/[\t]\+/,/g' - need without using 'comma'

I am trying to export the query output into a .csv file. Please help as am a newbie to the SED world. mysql -h <host> -u'uname' -p'pword' -e 'SELECT * from schema.table' | sed 's/[\t]\+/,/g' &...
0
votes
0answers
53 views

Powershell - XML - Trying to figure out nodes

I am trying to figure out a little issue on my part. What I'm doing is getting the data out of an xml file and trying to parse it in a proper csv. Now, the following issue I'm having is this: ...
0
votes
0answers
34 views

Fixed column width for CSV files

I use LibreOffice (6.1.6.3) Calc to work with CSV files. Some of these files have very long text in their "cells". When I open such file in Calc, the Calc tries to make the column as wide as possible....
0
votes
0answers
78 views

How To Export Large CSV File From SAS Viya

I have a large CSV file of about 7 million observations that i want to export from SAS Viya. The problem is that SAS viya doesn't allow me to do so because it is too large. So I had to divide it into "...
0
votes
2answers
45 views

Excel Power Query Load Times - Why do dependent queries reload CSV file data?

I have a series of queries in Excel which all depend on an initial query which loads data from CSV files, processes them and loads them into a table in the worksheet. The remaining queries all use ...
0
votes
0answers
137 views

CSV exported as comma separated and decimal separator is CSV

I have a problem, where i exported some large csv files, and after some time the separator jumped back to default comma, but the problem is that the decimal separator of the software (SQL Developer) ...