Read in 2-column CSV, output many files based on field
Is there a way to read in a two-columned CSV file, and based on the fields in 1st column, output many different files? The input/output looks something like:
I'm stuck at the part of checking which items in 1st column are the same, then saving all those identical items along with their rows into a new list?? Is this possible to do with shell scripts, or would I need to use Python?
Hi All,
I am newbie to Unix I ve got assignment to work in unix
can you please help me in this regard
There is a sample CSV file
"Username", "Password"
"John1", "Scot1"
"John2", "Scot2"
"John3", "Scot3"
"John4", "Scot4"
If i give the column name as Password and row number as 4 the... (3 Replies)
I have a csv file that I need to extract some data from depending on another field after reading info from another text file.
The text file would say have 592560 in it.
The csv file may have some data like so
Field 1 Field2 Field3 Field4 Field5 Field6
20009756 1 ... (9 Replies)
Hi List,
I have two files. File1 contains all of the data I require to be processed, and I need to add another field to this data by matching a common field in File2 and appending a corresponding field to the data in File1 based on the match... So:
File 1:... (1 Reply)
Dear List,
I have a file of csv data which has a different line per compliance check per host. I do not want any omissions from this csv data file which looks like this:
date,hostname,status,color,check
02-03-2012,COMP1,FAIL,Yellow,auth_pass_change... (3 Replies)
hi, someone to know how can i read a specific column of csv file and search the value in other csv columns if exist the value in the second csv copy entire row with all field in a new csv file. i suppose that its possible using awk but i m not expertise thanks in advance (8 Replies)
My scenario is that I need to pick value from third column based on fourth column value, if fourth column value is 1 then first value of third column.Third column (2|3|4|6|1) values are cancatenated.
Main imp point, in my .csv file, third column is having price value with comma (1,20,300), it has... (2 Replies)
Hi,
I have a huge file that has data something like shown below:
huge_file.txt
start regexp
Name=Name1
Title=Analyst
Address=Address1
Department=Finance
end regexp
some text
some text
start regexp
Name=Name2
Title=Controller
Address=Address2
Department=Finance
end regexp (7 Replies)
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Hello everyone,
I am using ksh on Solaris 10 and I'm gathering data in a CSV file that looks like this:
20170628-23:25:01,1,0,0,1,1,1,1,55,55,1
20170628-23:30:01,1,0,0,1,1,1,1,56,56,1
20170628-23:35:00,1,0,0,1,1,2,1,57,57,2
20170628-23:40:00,1,0,0,1,1,1,1,58,58,2... (6 Replies)
Dear UNIX experts,
I'm a command line novice working on a Macintosh computer (Bash shell) and have neither found advice that is pertinent to my problem on the internet nor in this forum.
I have hundreds of .csv files in a directory. Now I would like to copy the subset of files that contains... (8 Replies)
Discussion started by: rcsapo
8 Replies
LEARN ABOUT DEBIAN
music123
music123(1) General Commands Manual music123(1)NAME
music123 - plays various sound files (usually including MP3, Ogg and Wav).
SYNOPSIS
music123 [ -hqrvz ] file ...
DESCRIPTION
music123 is a shell around various command line programs to play music files. It will descend directories trees with -r, and randomize
file lists with -z. The programs used and the options given them are listed in /etc/music123rc or ~/.music123rc.
OPTIONS -h Show command help and exit;
-q Quiet mode. No messages are displayed.
-r Recurse into directories, instead of ignoring them.
-v Display version information and exit.
-z Play files in random order.
-Z Play the files randomly and endlessly.
-l Loop. -z -l differs from -Z in that -z -l will randomize, play through the song list (without repetition) in random order once, and
repeat the songs in that order over and over; -Z will randomly play the songs, without any order, and will possibly play a song
right after itself.
-i Ignore extension case.
-L List files and exit.
-T Start a task that handle commands, only one command supported : quit, using q or Q will quit the application at the end of the cur-
rent song.
-D Set music123 not to delay between songs. (May make music123 harder to kill).
-d Customize the time music123 delays between songs. -d takes one argument, expressed in seconds, which may have a fractional part.
-@ Play the files listed in the mandatory argument of -@. Other files can be added on the command line, and this option can be given
several times. Note that music123 doesn't yet play URLs.
-- End option list.
EXAMPLES
Play three songs:
music123 test1.ogg test2.mp3 test3.wav
Play a couple of directories and other songs at random:
music123 -z -r Rock/ test1.ogg Pop/ test4.wav
FILES
/etc/music123rc
Describes which programs music123 uses, which files types it supports, and which options it passes those programs.
~/.music123rc
Per-user config file to override the system wide settings.
AUTHORS
Authors:
David Starner <dvdeug@debian.org>
July 24, 2002 music123(1)