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

-2
votes
2answers
39 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 ...
1
vote
1answer
19 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 ...
9
votes
5answers
565 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 ...
2
votes
4answers
384 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
5answers
533 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" ...
1
vote
3answers
65 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 ...
4
votes
3answers
362 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 ...
0
votes
1answer
169 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: ...
1
vote
1answer
104 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 ...
5
votes
1answer
1k 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: ...
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, ...
1
vote
1answer
657 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 ...
2
votes
1answer
157 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
1answer
525 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 ...
3
votes
1answer
3k 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. ...