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

1
vote
4answers
46 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,, ...
0
votes
6answers
194 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
21 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 ...
1
vote
3answers
74 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 ...
0
votes
1answer
46 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
74 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 ...
2
votes
4answers
312 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 ...
0
votes
1answer
303 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 ...
2
votes
2answers
171 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?
4
votes
2answers
198 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 ...
-4
votes
2answers
366 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
77 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 ...
10
votes
5answers
3k 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
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 ...
3
votes
5answers
3k 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
123 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
612 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
290 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
154 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
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: ...
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, ...
1
vote
1answer
773 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
244 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
880 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
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. ...