Multidimensional array:awk error


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Multidimensional array:awk error
# 8  
Old 12-07-2017
Assuming your col-1 and col-2 are the same, this worked for me with your example data with hard-coded tab and format %4.4f, which need be changed according to your real data:
Code:
awk -v OFS="\t" '{for (i=3; i<=NF; i++) A[$2][i]+=$i} END{for(k in A) { printf("%s\t%s\t", k, k); for (j=3; j<=NF; j++) {printf("%4.4f\t",  A[k][j])}; printf("\n")}}' infile.dat


Last edited by yifangt; 12-07-2017 at 03:03 PM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort multidimensional Array

Hello I have a problem. I create a Multidimensional Array Like this: ENTRY="$kunnum-$host" ENTRY="$host" ENTRY="# $3" for key in "${!ENTRY}"; do ENTRIES=${ENTRY} # INDEX=IP(5) donedeclare -p declare -A ENTRIES=(="unas15533" ="unas" ="# RDP-Terminal 2"... (12 Replies)
Discussion started by: Marti95
12 Replies

2. Shell Programming and Scripting

Multidimensional array

I am learning about bash system variables, such as $ , @ and #. I have this piece of script implementing an array and it is doing its job just fine. This is not the only array I will be using. Just for ease of maintenance and more coding I would like to have the arrays in two dimensional... (4 Replies)
Discussion started by: annacreek
4 Replies

3. Shell Programming and Scripting

How to deal with multidimensional array in awk?

Hi all! I would like to know how to print $0 when using multidimensional array like below time being I am using for loop to print columns like this awk 'FNR==1{i++} {for(k=1;k<=NF;k++)A=$k} END{for(j=1;j<=25;j++) print A,A,A,A,A,A,A,A,A,A,A,A,A,A}' file1 file2 so here my problem is I... (5 Replies)
Discussion started by: Akshay Hegde
5 Replies

4. Shell Programming and Scripting

gawk - How to loop through multidimensional array?

I have an awk script that I am writing and I needed to make use of a multidimensional array to hold some data... Which is all fine but I need to loop through that array now and I have no idea how to do that. for a regular array, the following works: ARRAY for(var in ARRAY) { ... } ... (5 Replies)
Discussion started by: trey85stang
5 Replies

5. Shell Programming and Scripting

multidimensional array in awk

Hi, I was trying to process a file with the help of awk. I want to first display all the rows that contains 01 and at the end of processing I have to print some portion of all the lines. like below. Output expected: (2 Replies)
Discussion started by: ahmedwaseem2000
2 Replies

6. Programming

multidimensional array using c++ vector

Hi! I need to make dynamic multidimensional arrays using the vector class. I found in this page How to dynamically create a two dimensional array? - Microsoft: Visual C++ FAQ - Tek-Tips the way to do it in 2D, and now i'm trying to expand it to 3D but i don't understand how is the operator working,... (0 Replies)
Discussion started by: carl.alv
0 Replies

7. Programming

C programming working with multidimensional array

Hi, I have the following variable declaration which looks like a 3d array or N matrixs KxK of floats float (*table); I have to pass to a function only the first table. How can I do it?? Thanks (6 Replies)
Discussion started by: littleboyblu
6 Replies

8. Shell Programming and Scripting

AWK multidimensional array

In a single dim. awk array, we can use : <index> in <array name> to determine whether a particualar index exists in the array or not. Is there a way to achieve this in a awk multi dim. array ? (4 Replies)
Discussion started by: sinpeak
4 Replies

9. Shell Programming and Scripting

Awk multidimensional Array

Hello Experts,, Can anybody give me a brief idea what is following bold letter statement is for!! what is the term called so that I can google for it.. It seems to be an array inside another array.. awk' /TXADDR/ { txaddr=$NF } ##understood /TXDATA/ { txdata]=$NF... (1 Reply)
Discussion started by: user_prady
1 Replies

10. Shell Programming and Scripting

multidimensional array in perl

i'm trying to open a file with three or more columns and an undetermined, but finite number of rows. I want to define an array for each row with each element of the row as a sub array. The columns are separated by tabs or spaces. Here's the file: 12x3.12z34b.342sd3.sds 454.23.23.232 ... (9 Replies)
Discussion started by: prkfriryce
9 Replies
Login or Register to Ask a Question
LOCALE_GET_ALL_VARIANTS(3)						 1						LOCALE_GET_ALL_VARIANTS(3)

Locale::getAllVariants - Gets the variants for the input locale

	Object oriented style

SYNOPSIS
publicstatic array Locale::getAllVariants (string $locale) DESCRIPTION
Procedural style array locale_get_all_variants (string $locale) Gets the variants for the input locale PARAMETERS
o $locale - The locale to extract the variants from RETURN VALUES
The array containing the list of all variants subtag for the locale or NULL if not present EXAMPLES
Example #1 locale_get_all_variants(3) example <?php $arr = locale_get_all_variants('sl_IT_NEDIS_ROJAZ_1901'); var_export( $arr ); ?> Example #2 OO example <?php $arr = Locale::getAllVariants('sl_IT_NEDIS_ROJAZ_1901'); var_export( $arr ); ?> The above example will output: array ( 0 => 'NEDIS', 1 => 'ROJAZ', 2 => '1901', ) SEE ALSO
locale_get_primary_language(3), locale_get_script(3), locale_get_region(3). PHP Documentation Group LOCALE_GET_ALL_VARIANTS(3)