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

0
votes
0answers
6 views

How to create users using a csv file created with LibreOffice Spreadsheet?

I am trying to create multiple users and a group all at once to help me learn linux, but im running into trouble. (Mainly I have no clue what i am doing.) groupadd Avengers: useradd Hulk: useradd ...
-1
votes
3answers
132 views

Print different output in the same csv file

I'm writing a script to analyse some data. I have several subset of files, and I would like to count the line from these files and write the result into a csv file. I'll try to do an example. I have ...
0
votes
2answers
121 views

convert txt file to csv seperated with tabs

Sorry people I'm new to Linux, and while I looked through the list of answered questions, I don't know enough to recognize if my question was answered. Or if I can adapt one of the answer to my ...
0
votes
1answer
34 views

How to create username from firstname lastname initials in csv file?

I am using libreoffice and would like to create USERNAME from initials of firstname lastname entries in csv file. my csv file contains many names so the usernames need to be created automatically in ...
0
votes
1answer
13 views

Same commands execute when restart terminal

So, some time ago, I copied csv data from a webpage into terminal to save it to a csv file, like echo "field1,field2,field3,...,fieldn, with about 20 lines of text. I did this because I couldn't ...
0
votes
1answer
20 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
44 views

Removing unwanted rows from csv file having more than 10 patterns to be matched

I have a CSV file which has 2 columns and i have to match values in a single in row in both the column , if it matches the criteria we have to keep the column otherwise delete the entire row. Below is ...
0
votes
0answers
35 views

Looking for a tool to generate pdfs from .csv data

I'm looking for a piece of software that would help me generate one pdf per record in my .csv file. Any suggestions? I want to be able to control the layout of the pdf pretty thoroughly ...
0
votes
2answers
105 views

Windows FINDSTR Ubuntu equivalent to search .csv

I have a folder (Transactions) with hundreds of .csv files. I want to search through all csv files for a particular string and get the output of each line that contains that string. Preferably output ...
2
votes
3answers
204 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 ...
1
vote
1answer
598 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
4answers
275 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,, ...
3
votes
5answers
7k 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
135 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
6answers
806 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
77 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
84 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
140 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
1k 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
1k 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
779 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
369 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
2answers
1k 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
2k 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 ...
10
votes
5answers
7k 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
3k 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 ...
1
vote
3answers
166 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
905 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
492 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: ...
5
votes
1answer
3k 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
4k 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
941 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
375 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 ...
4
votes
1answer
6k 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. ...