Generating all possible combinations of values in field 1 (awk) Post: 302905544

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Generating all possible combinations of values in field 1 (awk) Post 302905544 by RudiC on Thursday 12th of June 2014 05:53:29 AM

06-12-2014

Registered User

Quote:

Originally Posted by beca123456

. . . How could I managed to add more than 2 values (i.e. the entire powerset)???
. . .

... by adding more than 2 values ... You were on the right way. Just extending your code snippet:

Code:

awk     'BEGIN          {FS=OFS="|"}
                        {array_1[++a]=$1
                         array_2[++b]=$2}
         END            {for (i=1; i<=NR; i++) {
                           for (j=i+1; j<=(NR); j++) {
                                print array_1[i] "+" array_1[j] "|" array_2[i] + array_2[j] }}
                         for (i=1; i<=NR; i++) {
                           for (j=i+1; j<=(NR); j++) {
                             for (k=j+1; k<=(NR); k++) {
                                print array_1[i] "+" array_1[j] "+" array_1[k] "|" array_2[i] + array_2[j] + array_2[k] }}}
                         print array_1[1] "+" array_1[2] "+" array_1[3] "+" array_1[4] "|" array_2[1] + array_2[2] + array_2[3] + array_2[4]
                        }
        ' file
A+B|3
A+C|4
A+D|5
B+C|5
B+D|6
C+D|7
A+B+C|6
A+B+D|7
A+C+D|8
B+C+D|9
A+B+C+D|10

RudiC

View Public Profile for RudiC

Find all posts by RudiC

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Awk search for max and min field values

hi, i have an awk script and I managed to figure out how to search the max value but Im having difficulty in searching for the min field value. BEGIN {FS=","; max=0} NF == 7 {if (max < $6) max = $6;} END { print man, min} where $6 is the column of a field separated by a comma

2. Shell Programming and Scripting

Generating Combinations

Hi, I need to generate all combinations upto n-1 level, if the input file looks like say, A B C D . . .... I need to generate all combinations such that first value remains constant and the remaning are combined with all possible ways. Output A AB AC AD ABC

3. Shell Programming and Scripting

counting lines containing two column field values with awk

Hello everybody, I'm trying to count the number of consecutive lines in a text file which have two distinctive column field values. These lines may appear in several line blocks within the file, but I only want a single block to be counted. This was my first approach to tackle the problem (I'm...

4. Shell Programming and Scripting

AWK: combining consecutive values in a field

Hi, Here is my sample input X 2 AAA Y 3 BBB Y 2 CCC Z 4 DDD In field 1, if the value of one line is same as that of next line, I want to concatenate the corresponding value of the second line in the third field with the value of the third field of first line. And I dont need the third...

5. Shell Programming and Scripting

SED/AWK to edit/add field values in a record

Hi Experts, I am new to shell scripting. Need some help in doing one task given by the customer. The sample record in a file is as follows: 3538,,,,,,ID,ID1,,,,,,,,,,, It needs to be the following: 3538,,353800,353800,,,ID,ID1,,,,,COLX,,,,,COLY, And i want to modify this record in...

6. Shell Programming and Scripting

Putting values into order in a field using awk

Hi, I am using UBUNTU 12.04. I have a dataset as follows: Column#1 Column#2 Column#3 .... Column#50 1 154878 1 145145 2 189565 2 454121 ...

7. Shell Programming and Scripting

Nawk One Liner to Count Field Combinations

I have text files, fields separated by commas, and there are 115 fields. I need to use nawk to look at each line, if field $4==10, then count how many times the combination of field $5 and field $11 occur in the file. I tried the following: nawk -F, '{if($4==10){tg++;cd++,tgcd++}}END{for(i in...

8. Shell Programming and Scripting

awk help - matching a field with certail values

Hello there, I have a file with few fields separated by ":". I wrote a below awk to manipulate this file: awk 'BEGIN { FS=OFS=":" }\ NR != 1 && $2 !~ /^98/ && $8 !~ /^6/{print $0}' $in_file > $out_file What I wanted was that if $8 field contains any of the values - 6100, 6110, 6200 -...

9. UNIX for Dummies Questions & Answers

Values with common field in same line with awk

Hi all ! I almost did it but got a small problem. input: cars red cars blue cars green truck black Wanted: cars red-blue-green truck black Attempt: gawk 'BEGIN{FS="\t"}{a = a (a?"-":"")$2; $2=a; print $1 FS $2}' input But I also got the intermediate records...

10. Shell Programming and Scripting

Insert field values in a record using awk command

Hi Friends, Below is my input file with "|" (pipe) as filed delimiter: My Input File: HDR|F1|F2||||F6|F7 I want to inser values in the record for field 4 and field 5. Expected output HDR|F1|F2||F4|F5|F6|F7 I am able to append the string to the end of the record, but not in between the...

LEARN ABOUT SUSE

end

END(7)								   SQL Commands 							    END(7)

NAME

       END - commit the current transaction

SYNOPSIS

       END [ WORK | TRANSACTION ]

DESCRIPTION

       END  commits  the  current  transaction. All changes made by the transaction become visible to others and are guaranteed to be durable if a
       crash occurs. This command is a PostgreSQL extension that is equivalent to COMMIT [commit(7)].

PARAMETERS

       WORK

       TRANSACTION
	      Optional key words. They have no effect.

NOTES

       Use ROLLBACK [rollback(7)] to abort a transaction.

       Issuing END when not inside a transaction does no harm, but it will provoke a warning message.

EXAMPLES

       To commit the current transaction and make all changes permanent:

       END;

COMPATIBILITY

       END is a PostgreSQL extension that provides functionality equivalent to COMMIT [commit(7)], which is specified in the SQL standard.

SEE ALSO

       BEGIN [begin(7)], COMMIT [commit(7)], ROLLBACK [rollback(7)]

SQL - Language Statements					    2010-05-14								    END(7)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Awk search for max and min field values

Discussion started by: Kirichiko

2. Shell Programming and Scripting

Generating Combinations

Discussion started by: zorg4u

3. Shell Programming and Scripting

counting lines containing two column field values with awk

Discussion started by: origamisven

4. Shell Programming and Scripting

AWK: combining consecutive values in a field

Discussion started by: polsum

5. Shell Programming and Scripting

SED/AWK to edit/add field values in a record

Discussion started by: sugarcane

6. Shell Programming and Scripting

Putting values into order in a field using awk

Discussion started by: Homa

7. Shell Programming and Scripting

Nawk One Liner to Count Field Combinations

Discussion started by: he204035