Questions tagged [csv]
Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.
991
questions
0
votes
0
answers
16
views
Importing CSV into Excel via Data -> From Text/CSV: Can I automatically apply the Power Query column formats?
Microsoft® Excel® for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20124) 64-bit
I have an external program that creates CSVs. Some of the columns have eg. $ or %. The import query is smart ...
0
votes
3
answers
65
views
Replace X linebreaks with comma and delete every Nth linebreak
I have records in a text file formatted in the following way:
Record1
Record1
Record1
Record1
Record2
Record2
Record2
Record2
...
I need to convert this file to CSV by replacing the first 3 line ...
0
votes
0
answers
56
views
How do I save the date formatting on a CSV file please
Hi I have several date fields created in an Excel file with the formatting of yyyy-dd-mm and yyyy-dd-mm hh:mm. I need to save as a CSV file but lose the formatting when re-opening the file. Any ...
-1
votes
0
answers
22
views
How to force Excel to export data to CSV with all cells quoted? [duplicate]
Are there options in MS Excel to use single or double quotes for every cell exported to a CSV?
This is an issue for anyone exporting CSV files from excel, but there does not appear to be an option to ...
0
votes
1
answer
47
views
How to speedup video with FFmpeg based on timestamps from CSV?
There are already questions with regard to speeding up a video with FFmpeg, like this one.
My question is: Is there also a way to specify multiple sections which shall be speedup via an external CSV.
...
0
votes
2
answers
247
views
How to set MS-Excel as default program to a .csv file in Windows 11 pro?
I am not able to set MS-Excel as default program for a .csv file in Windows 11 pro. I have tried many ways, but not able to do it.
I have to either choose "open with" option or first open MS-...
-1
votes
1
answer
35
views
What is causing the xcopy file from having an error in it?
I am new to xcopy. I am trying to move a file that is in excel format to a new destination and as a csv file. I have to do this so that the DMExpress ETL job can move the file and then read it. This ...
4
votes
2
answers
834
views
How do I keep values the same when converting from XLSX to CSV? Export to CSV with expanded numbers and not scientific notation?
I have an XLSX file which I am opening with Excel 2016.
This file includes a column "Code" which contains barcode values. The column has a number format of General.
Looking at this column, ...
0
votes
0
answers
29
views
Excel exporting to CSV. Can I use another character than " to enclose text? [duplicate]
(there is a similar question in How to avoid double quotes when saving Excel file as Unicode?, but the case described below has an issue with single doublequotes. Usually used for inch values like 3&...
0
votes
1
answer
90
views
Windows batch filename generator not running where am I going wrong?
I'm writing a windows batch script to take a .csv as input read data in each row as variables and output unique filenames to a new .csv in Windows batch script. I'm doing this to create an inventory ...
0
votes
1
answer
196
views
Can I make an excel template that will save as CSV automatically?
I want to make an excel template xltx that will automatically save the resulting workbook as a .csv.
Open template -> blank workbook (and template data) -> Save ->
CSV format already set.
I ...
0
votes
1
answer
414
views
Value in CSV file limited to 9 decimal places
I am facing an issue which I believe is being caused by an OS or regional setting, but not sure since I can't seem to fix the issue.
I have two identical .csv files both created on different computers....
0
votes
0
answers
144
views
Managing utf8 CSV on Mac
I use Excel on macOS and when I try to combine CSV files downloaded from SaaS platforms, it messes things up on the first lines. I don't have this problem when using Excel with Windows.
For now, I ...
0
votes
1
answer
129
views
Can libreoffice differentiate between .txt and .csv files?
Can libreoffice differentiate between .txt and .csv files?
I have two file's that have a mime type of 'plain text document' text/plain detected.
One file ends in .txt and the other ends in .csv.
Is it ...
0
votes
1
answer
519
views
Removing duplicate rows in a CSV file as compared to another CSV file
I have a CSV file named CSV1 with over 5000 rows and 3 columns - last name, first name and email address. I have another file named CSV2 with about 2700 rows with the same 3 columns. I have to remove ...
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 ...
0
votes
1
answer
409
views
Checking multiple .csv file exist or not from folder
We have a requirement needed to be checked and ensure multiple files start with number(s) in their name with .csv files in a folder. If yes then will proceed with further steps. If any of the files ...
0
votes
0
answers
39
views
How to create a static website from MBOX file
I have a large MBOX file (16000 emails) from a public email group which is now closed. For archival and research purposes, I would like to serve these emails on a website. How can I go about ...
0
votes
2
answers
360
views
Exporting same format to CSV
The command below I took straight from Microsoft's website. It works and produces results like this:
Name, PasswordLastSet, and LastLogonStamp.
Now, I need to know what I have to put in to export ...
0
votes
0
answers
58
views
Concatenating of the strings of the each paragraph
Is there way concatenate the strings of the each paragraph in one line? For example, I have many the same paragraphs with the space between them, it looks like:
Is there way to put each such ...
0
votes
1
answer
77
views
Why do Ratios not carry over from Xlsx to CSV format
I have an XLSX file that we have output from SAS. The column in question are results from an assay that result in a titer ratio, "NEG" or "Not Assessed". In the XLSX file the ...
0
votes
1
answer
447
views
Change encoding to Unicode in .csv exported from Gmail
I'd like to copy the typed-in addresses from Gmail to Outlook 2021 (Windows 10).
To do this, I'm using the Google Contacts Export to Outlook CSV function and nk2edit.
The problem is that the special ...
0
votes
1
answer
3k
views
How to export Get-ADUser results to CSV without quotes and with additional blank fields?
I'm trying to export some data from our Active Directory to a .csv file. The file needs to have certain columns (because the tool which will import the .csv file is very strict and I cannot alter it) ...
0
votes
1
answer
337
views
Convert (part of) XML data back to tabular data or CSV/tab separated without using scripting
Is there an easy way to convert (part of) XML data back to tabular data, so comma separated values or tab separated or Excel? I sometimes get XML log files, and for clarity and comparing it more ...
1
vote
1
answer
832
views
How to create a line break in Anki when importing from a csv file?
While creating a deck for Anki using the import functionality from csv, I've run into an issue getting the line breaks to function properly.
Here is the situation:
This is for the front card
It is ...
0
votes
0
answers
38
views
How can I extract two or three "parallel" XPaths on a web page to/in a format that can be imported into a spreadsheet?
How can I extract two or three "parallel" XPaths on a web page to/in a format that can be imported into a spreadsheet?
Here is an example: on https://www.amazon.co.uk/s?rh=n%3A20606777031&...
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
0
answers
567
views
How to convert list of SBOMs to one CSV file?
I have the ability to create multiple SBOMs for many projects in Synopsys Black Duck Hub. They can be in the SPDX or CycloneDX SBOM standards in a JSON, YAML, RDF, or tag:value formats.
Is there a ...
0
votes
1
answer
132
views
Powershell script GPO USER LOGON not working WINDOWS SERVER 2019
I created Powershell script to collect mac address and pc name for all my domain users ..
Script run correctly on local machine .. but not working via GP
$wmifilter = 'PhysicalAdapter=True AND ...
0
votes
1
answer
405
views
Need to Split 5M Lines Text File into separate CSV files
I want to create CSV file from every 1048574 lines from a large CSV file which as 5M lines.
I want to use something like Notepad++ to divide it out into different files. How can I do that ?
Thanks,
1
vote
1
answer
115
views
Failure to convert JSON to CSV file
I need to extract a particular anti-virus product scan results from a JSON file and list the elements in csv format for further processing. JSON file sample as below:
Contents of a file scanresults....
-1
votes
2
answers
190
views
In csv file search concern number for particular text in second column
I have main two csv files as follows:
file1.csv
731,dev-servers.com.,A,192.168.0.10
598,test-servers.com.,A,192.168.0.12
599,test1-servers.com.,A,192.168.0.11
file2.csv
dev-servers.com.,A,192.168.0....
0
votes
1
answer
350
views
Why can't I type a single quote at the beginning of a cell in LibreOffice Calc when editing a CSV file?
When editing a CSV file in LibreOffice Calc, I have found that it is not possible to type a single quote at the beginning of a cell for both numbers and strings. When attempting to do so, the quote is ...
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 ...
0
votes
1
answer
299
views
Download CSV file with todays date from Outlook inbox and save it to a folder using powershell. My code doesnt seem to be working
I am trying to write a powershell script to download a csv emailed daily save it to a folder, and then process it using powershell/excel. I have already written the powershell to open up the file and ...
0
votes
1
answer
357
views
Column sort is not putting numbers in the correct order
I am uploading a .csv file into a third-party program with the following data for example:
When the (third party) program sorts this data by the 'Number' column it looks like it is sorting the column ...
0
votes
2
answers
643
views
Use PCRE2 Regex to group phrase before colon AND group comma separated values
I have what seems to be a simple task but isn't working for me. Using only PCRE2 Regex (nothing else), I am trying to collect a phrase before the first colon at the beginning of a line, then separate ...
0
votes
2
answers
69
views
Misleading data format Excel .csv
I am generating a .csv file with data like the example below:
TIME,LUX
18:00:00,30
18:00:01,30
18:00:02,30
18:00:03,30
18:00:04,30
18:00:05,30
18:00:06,30
18:00:07,30
18:00:08,30
18:00:09,30
18:00:10,...
2
votes
1
answer
1k
views
Use REGEX only to group multiple key value pairs on line with anchoring text?
TL;DR: How can I grab a series of key:value pairs that are comma separated, but only if they start with specific strings?
Hello,
I have a situation where I have a block of text with multiple lines, ...
0
votes
1
answer
1k
views
Awk exact string match in a specific column only returns header row
I have a 6-7M row CSV file that end users wish to review with Excel or Numbers. Each user only needs to review a subset of the file, so I was hoping to offer an awk one-liner that they can use until ...
1
vote
1
answer
499
views
Using REGEX only, copy last (delimited) word to every comma separated value?
I have a series of lines with arbitrary number of comma separated values, and then a hash marked comment. The challenge is, using only PCRE2 regex for use in PERL, to do the following:
Store the ...
0
votes
0
answers
789
views
How to import multiple csv-files in Excel at once with VBA
I am trying to import multiple csv-files within the same directory into my Excel sheet using VBA. The following code is working very well with just one csv-file. But I lack the knowledge to adapt my ...
0
votes
2
answers
861
views
Remove comma and next 3 characters from line with sed
I'm writing a shell script to send fail2ban logs to a postgres database.
The event timestamps in the application log annoyingly shows the milliseconds of the event separated with a comma (like this: ...
0
votes
2
answers
158
views
I have two cells each with comma delimited values, I want to combine these into one cell
I have two excel cells(A1 and B1) each contains comma delimited values in, I want to combine these values into one cell (C1), so that the first value from cell A1 is "linked" to the first ...
1
vote
2
answers
846
views
Add header efficiently to a large CSV file using PowerShell
I need to add headers to a large CSV file (900+MB) but PowerShell stalls for 3 hours+ on my system and sometimes even crashes.
Question: Is there a way to stream the data through instead of loading ...
0
votes
0
answers
53
views
Adobe form import
I am trying to import data from a tsv into my Adobe form. I am having trouble importing my "Representative" field. Any ideas?
Below is a link to the examples of the files I am working with.
...
1
vote
1
answer
641
views
Excel - CSV file formats Date column in different ways
I am working on creating a personal finance dashboard and therefore integrating different CSV files downloaded from different sources into one big table.
The problem I am facing is that the date ...
0
votes
2
answers
2k
views
Using CSV as source to copy files
I have a CSV file (semicolon-separated, actually) in Windows,
with column header info.
One of the columns contains a partial filename;
it's a filename without path or extension.
I've been trying to ...
0
votes
1
answer
372
views
Strange characters inserted by Libreoffice when opening a .csv file and then saving it (on Linux)
Here is what I did:
touch file.csv
Open this file in Libreoffice.
Pasted a tabular text from the internet.
Saved it in Libreoffice in Text csv format.
When I do the above, Libreoffice inserts 2 ...
-1
votes
2
answers
179
views
MS excel not coping data in correct format from csv file
I am coping data from csv file
it contains tables
in that table there is column name PostedDate
when i copy that PostedDate column in excel it shows wrong formatting (ie instead of / it shows -)
...