The Stack Overflow podcast is back! Listen to an interview with our new CEO.

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
11 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
32 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
24 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 ...
-1
votes
0answers
7 views

Importing csv files using .bat file to database

Im relatively new to programming. Is there a way to make importing of .csv files to my database using .bat files and not use "load data local infile" because obviously, I can't understand how it works ...
0
votes
0answers
19 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
46 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 ...
0
votes
2answers
72 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
111 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
32 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
192 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
32 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
25 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
80 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
31 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
44 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
34 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
28 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
34 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
16 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
67 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
31 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
61 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
18 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
26 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
80 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
37 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
27 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
53 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
29 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
78 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) ...
0
votes
0answers
36 views

How can I read entries from a csv to edit an XML

I'm working on an automated sync of my ADuser. I need to edit an xml file to do so but the source of this edit would be a csv file resulting of a get-aduser I need to change the mail adress to make ...
0
votes
1answer
55 views

How do I prevent Excel from appending extra “” marks when I convert the excel file to a CSV file?

I am currently using =concatenate() to wrap all my fields in "" so that it is easier for me to parse in JavaScript after I convert the file to CSV. The problem is that the actual value in excel is "...
0
votes
0answers
20 views

Piping into csvcut

Is this valid piping into csvcut - manual does not cover this scenario: cd /home/kaku/public_html/wp-content/uploads/wpallimport/files/ && wget "https://fakeurl.com/Download?file=fdsa34" | ...
0
votes
0answers
28 views

I have a CSV file that has 3 column. Need help to format correctly via SQL SSIS Import

I have an CSV file being dropped to a file location once a day. When SSIS picks it up it's failing due to format issue since it has 3 columns and not delimited with 1 column. Can someone help me ...
0
votes
1answer
28 views

Excel 2013 showing only certain dates in a European format

I have a CSV file where all dates are in a U.S. format (dd/mm/yyyy): However, Excel shows some - but not all - of the cells in mm.dd.yyyy format: This is on a server in Germany. Does anyone know ...
1
vote
2answers
198 views

Create a CSV file with leading zeros which Excel never removes

We all know Excel's annoying behavior of removing leading zeros from imported CSV files I am a developer and I'd like to program an export feature that creates a CSV file that forces Excel to keep ...
1
vote
1answer
22 views

Certain Time Values in a .xlsx not Changing When I convert to a .csv

I am trying to convert from an Excel spreadsheet (.xlsx) file to a .csv file. The software I am using is Excel 2007. The issue I am having is I have a column of date and time values for every hour of ...
0
votes
0answers
21 views

Excel for MacOS drops decimal separators when importing csv file

I regularly work with csv files that use semicolons as the separator when I import these into Excel the decimal points are lost. The values are displayed with the decimal place in the import wizard ...
0
votes
0answers
69 views

After editing CSV file, size increases

i'm trying to edit an CSV file. The main CSV file is 2.466KB after i downloaded it. After i increased all Prices in one Collumn, and saved it as an .CSV file, the file size increased to 51,252MB. I ...
0
votes
0answers
14 views

How to export excel file to csv file without the semicolon outside the inserted values?

I have inserted values into excel file in "order_status" sheet. These values are shown in below picture: In this sheet I added data validations like: dynamic drop down list, checking if in cell is ...
0
votes
1answer
52 views

Export Excel (.xlsx) file to CSV separated with commas

I am using Microsoft Office 365 ProPlus. When I save my document as CSV, I end up with values separated with semi-colons, but I really need commas. I tried changing Windows Regional Settings to put ...
0
votes
0answers
16 views

How to create email alerts and send data to CSV file using node-red

I have been working with wireless temperature and humidity sensor. I have created nodes to send data to the node-red dashboard by using this but I want to send email alerts and create CSV file of the ...
0
votes
1answer
22 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 ...
0
votes
0answers
7 views

Export MS Outlook shared agendas into csv

I have many shared agendas in MS Outlook (2016) and I want to export them automatically (VBA code), or by hand in one single step into a csv. I already know that I can copy/paste the contents of a ...
0
votes
1answer
12 views

How do I undo a default download program to an unsupported program?

I am not tech-savy. I was trying to download bank statements via csv file to upload them to quickbooks. I couldn't open them so I chose the default option as Notepad. I then realized that I shouldn't ...
0
votes
2answers
69 views

CSV File doesn't look like a table

I have downloaded a csv file, and when I open it in excel, it looks like the image below. I would like to view the data in a table format. with each field in a separate column.
0
votes
0answers
158 views

How to import CSV file to MySQL and disable secure-file-priv (Goorm IDE)

I have googled many answers on StackExchange, but I couldn't understand (nor execute) most of the suggestions. Any help appreciated. I run into this precise problem - unable to import CSV using "LOAD ...
0
votes
0answers
120 views

Batch file to read a text file and parse into csv

My issue is a little complex I have a huge data file containing information such as this: ,{ 'test': 'Permissions: EXECUTE granted to public on sp_runwebtask', 'severity': 'High', '...
0
votes
0answers
5 views

WEKA ARFF file format atribute type

I need a little help with WEKA software - after uploading my CSV file to the arff viewer everything seems fine expect the artibute types and i cant find a way to change them. Im trying to run a little ...