CSV stands for comma-separated values & generally used to store the content with simple field breaks in a text file . Here the Content is text. Mainly used to backtup the contacts.

learn more… | top users | synonyms

10
votes
5answers
4k views

Add column from one .csv to another .csv file

file1.csv A,,C,D A,,C,D A,,C,D A,,C,D file2.csv A,B A,B A,B A,B desired Output.csv A,B,C,D A,B,C,D A,B,C,D A,B,C,D I've tried using "join" and "paste" to no avail. Is there a bash command to ...
5
votes
1answer
2k views

How to batch rename files (images) based on CSV file

What I have and want to achieve: There are thousands of images in one folder. I have a CSV file with following columns: A: original name B: renamed name A typical row looks like this: ...
4
votes
3answers
724 views

Searching for patterns in csv files

I have file.csv that looks like this 4,6,18,23,26 5,12,19,29,31 2,5,13,16,30 9,10,24,27,32 4,5,10,19,22 4,6,8,10,25 2,3,4,25,11 I want to find some patterns and save them in another log file ...
4
votes
2answers
250 views

Remove all English text and leave Arabic text

This question is a lot like this. I just need a slight modification. I have a csv file that looks like this y(document).ready(function($) { $('#wp_mep_2').mediaelementplayer({ m:1 ...
3
votes
5answers
4k views

How to transform valid JSON to CSV?

I'm trying to extract information from a JSON file and write some of the contents to a CSV file. Here is an example of my text "data":{"headers":{"sender":"frank@abc.com" "to":"jim@def.com" ...
3
votes
1answer
5k views

LibreOffice 3.6.0.4 Calc saving as Tab delimited

I am using LibreOffice Calc, latest version. I like to save my document in "Tab delimited" - that "Tab delimited" is a feature in MS Excel and then one can open up the document in Windows 7 - Notepad. ...
2
votes
4answers
1k views

Comparing two text files

I have 2 big csv files, file1.csv which looks like this 1,2,3,4 1,4,5,6 1,7,8,9 1,11,13,17 file2.csv which looks like this 1,2,3,4 1,7,8,9 2,4,9,10 13,14,17,18 These are just random numbers that ...
2
votes
4answers
444 views

count the number of unique values based on two columns in a spreadsheet

I need to count the number of unique values based on two columns in a spreadsheet. Suppose the file looks like this, ordered by name, surname, company: joe allen ibm joe smith ibm joe allen google ...
2
votes
2answers
294 views

How can I convert a CSV file to XML?

How can I convert a CSV file to XML? Is there any software for Ubuntu?
2
votes
3answers
3k views

Extracting a part of a massive csv file from command line

I want to read parts of a big csv file between rows n and m and between columns p and q. Is there an easy way to do this easily with the shell? (Are there commands I should read the doc's? otherwise, ...
2
votes
3answers
68 views

Get variable from Zenity list generated from .csv file

I'm trying to get the value from zenity list. But it doesn't work. Some help would be nice :) If I remove the ans=$ I get the value from zenity in terminal like this: 10.33.54.13|10.33.54.13 But ...
2
votes
1answer
296 views

Software for polar-coordinate plots

I'm looking for easy software which can create 3d plot with polar coordinates (cylindrical coordinates) from a csv file (or pasted from eg. libre office). Making a trend-surface or sth like it would ...
1
vote
3answers
143 views

csv file adding and removing characters from rows [closed]

I have a big csv full that looks like so else if(a,b,c,d,e) else if(a,b,c,d,f) I want to make it look like so else if(a+x==b and b+x==c and c+x==d and d+x==e) else if(a+x==b and b+x==c and c+x==d ...
1
vote
4answers
102 views

How to grep csv file information and put it in another file

I have a csv file. And I need to create another file out of it. The csv file is as follows Signal Start,PK_SIG_NME,PK_SIGNALS_WIDTH,DESIGN_SIG_NME(exact string),, ,HRESETn ,1,~dcc_ares,, ...
1
vote
3answers
90 views

removing “_” from a very large csv file

I have a large csv file (120GB) that looks like this: "JE",865438083645,2012-12-05T23:07:36.000Z,24,"NQ",142,"658_55525",475035504705 ...
1
vote
1answer
1k views

print contents of a directory structure (filesystem) to CSV on the command line

How can I catalog the contents of a filesystem to a CSV file? This is particularly useful for removable media. I've found a couple links that point in this direction: AskUbuntu.com: listing files ...
1
vote
1answer
446 views

How to export the Evolution addressbook as csv-file

The export of the Evolution addressbook as vcf/vCard is easy: File/Save Addressbook as vcf. But how about exporting as csv-file?
1
vote
1answer
52 views

How to convert an XML file into a CSV file? [closed]

I try to convert an XML file into a CSV file to output the data and reprocess. What is the best way in open source ? simple, fast and under ubuntu ? A quick search gives me tools like xml2 or ...
1
vote
1answer
203 views

How do I read values from CSV into a script? [closed]

I want to write a script that reads a URL from a .csv file, gets the whois data, then goes to the next URL in the list. #!/bin/bash whois $URL &> "$URL.txt" How do I get the $url, and run ...
1
vote
1answer
822 views

mysql statement in bash shell script does not work / syntax error

hope someone can help me! I do not know what's wrong with this script (Bash / Ubuntu 12.04 / Mysql / XAMPP 1.8.3). Try to read an input file with a list of csv-filenames (449-R11, 449-R12 ..) in order ...
1
vote
1answer
96 views

Export Foldernames in a directory to csv file [closed]

I have a question regarding exporting folder names to a csv file. I have read already many entries in the web to such topics but on nearly all the topic was about exporting filenames and size and ...
0
votes
6answers
288 views

Import users from CSV file

Is it possible to import users by using CSV file? or something like a LDAP connection to import all users?
0
votes
3answers
34 views

Examining EOL characters in a CSV

I have a csv file that I'm intending to import into a mysql table. I would therefore like to make sure I'm reporting it's LINES TERMINATED BY properly. However I cannot figure out what characters ...
0
votes
1answer
102 views

Preserving text formatting when piping output to csv file

I have an executable which gives an output like the following, Posture state: 3 Posture side: 0 Posture state: 3 Posture side: 0 Posture state: 3 Posture side: 0 ...
0
votes
1answer
59 views

I want to write weather data via a python script twice a day to a csv file [closed]

Is this practical? How do I accomplish it? Some barriers I've come across already: I have separate scripts for weather and time. How do I format them into one comma-separated row? how do I print ...
0
votes
1answer
576 views

How to convert following CSV to Hashmap using JAVA [closed]

Suppose I have CSV file like this: Name Roll No. Address PhoneNo Jhon 909 CA 1 Jeff 101 CE 2 Jhon 121 US 3 Jhon 909 US 4 I want to generate ...
0
votes
1answer
331 views

Bulk Insert a CSV file into MongoDB through Ubuntu terminal?

I'm trying to performance test MongoDB through Ubuntu, and I've run into problems trying to upload a CSV file to populate the database. My DB is called 'Assignment' and I want to create a collection: ...
-4
votes
2answers
647 views

Search csv file column

Is there a way to search the content of a specific column of a csv file using the terminal. But that it still returns all the information of the rest of the columns. I want to be able to search for a ...