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

learn more… | top users | synonyms (1)

1
vote
1answer
337 views

How to find/export only one value (primary SMTP) from multi-valued Proxy Addresses

I have a script which search values in attribute Company and Proxy Addresses. Get-ADUser -Filter * -SearchBase 'OU=Stu,OU=LOWA,OU=IDLOWA,DC=ad,DC=ju,DC=com' -Properties company,proxyaddresses | ...
0
votes
2answers
28 views

Excel incompatible with itself

So I have a csv I created with excel in this format: col1;col2;col5 a;b;c d;e;f I want to change it to the more usual " and , how can I do that as of now every change either changes the encoding or ...
1
vote
2answers
74 views

Excel: comma in tab-delimited csv file

I have a tab-delimited csv file: "a" "b" "c,d" "e" Excel renders the second row until comma and the rest of the row is not rendered. I enclose each cell in double-quotes but it doesn't help. Is ...
0
votes
0answers
188 views

Convert a txt file into csv using powershell

The document that I am trying to convert is Formatted like so: 2012/12/09 REPORT OF USERS PAGE 1 HRS RG POSITION OPTIONAL ADDITIONAL USER # ...
0
votes
0answers
108 views

I can't import contacts into Outlook 2013 using vcf file and csv file

Help! I've backed up my phone with an app called "My Contacts Backup" emailed them to myself in vcf format. I tried to import it into my Outlook contacts but keep getting a permissions error. " We ...
0
votes
2answers
33 views

CSV file has dates formatted e.g 20140530 that are not recognised as dates

CSV file has dates formatted e.g 20140530 ( should be 30/05/2014) that are not recognised as dates. Is there a quick fix to convert them to a date format without retyping whole column? Thank you!
1
vote
1answer
35 views

Is there a command or way on how to retrieve or directly download a .csv file from raspberry pi to windows 7 using putty?

I am trying to remotely retrieve a .csv file from my raspberry pi using putty. Is that possible? If so, is there any command that allows me to automatically download or transfer that .csv to my ...
0
votes
1answer
30 views

Error running macro after trying to run it from pesonal workbook

So I wrote a macro. The scenario of use is: I open a fresh and new CSV file downloaded from somewhere My macro runs and does some magic with the data Since I don't want to copy-paste my macro to ...
0
votes
0answers
20 views

Have Excel search CSV's and mark where he finds names

Sorry about the confusing question title, it's kinda confusing me to explain in the right way, so hopefully this text will do a better job with it. My company has multiple CSV files pertaining the ...
1
vote
0answers
31 views

Locked between MailChimp and European Windows for CSV export?

I have a CSV export for our application that is being used by end users (not tech-savvy). For some European regional settings Excel expects a semicolon ; for delimiting (comma is used for decimals). ...
0
votes
2answers
66 views

Turning CSV into rows not columns

I have a file with unique references in column A (e.g.company names) and one or more values returned related to that unique value in column B (e.g.accounts). These are comma separated, some companies ...
0
votes
1answer
2k views

Command Prompt output to CSV

I'm using the forfiles command to list files and folders (included sub folders) which is piped to a text file. My subsequent process requires this output to be in comma delimited format (.csv). This ...
1
vote
0answers
88 views

Regex to find commas, excluding commas inside a string demarcated by double quotes

I would like to manipulate a closed .csv file without opening it through a button on an Excel AddIn. I am able to complete all the steps but am having a problem with finding a regex that would ...
1
vote
0answers
238 views

Properly import all fields from 'Windows Contacts' to Thunderbird

I want to migrate/import ALL information of my contacts to Thunderbird. On my Windows 7 system I carefully managed my contacts including birthday, gender, spouses and children. But I'm having trouble ...
0
votes
0answers
45 views

Pasting Paragraphs into Excel cells with Automatic HTML line breaks

Hello All Excel masters, Using Microsoft Excel I'm Working with Magento & creating large product lists in a .CSV format. The Problem I'm having is when I Paste Ex. paragraph LEGO movie ...
0
votes
0answers
12 views

Export CSV list of reverse links in Tuleap

I'd like to export the reverse links for my artefacts in CSV (i.e. having a list of all artefacts linking to the artefact I'm exporting the data from). Is it doable without having to trick it manually ...
0
votes
2answers
36 views

Reference cells in column of .csv from command line

