Questions tagged [csv]
Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.
983
questions
0
votes
1
answer
83
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
53
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 ...
- 202
0
votes
1
answer
83
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....
- 150
0
votes
0
answers
71
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 ...
- 1
0
votes
1
answer
104
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 ...
- 101
0
votes
1
answer
123
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
35
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 ...
- 11
0
votes
1
answer
199
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
29
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 ...
- 213
0
votes
2
answers
193
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 ...
- 11
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 ...
- 21
0
votes
1
answer
63
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
198
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
2k
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) ...
- 173
0
votes
1
answer
153
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 ...
- 201
1
vote
1
answer
481
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
35
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&...
- 726
1
vote
1
answer
199
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 ...
- 315
0
votes
0
answers
350
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 ...
- 309
0
votes
1
answer
103
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
236
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,
- 421
1
vote
1
answer
99
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....
- 11
-1
votes
2
answers
144
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
179
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 ...
- 133
1
vote
1
answer
390
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 ...
- 13
0
votes
1
answer
216
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
233
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 ...
- 326
0
votes
2
answers
479
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 ...
- 35
0
votes
2
answers
64
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
962
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, ...
- 35
0
votes
1
answer
916
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 ...
- 105
1
vote
1
answer
385
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 ...
- 35
0
votes
0
answers
649
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 ...
- 13
0
votes
2
answers
718
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
0
answers
102
views
How to change default Table Style for imported data in Excel 365
I don't like this Table Style that Excel 365 uses when importing data.
Dafault Table Style
Is there any way to change it? I tried to set different Table Style as default and save both Book and Sheet ...
- 1
0
votes
2
answers
122
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
1
vote
2
answers
662
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 ...
- 13
0
votes
0
answers
48
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
1
vote
1
answer
250
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 ...
- 11
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
277
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 ...
- 101
0
votes
2
answers
134
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 -)
...
-1
votes
1
answer
75
views
Find multiple matches and place all at multiple location instance
so I have this comma delimited file that I need to import but I need to do some replacements first. A sample is as shown below;
item A,<u>1 a1</u> red<u>2 a2</u> etc,content,,,,...
- 181
0
votes
2
answers
1k
views
i downloaded a csv file, but data is not separated by commas
I downloaded a dataset from kaggle.
kaggle data:
but all the data is in one column in excel.
data in excel:
I need this data for my project. how can I get this data separated?
0
votes
1
answer
43
views
Dont want particular row to be displayed in powershell
Dont want row to be displayed.
$out= "C:\temp\DD2.html"
$css = @'
<style>
* {
font-family: Calibri, sans-serif;
padding: 10px;
margin: 0px;
text-align: left;
font-size: 20px;
...
- 27
0
votes
1
answer
430
views
What does "Affected items" mean in the threat report of Windows 10 Microsoft Defender scan?
After conducting a full scan on my Fujitsu Windows 10 laptop today (Nov. 01, 2022), I got informed of this threat: Trojan:HTML/CryptoExtortBTC.A (I do not do anything about cryptocurrency. This seems ...
- 171
6
votes
2
answers
1k
views
Bulk fix for Excel 97-2003 error "format does not match extension"
Context
I have received around 1700 97-2003 excel files with a ton of data including some text information. I am trying to read them all into Stata before I clean and run some statistical analysis. ...
- 63
0
votes
1
answer
177
views
running 2 excel versions at once, cant associate filetype to older version
I have excel 07 and the latest Excel 365 (I think thats Excel 16) both installed in windows 10. When I just had 07, I had no problem associating csv and xlsx files with that program. Now that I have ...
- 1,109
0
votes
1
answer
221
views
Notepad row count inconsistent before and after enabling *and then* un-enabling word wrap
I have a CSV file that contains 10,001 rows (10,000 rows of data and one row for the headers).
When opening it in Notepad, scrolling to the very bottom, and clicking on the last row, I get "3659&...
0
votes
1
answer
41
views
How to make comma elements in Excel sheet be in their own row, with identical data for other columns
What I mean is,
turn this:
| ID || Names |
| 1 ||A, B, C|
| 2 ||A, D, F|
into this:
| ID || Name |
| 1 ||A|
| 1 ||B|
| 1 ||C|
| 2 ||A|
| 2 ||D|
| 2 ||F|
The data I'm trying to transform has ...
