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

9
votes
5answers
2k 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
541 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
144 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
2k 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
4k 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
737 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
193 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
99 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
2k 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
1answer
213 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
86 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
1answer
727 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
132 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
743 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
52 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
1answer
54 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
103 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
244 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
159 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 ...