Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [csv]

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

0
votes
0answers
44 views

Removing extra spaces

I'm building a web site and I've got two CSV files. One is from Loves Truck Stops, a list of all their locations, and the other CSV is for my website to display those locations on a map. I rearranged ...
-1
votes
1answer
15 views

Excel: New Powerquery from Web (csv) doesnt work

I want to build a worksheet where the user can input a Stock symbol and the balance sheet is automatically downloaded from morningstar to a table, and then some custom formulas are run on the data. ...
1
vote
1answer
26 views

Excel removes blank lines when saving in csv format

I have an Excel file with blank lines at the start. When I save as a CSV file from within Excel, the blank lines are being removed from the saved CSV file, but the Excel view of the file, i.e. ...
0
votes
0answers
10 views

How to plot a multicolumn CSV file in python using pandas and matplot? [closed]

I am very new to Python, so excuse me for a question probably stupid. I've got a multi-column CSV (plain comma-separated, no quotes) file where the first row is the header, the first column is a ...
1
vote
1answer
25 views

load csv file into mysql using batch?

I am looking for help to load a .csv file into MySQL Server using batch and I have few basic questions. Issues: 1) The CSV file data may have , (comma) in between (Ex: description), so how can I ...
0
votes
0answers
30 views

Automate clicking download CSV button on webpage and saving then importing as worksheet in current workbook

I'm trying to automate a manual process which is as follows: 1. Open webpage (https://trans-logistics.amazon.com/fmc/execution/JA3Nk--CPTs_(24_Hour_Pool)) (don't bother clicking - link only works ...
1
vote
0answers
37 views

Import and merge 2 CSV files using cmdlets in PowerShell [closed]

I am trying to import and merge columns from 2 CSV file into one using Powershell. Please look at my code and advise. I think that it is right, but I am not sure about referencing different columns ...
0
votes
0answers
30 views

Change AD Computer Description via CSV and Powershell

I'm fairly new to scripting in PowerShell, therefore, please pardon my skill... I have this mini project to update AD computers descriptions based on the following format from a CSV file I have: ...
0
votes
0answers
29 views

Aggregate Analysis of a CSV file