I have a column B in my.csv in which each cell references the filename of a document in a directory source_directory/. I'd like to grab each of those names so I can use them as args for other shell ...
0
votes
0answers
70 views

Libre Office Calc Issue: Summarizing columns with too many rows

I'm writing a script that reads data taken from a database. THe data is modified (de-duplicated) and put into a .csv file I have a problem as I want to find the sum of a particular column in excel. ...
2
votes
2answers
3k views

How can you change Mac excel 2011 to separate using commas, not semicolons?

I have Excell 2011 on my Mac, and when I try to export a .xls file into .csv I end up having a semicolon separated file instead of .csv. p.s. The System preferences for my keyboard input is italian ...
0
votes
0answers
90 views

Capturing the MAC addresses of associated clients of a specific access point

I am trying to capture the MAC addresses of associated clients of specific access points as an experiment to see which type of device (by way of OUI lookup) most commonly connects to different access ...
0
votes
0answers
38 views

Spline drawing to CSV

I am trying to generate a csv file for a spline curve drawn on LibreCAD. I see that the drawing can be saved as dxf/dwg, but not as point data. I was wondering if anyone has managed to export into csv....
0
votes
1answer
43 views

Split name column to csv file

How can I easily transform columns information to CSV line or file output? Input (From file or excel column): ABC1 ABC2 ABC3 ABC4 Output (To file or excel line): ABC21,ABC2,ABC3,ABC4 I don't ...
0
votes
1answer
76 views

Preserve existing tags in Anki CSV import/batch-add tags

I have downloaded the complete 2012 HSK vocabulary from here, where it is available as an excel file. I have then converted it to .CSV and changed it to this form: 爱;HSK:1 … 做主;HSK:6 The first ...
0
votes
1answer
24 views

Similar Excel Extensions as CSV

This query is related to Mainframes & Excel. If we have to transfer a file from mainframes to excel and it is .CSV, then automatically excel delimits the contents with comma. I need to know how to ...
0
votes
1answer
57 views

Why is Excel (sometimes) changing casing of a text in an imported file?

So this is a bizarre problem some users of ours are seeing, that I've been able to confirm, and that makes absolutely no sense to me. Basically, I work on an application that will export files in CSV ...
1
vote
1answer
42 views

Generate CSV from NS Zone File

I have a large file that contains records in multilines. ex: domain1 NS ns1 domain1 NS ns2 domain1 NS ns3 domain2 NS dnsx What might be the fastest way to generate a CSV of the form domain1,ns1,...
2
votes
0answers
227 views

PowerShell Script to Rename - Copy - Move

I am trying to write a PowerShell script to do the following. step 1 Rename files in source (FTP folders) directories with it's "current_name_datetime.csv" as per a source file "Source_list.csv" ...
0
votes
1answer
99 views

Transform a CSV with Notepad++

Suppose I have a CSV file like this: 1,"abc",,,, 2,"def",,,"ghi", 3,,"jkl",,,"mno" Now I need to transform it in 3 steps: Replace all empty spaces with the String NULL Add at the beginning of ...
-8
votes
2answers
236 views

How to create a batch file to ftp files in the directory with the name realated to yesterday? [closed]

I have a set of directories with encoded in their names the date. Inside those directories there are files named files.csv. The directories have a standard name as, for example, /opt/oss/server/...
1
vote
1answer
720 views

How can I make Excel save a .csv using commas and quotes?

I am trying to save file as a .csv, however, Excel is not using the standard comma separator and quotes. Here is an example of what I want: "0","70","0","4/29/2012 12:00","13311250""1","70","0","4/30/...
0
votes
0answers
44 views

Most reliable or widely used standard for CSV file formatting

I'm wondering what are the most common standards for CSV file, and is there any OFFICIAL one ? I just did several searches on google, SO and other sources, and the best I found is Wikipedia : No ...
3
votes
4answers
658 views

How to export a spreadsheet to a UTF-8 .csv from Excel 2016 on mac?

Hoping you can help me out with this one... For my work, I've been assisting a DBA for the last few weeks and we've now been given the task of uploading a very large spreadsheet which has several ...
0
votes
1answer
200 views

Export multiple (specific) worksheets to CSV files in a specified directory

I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected. Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular ...
3
votes
2answers
114 views

Which delimiter allows major spreadsheet programs to open CSV files by double-clicking?

