UNIX for Advanced & Expert Users

Hi ctsgnb,

Please let me know any update on this!!!!

Thanks
Wintech

Perl, ok?

Code:

perl -ane '$x{$F[0]}+=$F[1]; $y{$F[0]}+=$F[2]; END {for(sort keys %x){print "$_ $x{$_} $y{$_}\n"}}' inputfile

@jpachar

Please open a new thread (not a new post...)

Thanks

---------- Post updated at 08:59 PM ---------- Previous update was at 08:54 PM ----------

@Paulwintech

1. upload your input file
2. please copy paste exactly the command you have tried

Thanks in advance

Hi balajesuri,

Thank you so much it works fine........ Can you please let me know how remove double/triple space between columns in a file. As per forum advice i used
sed 's/ */ /g' filemanyspaced >filesinglespacedcommand, but no luck... Can you please help on this.

Regards
Paulwintech

Code:

 
$ cat one.txt
Can you    please    let me     know 
how     remove double/triple       space 
    between    columns in a    file

 
$ perl -lane '$_=~s/\s+/ /g;print $_' one.txt
Can you please let me know 
how remove double/triple space 
 between columns in a file

@Paulwintech: Try this: sed 's/[ ][ ]*/ /g'

Hi itkamaraj,

Below is my sample file. C1 contains double space and c2 contains triple space. I have four files and in each files i have 100 lines.

Prd C1 C2
bcbg 27 20
blazer 34 30
blazer 41 35
boots 69 57
boots 70 63
converse 28 27
converse 32 25
dolce%20vita 47 42
dolce%20vita 51 44
dresses 22 13
dresses 40 38
dresses 46 35
Ella%20moss 26 22
flats 23 17
flats 24 20
free%20people 43 40
free%20people 54 47
frye 109 97
frye 122 103
frye 29 26
handbags 27 20

Regards
Wintech