I work with a lot of large CSV files, sometimes upwards of 10 GB, upon which I need to do aggregate analysis (e.g. Min and Max length of data in a column, is every field in a column numeric, is every ...
0
votes
0answers
22 views

How to change default Text Qualifier (") for Excel [duplicate]

Yes, this question has been asked before but only a workaround was ever found, which is not satisfactory for my situation. Neither is this solution satisfactory. The question is, how can I change ...
0
votes
2answers
112 views

How to I export filenames, filepath and properties of a directory tree to CSV?

I have a hard drive full of backups that I need to detail on a spreadsheet quickly and in the following specific way. I'm hoping there's an easy way to do what i need via some sort of .bat or .cmd ...
0
votes
0answers
31 views

Issue with MS Word mail merge with footnotes

I have kind of a weird issue regarding MS Word's mail merge (MS Word 2010). I have a simple docx document with some text and some footnotes. Now I am connecting it to a csv file for starting a mail ...
0
votes
1answer
35 views

Delete row with empty line csv

1 1479870 5022248660 1 1911574 3015889020 8 1 1569783 5029193930 Output should be 1 1911574 3015889020 8 I used awk '$4!=""' number.csv but it didn't work. Can anyone give me a clue?
0
votes
1answer
65 views

Excel VBA index match a csv import

How can I use an index match function in VBA to find values in a CSV file then import those values to the matched index in a cell in Excel? Say I have a CSV file which contains the following comma ...
0
votes
2answers
48 views

Filter Excel table matching two columns values

I have an excel table I want to filter only the rows in which the value of the numeric column "customLabel" matches with one of the rows of another column in another google sheet. Can I use the ...
0
votes
2answers
74 views

WMIC batch file to loop through CSV and get drive status

I am using this code to check the drive health status of remote PC's in my company for /f "tokens=1 delims= " %%a in (C:\temp\HOSTNAMES.csv) do ( WMIC /Node:%%a DiskDrive GET Caption, Status ) ...
-1
votes
0answers
28 views

Solr, how does the indexing work?

Ok, so I'm trying to upload some data onto my Solr server via WebUI and update. Let's say that I'm uploading 5k lines of CSV data, which would be 5MB in a txt file. With 6 fields it takes about an ...
1
vote
0answers
53 views

How to copy multi-line text from LibreOffice Calc WITH quotes

I've been searching and found this question... How to copy multi-line text from Excel without quotes? ...which is almost exactly the opposite problem I have. I am using LibreOffice Calc and I have ...
0
votes
0answers
43 views

Fixing AS400 error: “Someone else is working in 'J:\AS400 Automation\tk.csv' right now. Please try again later.”

I was able to create a simple command in AS400 by recording some macros from AS400 then adding some codes thru the .ebs file. It was working fine when I was using it but when it was applied to 10 ...
0
votes
1answer
74 views

Extracting SharePoint data on daily basis

I want to export my SharePoint document library data on daily basis and csv file need to be save as naming convention as Dataname_yyyyMMdd. As per my below script, it need to export data from the ...
0
votes
0answers
29 views

Changing .csv file from UTF-16 to UTF-8 deletes file data

I tried changing character set of .csv file from UTF-16 to UTF-8 using the unix command iconv -f utf-16le -t UTF-8//TRANSLIT <input file> -o <output file> After running word count ...
1
vote
2answers
46 views

How to join/merge 2 worksheet tables from time-series in Excel?

How do you join two datasets in excel from time-series, but the observations have been made at different times. How would you combine the observations in one table with the second? Example: table 1: ...
0
votes
1answer
69 views

extract data from SharePoint document library to CSV using powershell

I am trying extract data of SharePoint document library to CSV file using powershell. I am getting data correct on CSv file. But one column i.e "Description" have more text data on it.So when run the ...
0
votes
1answer
100 views

Hashtags are coming when export data to CSV file by powershell script

I am running a powershell script for getting data from SharePoint document library. While run the script, data came to csv file, but columns names are coming with ";#" hashtags. For example, names, ...
0
votes
2answers
36 views

Get element in CSV file, make it an integer and add it to the beginning of the line

I have a CSV with hundreds of entries and I'm trying to do the following: 1. Get the first element (decimal number, ex: 1.01) 2. Remove the decimal part of the element (ex: 1) 3. Add the new ...
1
vote
1answer
197 views

Force Excel to save files with .TSV file extension

I am using Microsoft Excel to work with tab delimited files. Although I can import tsv files without an issue, I can't save them with the TSV extension. Instead, I have to 1. Import the TSV file ...
0
votes
2answers
122 views

Powershell CSV import to html in table

I try convert an csv file to html with Powershell. It only takes the last line in the csv file and not all lines. I am new to powershell, so hope someone can help me $users = import-csv “C:\fso\...
0
votes
1answer
41 views

Is there a way to make Microsoft Excel 2010 include the *.csv files in its list of default files in the file open dialogue box

I am working with CSV files a lot and have to frequently navigate to different directories that contain CSV files. Whenever I press Ctrl + O to open a CSV file, Microsoft Excel 2010 will not list any ...
0
votes
1answer
22 views

CSV Not able append text as some rows understood as text and some rows and number

I have a excel with a one column. That is imported from Mangento tool. One of the row value is 7,81,90 and one of the row value is 71,08,19,11,31,614 First row understood as text however ...
0
votes
1answer
15 views

Trying to delete .cap, .csv files but i get an error [duplicate]

I need help on my kali linux. I tried to delete these files 1186047 -rw-r--r-- 1 root root 19717377 Sep 5 17:54 -01.cap 1186032 -rw-r--r-- 1 root root 576 Sep 5 17:54 -01.csv 1186040 -rw-r--...
1
vote
2answers
379 views

MySQL error in loading CSV file data into table

I am trying to load the contents of a CSV file into a table using the following MySQL commands on Windows: LOAD DATA LOCAL INFILE 'C:/Users/TD_DI_026.csv' INTO TABLE digitalTags FIELDS TERMINATED BY '...
0
votes
1answer
43 views

How do I create a ''droplet'' script in Win7 that runs a Notepad++ task on a CSV file

I have recently asked a question on how to perform a neat little 'Find & Replace' task on my CSV media database files (a task i have to do at work on a daily basis). The question was answered here ...
1
vote
2answers
51 views

How do I copy specific selected data between cells in a CSV file in Excel or Notepad++?

I have to download media file databases on a daily basis and modify metadata from a csv file so that the unique numerical prefix in column B is added as a suffix to the cells in column C. Is there a ...
2
votes
0answers
51 views

Automating CSV loading to Salesforce

Just to give some context, I currently have a CSV loader page developed in Salesforce where I can load files(source is from a Database where I export a CSV) from my local system into Salesforce to ...
0
votes
0answers
51 views

Set Custom Path While Exporting in VBA

I am using this post's accepted answer for one my exports. Based on the answer, it saves my exported .csv file in my C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART. However, I need this ...
1
vote
1answer
156 views

Trying to export single column's data from large CSV file

Problem: I am trying to export a single column of a .CSV file that is 7 gigs in size (large enough that I can't open the entire file in excel... or most text editors for that matter) to a smaller file ...
1
vote
1answer
19 views

Excel Unable to Display or Distinguish Text Strings

I created a simple CSV file with only this exact text (quotes included): "-2**31-1","-2**31" How can I open this CSV file in Excel and get it to display exactly: A B 1 -2**...
1
vote
1answer
31 views

CSV file - Combine title if value=YES in another cell - Libreoffice / Excel / Googledocs

I have a file with text divided into cells that I want to group into another cell. Cells are: A, B, C, and D are what I have. In each coluimn, if the value is Yes, I would like the Result column to ...
1
vote
2answers
74 views

Separating comma delimited data from one cell to multiple cells when the entry is a live data link

My Excel model imports live data from some trading software. If I insert the following formula, I get the details of current tender offers, which are constantly changing: =RTD("rit2.rtd",, "...
0
votes
1answer
66 views

How to create multiple html tables from multiple csv files using a shell script

I have two csv files like this: test1.csv: user size aaa 10 bbb 20 ccc 30 test2.csv: name value www 5 mmm 8 ppp 9 I want to convert this to two separate HTML tables using a shell ...
0
votes
0answers
52 views

How to get a list of all restorepoints with some informations with PowerShell

I want to get a list of all restorepoints with some informations. I have CSV File with all the vms i want to proof. I tried it like this: $days = 10 $DateToCompare = (Get-date).AddDays(-$days) $...
3
votes
2answers
165 views

How do I clean ~500,000 records in Excel 2010 without crashing my PC?

I have to remove large chunks of information from tables in .xlsx files using Excel 2010. Every method I have tried so far has produced no results, either crashed or I've killed it after waiting for a ...
0
votes
1answer
38 views

How to automate the creation of pdf's? [closed]

I want to create multiple pdf's that look like this : "Hello , {Name}! ... some generic text ..." where {Name} takes values from a csv file . How can I automate this process?
2
votes
2answers
1k views

Remove every line breaks following carriage return (^M) and join the lines

edit: Now that I got answers, I marked one by @KamilMaciorowski that fits better to the title as an answer, but this answer by @oliv actually were better suited to my actual need to my primary purpose....
0
votes
0answers
62 views

CSV file Question marks everywhere [duplicate]

I have a really big problem with data file (I'll use another smaller file for example below) I did some excel work in CSV file and Saved it when I opened Georgian language characters were changed to ...
1
vote
1answer
68 views

Perform Math between two CSV files and output as new CSV file (Or print largest difference)

I have two CSV files with the FileCount and Foldersize of the same folders, taken at different times. (Same headings, same rows and columns. The only difference between these two files is the ...
1
vote
1answer
118 views

Import from tab delimited text file in Excel - CR character in quote marks is ignored

I have a large TXT file delimited with TAB. Text is enclosed with quotation marks, but Excel still breaks the values into two rows when a CR character appears within the encapsulated string. Is there ...
-1
votes
1answer
25 views

Place a String separated by commas into the Excel rows

I have a String like this separated by the commas: id, payment_request_id, user_id, market_id, exchange_id, type_id, nominal, ask_price, original_rate, min_execution, from_date, to_date, state, ...
0
votes
0answers
102 views

Cannot Delete Files on Cluster Shared Volume as Non-Admin User (despite correct NTFS security permissions)

This appears to be inherent to CSV's. I have given a user FULL CONTROL NTFS permissions to a folder on a cluster shared volume. The user can create anything in the folder. They however cannot delete ...
0
votes
1answer
185 views

Inserting Arabic text in a CSV

I have a strange issue which is killing me. I have a CSV file that is UTF-8. It is made up of some text fields and numeric fields. When I open the file in Notepad/Notepad++ and try to add Arabic ...