I'm writing an iOS 8 app that allows you to export data to be sent as an email attachment. Currently, I'm exporting the data to a CSV file with 7 columns and x number of rows. When I first created it, ...
1
vote
2answers
1k views

UTF-8 File is not showing Chinese characters in Excel

I am creating a CSV file with UTF-8 encoding. It displays the Chinese characters properly if I open it using Notepad++. It displays the Chinese characters properly if I open it using Notepad. But, ...
1
vote
1answer
72 views

How can I automatically segment a mp4 video based on a list of frames

I have a 7 hour long h.264 video made up of 1600 shorter videos and I have a csv file with a list of frames at which I need the longer video to be cut at. Is there any way that I can automatically ...
1
vote
1answer
238 views

How can I write only certain rows of an Excel worksheet to CSV?

I have created an Excel (2010) workbook that takes information from various CSV files and puts them into a format that can be understood by my office's scheduling program. Using a macro I found ...
0
votes
0answers
366 views

Losing decimal places when exporting to csv

I am exporting data from oracle table into a csv file. I have a column of varchar2 datatype and it has values like 1.1 and 1.10. When I export these to a csv file the value 1.10 becomes 1.1 and thus ...
2
votes
2answers
45 views

Delete everything in second column not in parentheses

I have a file that looks like this: gene ID protein Solyc06g062540 (Z) PYROPHOSPHATASE 3 (PTHR20889:SF0) Solyc10g075050 ALBUMIN SUPERFAMILY (PTHR33076:SF11) Solyc07g061760 ...
1
vote
1answer
75 views

Import Network Settings (wi-fi) from Windows to Mac; Bulk Import of Wifi Keychain Passwords

I have a CSV/TXT file with a list of network names and passwords (together with network/password/encryption types) that looks like this: ***Networkname1*** ESS WPAPSK TKIP passPhrase ***...
6
votes
3answers
1k views

How to split a CSV file into multiple files based on a text string?

I have multiple text files (CSV) with a structure similar to this: funkiana,23.55,-99.866 funkiana,24.634,-98.701 funkiana,24.717,-98.901 geminiflora,22.25,-104.6166667 geminiflora,21.21666667,-104....
0
votes
3answers
90 views

What is the delimiter for the CSV file below?

I'm having trouble importing the CSV file, below, into Excel 2007. I can't figure out what the delimiter is. "_id,""author_details"",""title"",""isbn"",""publisher"",""date_published"",""rating"","...
1
vote
2answers
353 views

Concatenate csv-files with the same name from subdirectories

I found some scripts concatenating text files from different subdirectories, but all of them produced output files like "output.txt", but didn't keep the original file name. Structure Folder_A a....
1
vote
1answer
23 views

How can I disable dates in the Calc?

I see that all spreadsheets are urgent to recognize your 13.12 as a date. Particularly, I am struggling with Calc, who is said to use English language to import dots as decimal separators. But, ...
1
vote
1answer
51 views

What has caused my csv load time to dramatically increase?

I have a monthly report formatted as a .csv file. It's file size is 90 MB. It used to take around 10 seconds to open. Now it takes 4-5 minutes. When I convert it to an .xlsb, it takes 10 seconds. ...
1
vote
1answer
1k views

Invalid field count in CSV input on line XX in phpmyadmin?

I have a 16MB CSV file with 50,000 lines that I want to import into my database. I go to the PHPMyAdmin-Interface, choose IMPORT and set the correct options. The import fails with the error Invalid ...
1
vote
0answers
339 views

feed XML to google calendar [closed]

I have an XML file with seminars that I would like to feed to google-calendar. The XML file is maintained by someone else and is updated regularly, so I would like to do this in a way that google ...
1
vote
1answer
592 views

CSV Input for Merged Columns in Microsoft Excel

I am using Excel 2010 (v14.0) on Windows 7. I would like to have a header, and subheader, where columns are merged in the header but separated in the subheader and data. I know how to merge columns ...
1
vote
3answers
508 views

Need a batch script to copy data from A.csv to B.xls

I'm a newbie to batch scripting and need help. I want to copy the contents of a csv file A.csv to the first worksheet named "GenData" in a existing XLS file B.xls. B.xls contains some macros in it's ...
-1
votes
1answer
386 views

Visual Basic and Excel data streaming in real time [closed]

I'm currently working on a program that runs in visual basic (not VBA). The program collects data from sensors and produces a data file (*.csv) of the information it collected after a certain stretch ...