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

learn more… | top users | synonyms (1)

0
votes
0answers
6 views

How to migrate artifacts fom a project to another

I am the scrum master of a project. As a newbie to Tuleap, I created a sandbox project. After experimenting in my sandbox, I want to feed my true project with artifacts like user stories or epics. I ...
0
votes
0answers
29 views

Excel converts comma delimited to tab delimited when saving

I create data in Excel 2013 and save it as .csv. We have an application that imports files of type .address so after saving the file as customer.csv, I change the extension to customer.address. This ...
0
votes
0answers
9 views

text qualifier of csv missing in excel

I have created a csv file with semicolon as delimiter and double quote ad text qualifier. But when I open in excel, the first double quote of the rows disappear. When I use text to column wizard ...
0
votes
1answer
41 views

add space after nth commas in Excel, Notepad++, or emEditor?

Notepad++ 6.8.8 I want to be able to turn several lines that start like this: 0,2,3,45,67,89,01,234,567,890,123,4567,8901 0,7,8,9,0,11,12,13,14,151,162,173,184 x,z,q,r,n,f,t,a,e,f,z,n,a into 0, ...
0
votes
2answers
22 views

Taking part of CSV file

I have a very large CSV file which I should analyze. It's too big so I can't even open it in Excel or Stata. So I want to take first few rows of it and explore the data, and then select necessary ...
0
votes
1answer
169 views

Weird glitch after copying from a CSV file?

I was doing a programming job that involved writing data to a large CSV file (700 MB). I occasionally opened the file using libre office to check the data coming in. This morning I opened the file ...
0
votes
2answers
14 views

How can i change the directory in this VBA code? VBA “Excel to TXT or CSV”

I really want to change the directory of this code in Application.ActiveWorkbook.Path but i don't know where to put it. Public Sub CharacterSV() Const DELIMITER As String = "|" Dim myRecord ...
0
votes
0answers
30 views

Exporting Outlook contacts to Unicode CSV

Background So I've been looking for this to work for some time now. I'm sure there must be a solution as I can't believe that no one in China or Japan have ever tried exporting contacts. What I've ...
1
vote
1answer
22 views

Export a csv file to multiple csv files with batch command

I have a 100 line csv file, with 5 values per line. I am looking for a way to export each line to its own csv file adding a 2 line header to each. I have used the split command seen elsewhere to ...
-1
votes
1answer
43 views

Removing duplicates from txt file

I have a txt file that can contain up to 13.000.000 randomly generated codes seperated with "\n" by the fputcsv function in php. What is the most effective way of removing duplicates from this file? ...
-2
votes
1answer
43 views

Separate fields in comma delimited fields

I am importing a comma delimited file into a ms access database that has statistical information for horse racing. The file has individual horses, dates of their races, finish position, etc. I am ...
1
vote
0answers
19 views

Notepad++ multi line copy paste in different lines

I have a csv file with: David,33,Virginia John,45,Alabama Tina,33, Texas Another file which contains: <Person> <Name>name1</Name> <Age>xx</Age> ...
0
votes
0answers
31 views

Importing Variable data sets with UTF 8 BOM japanese characters

I have an image template and have a xlsx file with Japanese characters wit two columns(PFA). I need to create images with this information by importing the CSV into variable data sets. When I convert ...
0
votes
0answers
24 views

Excel 2010 - Get CSV wizard to open by default

I'd like to set Excel 2010 to open the import wizard each time I double click on a CSV file rather than have Excel open the file without the wizard. Previous versions of Excel did this but 2010 ...
2
votes
1answer
43 views

How to specify semi colon character ';' as a line ending character when importing CSV to Excel on Mac

(Using Microsoft Excel form Mac version 15.18) Can see delimiters for the columns in the import steps, but no-where is there an option for defining what the line ending character is. I need this so ...
1
vote
1answer
27 views

Applying settings by default to CSV documents opened in MS Excel

End-users of a system we are developing are given a plain-old CSV file that end users will be opening in MS Excel. One of the columns will contain entries which consist of strings of numeric digits. ...
1
vote
1answer
53 views

Import from csv to Libreoffice Calc using 'two blank spaces' as delimiter

I want to import some data from a csv/text file to Calc. In the first column I'd like to have the 'Dummy text # i', and in the second column the numerical value. In the text file, 'Dummy text # i' ...
0
votes
1answer
25 views

Linux:AWK gsub command not processing correct output

On the below csv file I would like to change the scope from ENG to PROD; I have used the following awk command but there is no change to the file, could anyone please tell me what is wrong? test.csv ...
0
votes
1answer
23 views

How can I count unique comma-separated values - Early Bound vs. Late Bound

I am trying to display unique values from a string of values in a single cell.(separated by a comma). I've come across this solution: How can I count unique comma-separated values in Excel 2010 ...
0
votes
1answer
38 views

Is There an .xml Format File that Excel Can Read

I'd like to use C++ to generate an Excel file. I know that Excel can read .csv files, but I was looking for something with more power. For example, the ability to create separate sheets and insert ...
0
votes
2answers
56 views

Data validation in Excel- all values in comma-delimited list within cell range

I have a reference table of memos and some information about them, including what other memos they reference and are referenced by. I want to make a data validation rule that will appear red if any of ...
1
vote
0answers
33 views

Information lost during format conversion from .csv to .cap [closed]

I have my data from an experiment in .cap form (created using Pasco Scientific Capstone software), which I exported to comma-delimited form. When I tried to convert the comma-delimited form back to ...
1
vote
1answer
37 views

Replace returns wrong capturing group

I have a text file that looks something like this: ,'','a','bc','def','ghi','lmn','op','qr','stu' I'm trying to replace groups of 5 with the match and a line break for easy readability. So, I'm ...
0
votes
0answers
38 views

Excel Data Connection Always Has 1 Extra Row

I have an Excel file with a data connection to another Excel workbook. Every time that I refresh the connection, there seems to be one extra blank row in the table (with formulas, but there is no ...
0
votes
2answers
74 views

Rename CSV header using command line tools

Given a CSV file, h1 h2 h3 a b c z x b how to rename the first header to One and the third header to Three using command line tools, namely One h2 Three a b c z x b
0
votes
1answer
80 views

Batch file to get the domain name of hundreds of servers in a multi domain environment

In a multi-domain environment, I need to get the "Domain Name" the servers are joined to. I have a list of hundreds of Windows servers with the hostname only (not FQDN). I was wondering if there is ...
0
votes
1answer
54 views

Add custom category type column to an Excel 2016 Power Query

Used the power query feature of Excel 2016 to import several CSV files containing personal financial history and trying to use the power pivot thing. Problem is I really need to group the ...
0
votes
1answer
41 views

Macro exports date column to csv as numeric value rather than dd/mm/yyyy

The following code has achieved what I require except that the date [cell B2] is exported as as five digit numeric value rather than dd/mm/yyyy. How to I amend the code to force B2 to export as ...
1
vote
0answers
77 views

What's the most convenient way to edit multi-card vcard files (.vcf)?

I have my contacts exported to a VCF file (a vCard) file. But they're partially messed up for reasons I won't go into. I'd like to edit them, making some changes to individual entries and some changes ...
0
votes
1answer
78 views

Excel export batch of columns from one worksheet

I am a very new user to VBA and am trying to create a macro to do a batch export of selected columns to a csv and then increment and loop that selection to continue exporting csv until end of dataset. ...
0
votes
1answer
160 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
56 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
102 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
90 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
23 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
27 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
19 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
26 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
60 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
908 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
66 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
170 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
36 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
9 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
32 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
57 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. ...
1
vote
1answer
1k 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
74 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 ...