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
22 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
19 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
57 views

Importing data from CSV with commas nested in parentheses and brackets in fields

Problem I am trying to import data from a CSV into excel, but the data includes commas within individual fields. The commas that I want to ignore are contained within parentheses and brackets. I'd ...
0
votes
0answers
24 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
36 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
46 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
69 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
31 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
55 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
30 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
34 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
14 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
47 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 ...

15 30 50 per page