the code is not appropriately work for the second awk, first example runs just fine...Also I need to condition on the term "collect" win col1 which is missing from the code..Since I added D to fil3.txt.txt, the output should be
Code:
fil1.txt.txt A
fil1.txt.txt B
fil1.txt.txt C
fil1.txt.txt D
fil3.txt.txt A
fil3.txt.txt B
fil3.txt.txt C
fil3.txt.txt D
Code:
$ cat fil1.txt.txt
leave kbl;tbc<A,B;alt<-23
leave kbl;tbc<B,C,D
collect kbl;tbc<A,B,C;alt<-34
collect kbl;tbc<D,B,C,A
leave lbl;tbc<A;J
leave lbl;tbc<B;C
leave kbl;tbc<A;B
leave tbc<B;C;D
$ cat fil2.txt.txt
leave kbl;tbc<A,B;alt<-23
leave kbl;tbc<B,C,D
collect kbl;tbc<A;alt<-34
collect kbl;tbc<C,A
collect kbl;tbc<B,A
leave lbl;tbc<A;J
leave lbl;tbc<B;C
leave kbl;tbc<A;B
leave tbc<B;C;D
$ cat fil3.txt.txt
leave kbl;tbc<A,B;alt<-23
leave kbl;tbc<B,C,D
collect kbl;tbc<A,D;alt<-34
collect kbl;tbc<C,A
collect kbl;tbc<B,A
leave lbl;tbc<A;J
leave lbl;tbc<B;C
leave kbl;tbc<A;B
leave tbc<B;C;D
$ awk -F '.*tbc<|,' '{sub(/;.*/,x, $NF); for (i=2; i<NF; i++) print FILENAME, $i }' fil1.txt.txt fil2.txt.txt | sort -u
fil1.txt.txt A
fil1.txt.txt B
fil1.txt.txt C
fil1.txt.txt D
fil2.txt.txt A
fil2.txt.txt B
fil2.txt.txt C
awk -F '.*tbc<|,' '{sub(/;.*/,x, $NF); for (i=2; i<NF; i++) print FILENAME, $i }' fil1.txt.txt fil3.txt.txt | sort -u
fil1.txt.txt A
fil1.txt.txt B
fil1.txt.txt C
fil1.txt.txt D
fil3.txt.txt A
fil3.txt.txt B
fil3.txt.txt C
---------- Post updated 07-26-13 at 01:17 AM ---------- Previous update was 07-25-13 at 02:54 PM ----------
Is there any way I can create a virtual file that is a subsection of another file? Similar to the way partitions are subsections of the disk device, but configurable and with a normal file source. (2 Replies)
Hi, Iam new to unix. I have one input file .
Input file :
ID1~Name1~Place1
ID2~Name2~Place2
ID3~Name3~Place3
I need output such that only first column should change to fixed width column of 15 characters of length.
Output File:
ID1<<12 spaces>>Name1~Place1
ID2<<12... (5 Replies)
Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2
file 1 sample
SNDK 80004C101 AT
XLNX 983919101 BB
NETL 64118B100 BS
AMD 007903107 CC
KLAC 482480100 DC
TER 880770102 KATS
ATHR 04743P108 KATS... (7 Replies)
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (4 Replies)
Hi All,
I have a file example.csv which looks like this
GrpID,TargetID,Signal,Avg_Num
CSCH74_1_1,2007,61,256
CSCH74_1_1,212007,647,679
CSCH74_1_1,12007,3,32
CSCH74_1_1,207,299,777
I want the output as
GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num
CSCH74_1_1,2007,61,256... (1 Reply)
This is my input file :
# cat list 20130430121600, cucm, location,76,2 20130430121600,cucm1,location1,76,4 20130430122000,cucm,location,80,8 20130430122000,cucm1,location1,90,8 20130430140000,cucm1,location1,87,11 20130430140000, cucm,location,67,9
This is the required output
... (1 Reply)
Dear fellows, I need your help.
I'm trying to write a script to convert a single column into multiple rows.
But it need to recognize the beginning of the string and set it to its specific Column number.
Each Line (loop) begins with digit (RANGE).
At this moment it's kind of working, but it... (6 Replies)
Hi,
My input files is like this
axis1 0 1 10
axis2 0 1 5
axis1 1 2 -4
axis2 2 3 -3
axis1 3 4 5
axis2 3 4 -1
axis1 4 5 -6
axis2 4 5 1
Now, these are my following tasks
1. Print a first column for every two rows that has the same value followed by a string.
2. Match on the... (3 Replies)
I want to bring values in the second column into single line for uniq value in the first column.
My input
jvm01, Web 2.0 Feature Pack Library
jvm01, IBM WebSphere JAX-RS
jvm01, Custom01 Shared Library
jvm02, Web 2.0 Feature Pack Library
jvm02, IBM WebSphere JAX-RS
jvm03, Web 2.0 Feature... (10 Replies)
Hi all,
I have searched and searched, but I have not found a solution that quite fits what I am trying to do.
I have a long list of data in three columns. Below is a sample:
1,10,8
2,12,10
3,13,12
4,14,14
5,15,16
6,16,18
Please use code tags
What I need to do is as follows: If a... (4 Replies)
Discussion started by: bleedingturnip
4 Replies
LEARN ABOUT DEBIAN
pescetti
PESCETTI(1) General Commands Manual PESCETTI(1)NAME
pescetti -- Pseudo-Duplimate Generator
SYNOPSIS
pescetti
DESCRIPTION
This manual page documents briefly the pescetti command.
OPTIONS
Here are a list of the available options and what they do. You must specify exactly one from --demo, --generate or --load.
--help Prints the help text
--demo Demonstration mode. Generates one hand with permutations and the tutorial for how to use them.
--generate=N
Generate N random boards
--load=boards.txt
Load boards+analysis from boards.txt
--load-dds=boards.dds
Load boards from boards.dds in dds format
--load-analysis=tricks.txt
Load analysis from tricks.txt
--permutations=permutations.txt
Generate the permutations and save them to the given file
--curtains=curtains.txt
Save curtain cards to file curtains.txt
--save=boards.txt
Save the boards+analysis to boards.txt
--save-dds=boards.dds
Save the boards to boards.dds in dds format
--save-analysis=tricks.txt
Save the analysis to tricks.txt
--format=html|txt|pdf
Set the output mode to the given format
--title=title
Set the title for the output
--output=hands.txt
Print the hands to hands.txt, rather than to standard output
--stats Generate statistics about the set of boards; included in the hands output
--analyze Run the dds analyzer on the boards and print the resulting numberof tricks (warning SLOW)
--criteria=
A list of criteria to apply to each generated hand to generate specific hand types. The list should be space separated and each
item may be suffixed with a colon and a (fractional) probability value which can be used to weight the criteria.
E.g. --criteria="weaknt:0.8 strongnt:0.5"
Valid criteria are: unbalanced weaknt strongnt twont strongtwo weaktwo three twoclubs 4441 singlesuit twosuits partscore game
slam game-invite slam-invite jumpshift jumpfit splinter bacon weird
--probability=factor
Generate hands matching the criteria with only the given probability. Factor is in the range 0 to 1. On each attempt to generate
a board it is rejected if it doesn't match the criteria with the given probability. A factor of about 0.8 gives roughly half
matching boards
AUTHOR
This manual page was written by Matthew Johnson <debian@matthew.ath.cx>. Permission is granted to copy, distribute and/or modify this docu-
ment under the terms of the GNU General Public License, Version 2 as published by the Free Software Foundation.
On Debian systems, the complete text of the GNU General Public License can be found in /usr/share/common-licenses/GPL.
PESCETTI(1)