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
1answer
25 views

Transpose vertically with a catch

I've been working through some issues preparing data for logstash ingestion. I have a decent chunk of the process worked out but I'm wondering if there's a better way to do this. Basically I need to ...
0
votes
1answer
40 views

Escaping double quotes in .csv

I have a .csv file which has values like Abc,3/4"×3/4" Paper,Blue,2" Abc 45 xyz 3/4"" The issue is when I open it in notepad these values become "Abc,3/4""×3/4&...
0
votes
0answers
20 views

open csv as utf8 without creating a query

I often need to open utf-8 encoded csv files in Excel (365). I open them using Power Query (get data - from text/csv) where I can specify encoding, and it's generally fine. However sometimes I need to ...
-5
votes
2answers
101 views

How to export AD user properties with PowerShell to .csv file?

I have a problem exporting AD user properties to .csv file which are members of a particular AD group. This is my code $ExportPath= "C:\Users\group_list.csv" $groupname = "group1" $...
0
votes
2answers
228 views

How to export and import directories as variables in PowerShell

First script takes input from user of a directory: eg:D:\Test1 D:\Test2 $Dir1=Read-Host -Prompt "Enter first location" |Out-file -FilePath .\directories.csv -Append $Dir2=Read-Host -...
0
votes
0answers
6 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
0answers
15 views

Automating Excel to save file as CSV and run live updates

For starters - I am raw and have limited skills, thus the guidance here is important to me. We have to supply data to a 3rd party in CSV format. The data must be updated at frequent intervals with a ...
1
vote
1answer
40 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 ...
0
votes
0answers
41 views

Fill down every (x) rows for (x) rows inserting as new rows instead of overwriting what's below in spreadsheet (WPS Office)

