Search Results

I see my mistake. Thanks !

Your code works. Thanks !
But I would like to understand why mine does not. It seems fine to me...

Hi,

My input looks like this (tab-delimited):
grp1 name2 firstname M 55 item1 item1.0
grp1 name2 firstname F 55 item1 item1.0
grp2 name1 firstname M 55 item1 item1.0...

Brilliant !

However, although I think I understand the following lines, I cannot place them in the context:
# When reading the input file for the first time, create an array based on $1 for which...

Hi,

Let's say I have a pipe-separated input like so:
name_10|A|BCCC|cat_1
name_11|B|DE|cat_2
name_10|A|BC|cat_3
name_11|B|DEEEEEE|cat_4

Using awk, for records with common field 2, I am...

Works great ! Thanks !

Hi,

A beginner one.

my input.tab (tab-separated):
h1 h2 h3 h4 h5
item1 grpA 2 3 customer1
item2 grpB 4 6 customer1
item3 grpA 5 9 customer1
item4 grpA 0 0 customer2...

Very good point !
I got it now, thanks !

I don't understand this statement. Both solutions seem to work just fine.
Is one more prone to errors than the other?

Hi,

My input looks like that:
A|123|qwer
A|456|tyui
A|456|wsxe
B|789|dfgh

Using awk, I am trying to get:
A|123;456|qwer;tyui;wsxe
B|789|dfgh
For records with same $1, group all the $2 in...

Hi,

I noticed a weird behaviour with awk.

input:
A|B|1-100|blabla_35_40_blabla;blabla_53_60_blabla;blabla_90_110_blabla

Objective:
For each string separated by ';' in $4, if the first and...

Sorry, I am stupid...

No "_" between "@" and "val"

Sorry again

Note: I had to upgrade gawk to version 4 to get PROCINFO working

Hi,

PROCINFO seems to be a great function but I don't manage to make it works.

input:
B,A,C
B
B,B

As an example, just want to count the occurence of each letter across the input and sort...

Very useful information. Thanks !

I did not know the 'delete' function. It's great !

I did not know neither the form '!count[b[i]]++' instead of 'count[b[i]]++==0'

Thanks !

Hi,

Sure it's an easy one, but it drives me insane.

input ("|" separated):
1|A,B,C,A
2|A,D,D
3|A,B,B

I would like to count the occurence of each capital letters in $2 across the entire...

Thanks RudiC,

However I should have insisted on the second criteria ("$3 of file2 is present in $2 of file1"). Meaning that I am not looking for an exact match.

For example if file1.tab is:...

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,...

Thanks guys !
Everything works great !

Hi,

tab-separated input:
blabla_1 A,B,C,C
blabla_2 A,E,G
blabla_3 R,Q,A,B,C,R,Q

output:
blabla_1 3
blabla_2 3
blabla_3 5

After splitting $2 in an array, I am trying to store the number...

Thanks Don Cragun, this is brilliant !

Correct. This is a typo. My code should have been:
gawk 'BEGIN{FS=OFS="|"; start=2; end=5}{for(i=start; i<=end; i++){var=sprintf("%s%s",$i, i<end ? OFS : "\n")}; common[var] = common[var]...

Thanks for your help !

However, the point of my post was to use sprintf to store the identical fields in a variable ($2, $3, $4, $5 here). I need to use sprintf because in my real file there are...

Dear Unix Gurus,

input:
A|1|2|3|4|5
B|1|2|3|4|3
C|1|2|3|4|1
D|1|9|3|4|12

output:
A_(5);B(3);C(1)|1|2|3|4
D_(12)|1|9|3|4

Details:
If $2, $3, $3, $5 are identical, concatenate $1 and...

Alright. I understand. Thanks RudiC !