I tried with the following join command:
but it only complies with requirement 2 above and leaves non-matching fields empty:
Yes: works as designed. ;-)
The join-command follows your orders to include non-matched lines (the "-a") and therefore you see these lines in the output. Depending on what exactly you want leave out "-a 1" or "-a 2" or both. Add a "1.2" to your output rules as fallback.
I hope this helps.
bakunin
These 2 Users Gave Thanks to bakunin For This Post:
Hello!
I am writing a program to run through two large lists of data (~300,000 rows), find where rows in one file match another, and combine them based on matching fields. Due to the large file sizes, I'm guessing AWK will be the most efficient way to do this. Overall, the input and output I'm... (5 Replies)
I am newbie to unix and would please like some help to solve the task below
I have two files, file_a.text and file_b.text that I want to evaluate.
file_a.text
1698.74
1711.88
6576.25
899.41
3205.63
4187.98
697.35
1551.83 ... (3 Replies)
Hi,
I am working with two tab-delimited files with multiple columns, formatted as follows:
File 1:
>chrom 1 100 A G 20 …(10 columns)
>chrom 1 104 G C 18 …(10 columns)
>chrom 2 28 T C ... (4 Replies)
grep -v will exclude matching lines, but I want something that will print all lines but exclude a matching field. The pattern that I want excluded is '/mnt/svn'
If there is a better solution than awk I am happy to hear about it, but I would like to see this done in awk as well. I know I can... (11 Replies)
Hi,
Please excuse for often requesting queries and making R&D, I am trying to work out a possibility where i have two files field separated by pipe and another file containing only one field where there is no matching columns, Could you please advise how to merge two files.
$more... (3 Replies)
In the below I am trying to use awk to match all the $13 values in input, which is tab-delimited,
that are in $1 of gene which is just a single column of text.
However only the line with the greatest $9 value in input needs to be printed.
So in the example below all the MECP2 and LTBP1... (0 Replies)
Hi,
I have 2 tab-delimited input files as follows.
file1.tab:
green A apple
red B apple
file2.tab:
apple - A;Z
Objective:
Return $1 of file1 if,
. $1 of file2 matches $3 of file1 and,
. any single element (separated by ";") in $3 of file2 is present in $2 of file1
In order to... (3 Replies)
Trying to use awk to match the contents of each line in file1 with $5 in file2. Both files are tab-delimited and there may be a space or special character in the name being matched in file2, for example in file1 the name is BRCA1 but in file2 the name is BRCA 1 or in file1 name is BCR but in file2... (6 Replies)
In two previous posts (here) and (here), I received help from forum members comparing multiple fields across two files and selectively printing portions of each as output based upon would-be matches using awk. I had been fairly comfortable populating awk arrays with fields and using awk's special... (3 Replies)
Long time listener first time poster. Hope someone can advise.
I have two files, 1000+ lines in each, two fields in each file.
After performing a sort, what is the best way to find exact matches where field $1 and $2 in file1 are also present in file2 on the same line, then output only those... (6 Replies)
Discussion started by: bstaff
6 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)