I have an existing CSV which contains shipping rates for every country in the world. I need to extend the rates for each country. Each country currently occupies 80 rows each. Every 80th row (the last ...
3
votes
1answer
47 views

How to trim down PowerShell output in .csv file to write only the Release ID of a Windows 10 OS?

This script work but the output to the .csv in the release id field is everything associated with the registry key. All I want in the field is the release id number (1909, 1809, 1709). How to I edit ...
0
votes
1answer
42 views

Regex on Excel or similar solution?

I have an excel sheet I need to sanitise. I have over 1000 addresses and for some random reason, the data sent over by the supplier has random 16 digits at the start of the street address Not all of ...
0
votes
1answer
85 views

Using NPP, is there a method to numerically sort values separated by commas (single column)?

I have a large JSON csv file of values (one column). In order to remove duplicates, I need to first Replace All CRs then use TextFX Sort Lines function, then Replace All the CRs with commas (such that ...
0
votes
1answer
35 views

How to streamline and standardize the specification of column data types for reading/writing CSV files with Excel?

In the company where I work, a persistent source of headaches is the fact that Excel interprets some text values in CSV files as numeric or as date. It takes more vigilance and foresight than our ...
0
votes
1answer
27 views

cannot replace specific characters in stream edit

sed is such a wonderful tool, but for some reason I cannot make it do what I need this time. I'm working with huge datasets in csv. Some files are delimited with ;(semi colon) and others with ,(comma) ...
0
votes
0answers
21 views

SSIS CSV output for DT_DBTIMESTAMP displays 9 digits of fractional seconds instead of 3 digits

I'm trying to output a date-time field to CSV from DB via SSIS with format (YYYY-MM-DD hh:mm:ss[.nnn] e.g 2020-08-30 09:20:12.123. On this page (https://docs.microsoft.com/en-us/sql/integration-...
0
votes
1answer
134 views

decompressing multiple bz2 files into 1 csv file

I have 16 bz2 files of bz2 format: split.csv.0.bz2 split.csv.1.bz2 split.csv.2.bz2 .... I believe this is a compressed csv file, but what makes me confused all day today is that it's splitted by 16 ...
0
votes
0answers
86 views

How to use variables in awk if condition in shell script?

When I tried to cut columns with key words from a csv file, I applied a variable from the for loop of a shell script in the awk if condition. But the if cannot recognize my string. So there's no ...
0
votes
1answer
41 views

how 2 iterate combined variable in shell script

I m new to shell script file1='/home/ashish/Desktop/wipro/NSE_F_CMN_ORDTRD_08052020_01_01.csv.gz' file2='/home/ashish/Desktop/wipro/NSE_F_CMN_ORDTRD_08052020_01_02.csv.gz' a=1 while [ $a -lt 3 ] ...
4
votes
3answers
1k views

How to import external csv/text file WITHOUT table formatting

I am using Excel that comes with Office 365. And this version of Excel does something annoying that's breaking all my macros. I want to import a CSV file into a sheet WITHOUT any table formatting and ...
1
vote
0answers
37 views

OCR a table to csv using a GUI for tesseract? [closed]

I want to OCR 20 pages of tables to CSV or similar format, using a GUI. For this purpose I installed tesseract (including tesseract-training and the applicable language package) using MacPorts. I also ...
1
vote
1answer
98 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 ...
0
votes
0answers
25 views

Trying to Easily Open CSV file with comma delimiter as Text format so excel does not manipulate data on MacOS

So I am Trying to Easily Open CSV file with comma delimiter as Text format so excel does not manipulate data on MacOS. I know of the import text method but that takes some time when you are opening ...
0
votes
0answers
13 views

How to change date format to UK (dd/mm/yyyy) from US (mm/dd/yyyy/) when exporting as CSV from SSRS

I have changed the localization of the report to en-GB. I've also changed the language on the report to GB and for the specific date field however it still exports as mm/dd/yyyy but only for CSV. If I ...
0
votes
1answer
49 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 ...
0
votes
1answer
24 views

Text based auto generation mail merge

I have a text file. I would like a simple portable app if possible which can automatically generate 176 different versions where the only difference (e.g. {%FIELD1%} is pulled from a separate file ...
0
votes
1answer
49 views

Complete Excel sheet with data from CSV

I have this .xls file: | ID | SKU | Description | etc --------------------------------- | | prod_A | Lorem ip... | etc --------------------------------- | | prod_B | Lorem ip... | etc --------...
0
votes
1answer
30 views

Excel Macro building: How do I pull .csv and .xlsx files from my downloads

I am working on a tool to help my business order products. Right now, We have a tool that pulls all of the .csv files from our downloads folder and add them to one excel work book. I am trying to ...
0
votes
0answers
12 views

Acessing and transferring files from a FTP server to my ftp server through cron file

I have a FTP Server that uses Cron to automate tasks and I would like to use it to access another ftp server, get a file that starts with 26 and have an extension .csv, transfer to my FTP I am running ...
0
votes
1answer
70 views

How do I add only new data to an Excel Data model?

I have a sheet with 1000s of rows of historical sales data, and I want to be able to export "sales month to date.csv" from my CRM package, and for those new values which have not been seen before to ...
0
votes
0answers
29 views

Excel - extract multiple instances of text “CVE” from data dump where CVE appears multiple times

I am looking to use Excel to extract multiple instances of text "CVE" from data dump where CVE appears multiple times. This dump is in one csv where each cell could have 1-10 instances of CVE followed ...
0
votes
1answer
117 views

Convert csv-like file (with custom separators) to ods, odf, xls, or xlsx

I have a csv-like file with complicated data and would like to open it in LibreOffice Calc, Microsoft Excel, or another spreadsheet program. What I mean by csv-like: Fields are separated by the ...
0
votes
0answers
6 views

Kibana - Adding data to an Index by file upload

I'm discovering Elastic Suite. I've worked previously with Kibana only using Visualization. Today I'm looking to do something different. I have some CSV from a tool, I have 1 CSV per month to get some ...
0
votes
1answer
304 views

Change date format in PowerShell Export SQL to CSV script

I have a PowerShell script which exports several tables at once. The script works as a charm, but only i can't change the date formatting of the dates. A few fields concern dates as defined in SQL, ...
0
votes
1answer
24 views

Replacing certain values with function in Notepad++

My .csv file contains a lot of the following: "123",bpm The value is changing, so it's not always 123, but it's always three digits. I would like to change all of these three digit values with 10 ...
0
votes
0answers
59 views

How export WireShark Packet List and Packet Bytes to txt file or csv file?

how export WireShark csv file or txt file Packet List and Packet Bytes i want txt file or csv file to export in the following way no Time Source DesTination Protocol Length Source ...
0
votes
1answer
198 views

Extract specific values from xml format to a comma separated value format (csv) with Notepad++

I need to extract specific values from XML format to a comma-separated value format (CSV) with Notepad++ The XML source file looks like:source file GRID id="301019" x="**328.217224**" y="**543....
0
votes
0answers
1k views

Add specific text to each line of output into a .csv file via PowerShell

I'm exporting members of multiple AD distribution groups into .csv files. Currently the output is one column with the first row being "name" and the remaining rows are the users' names. Here's my ...
0
votes
2answers
41 views

File extension and Internet media type for a non-standard file format

For CSV(Comma-separated values) the file extension is .csv and the Internet media type is text/csv . For TSV(Tab-separated values) the file extension is .tsv/.tab and the Internet media type is text/...
0
votes
0answers
24 views

How can I automatically delete rows containing a certain value in the first cell of that row?

I have been assigned the task to edit a very large .csv file. When I open the file in Excel, it looks like this: Excel view There are about 10,000 rows like this. Separately, I have a list of IDs ...
0
votes
1answer
94 views

copying header from a csv file into a new csv file

I have a script of my own and I don't know how to copy a header from a csv file into another csv file. Thanks in advance!
0
votes
0answers
771 views

I am trying to convert a CSV file to ANSI format with Textedit on Mac OS High Sierra version 10.13

I have to provide CSV files with Energy Manager consumption data to an Energy Management System (EMS) and I am working on a Mac with OS High Sierra Version 10.13. I work with LibreOffice and with the ...
0
votes
1answer
224 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. ...
0
votes
0answers
31 views

Sorting data in excel

I'm looking for a way to more quickly input data into excel. I have a CSV file with information obtained from evaluations we receive for events, that include ratings (very satisfied etc) and sections ...
1
vote
1answer
105 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
1answer
70 views

Automatic folder creation using Terminal

I am trying to sort files on my NAS using the Terminal from Mac OSX. I am planning on using the following steps: create folder for specific year create folder for each month use the "Find" command to ...
0
votes
0answers
53 views

Is there a way to search a txt file for a list of values?

I have a big txt file and a list of comma separated values. Is there a way to search the text file and show me which values were not found inside the text file?
0
votes
0answers
12 views

Can't run PyPi readability package from terminal

I want to use the following PyPI Package on macOS Catalina: https://pypi.org/project/readability/ What the Package does: Analyses .txt files you have in a certain directory and then gives you a .csv ...
1
vote
1answer
42 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,$&...
0
votes
2answers
70 views

Microsoft Excel: Wrong interpretation for number with CSV in a cell

I have a CSV file with some CSV value in a cell as below. 2048,4,0,0,4,"1334,1335,1338,1339" When I open it with Excel, it shows . How can I let the Excel display the number as 1334,1335,1338,...
0
votes
0answers
145 views

generate pipe delimited csv file office 365 Mac OS excel 16.33

Greeting Dear community, We have a xlsx file that we need to generate a pipe de-limited csv file. We use the default option and the delimitor is , and the text field is quoted with " However, ...

1
2 3 4 5
18