Sort multidimensional Array


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Sort multidimensional Array
# 8  
Old 03-07-2019
Quote:
Originally Posted by RudiC
Does reversing a sort key help?
Code:
$ IFS=$'\n'
$ echo "${!ENTRIES[*]}" | sort -t, -k1,1n -k2r | while read IX; do printf "%-15s%-15s\n" $IX ${ENTRIES[$IX]}; done
205,IP         111.122.133.20 
205,HOST2      unas           
205,HOST1      unas15533      
205,COMMENT    # UNAS         
775,IP         111.122.133.77 
775,HOST2      wlan           
775,HOST1      15533-wlan     
775,COMMENT    # WLAN Access Point
1015,IP        111.122.133.101
1015,HOST2     rdp1           
1015,HOST1     15533-rdp1     
1015,COMMENT   # RDP-Terminal 1
1025,IP        111.122.133.102
1025,HOST2     rdp2           
1025,HOST1     15533-rdp2     
 1025,COMMENT   # RDP-Terminal 2

Don't forget to reset your IFS afterwards.


EDIT: or, even better to get HOST1 and 2 in the right order:

Code:
echo "${!ENTRIES[*]}" | sort -t, -k1,1n -k2,2.2r -k2.3 | while read IX; do printf "%-15s%-15s\n" $IX ${ENTRIES[$IX]}; done

Your method is not working, this is what i get back
Code:
414,IP         205,HOST1
205,HOST2      414,COMMENT
505,HOST2      505,IP
505,HOST1      1025,COMMENT
775,COMMENT    1015,IP
1025,IP        775,IP
505,COMMENT    205,COMMENT
410,IP         775,HOST1
1015,HOST2     1015,HOST1
775,HOST2      410,HOST1
1015,COMMENT   410,HOST2
414,HOST1      414,HOST2
1025,HOST2     1025,HOST1
410,COMMENT    205,IP

This methode from nezabudka even works better. this sorts my array correct
Code:
shuf -e ${!ENTRIES[@]} | sort -V | while read d; do echo $d=${ENTRIES[$d]}; done

my only problem is now how to get the this entrys in this output order
Code:
# IP - HOST1  - HOST2 - COMMENT

# 9  
Old 03-07-2019
Did you set the IFS variable as indicated?
Try the sort keys given with netzabudka's proposal as well.
This User Gave Thanks to RudiC For This Post:
# 10  
Old 03-07-2019
Quote:
Originally Posted by RudiC
Did you set the IFS variable as indicated?
Try the sort keys given with netzabudka's proposal as well.
Oh it was my fault. Its working of course as well. Thank you

So know i dont understand (my bash skills are very low) how to get this in a file line by line in this format
Code:
# IP - HOST1  - HOST2 - COMMENT

Like this
Code:
10.155.33.20              unas15533              unas      # Comment
10.155.33.101             15533-rdp1             rdp1      # Comment
10.155.33.102             15533-rdp2             rdp2      # Comment

I know how to create the file and how to write in it but i dont understand how i can use your funtion to geht this
# 11  
Old 03-07-2019
Try paste:
Code:
echo "${!ENTRIES[*]}" | sort -t, -k1,1n -k2,2.2r -k2.3 | while read IX; do printf "%s\n" ${ENTRIES[$IX]}; done | paste -sd"\t\t\t\n"
111.122.133.20     unas15533     unas    # UNAS
111.122.133.77     15533-wlan    wlan    # WLAN Access Point
111.122.133.101    15533-rdp1    rdp1    # RDP-Terminal 1
111.122.133.102    15533-rdp2    rdp2    # RDP-Terminal 2

Aside: How did you create those arrays? Mayhap all this messing around could be avoided, and your output correctly computed in the first place?

Last edited by RudiC; 03-07-2019 at 07:02 AM..
This User Gave Thanks to RudiC For This Post:
# 12  
Old 03-07-2019
Code:
shuf -e ${!ENTRIES[@]} | sort -t, -k1,1n -k2,2.2Vr |

--- Post updated at 14:02 ---

And so it works
sort -t, -k1,1n -k2,2.2r
This User Gave Thanks to nezabudka For This Post:
# 13  
Old 03-07-2019
Quote:
Originally Posted by RudiC
Try paste:
Code:
echo "${!ENTRIES[*]}" | sort -t, -k1,1n -k2,2.2r -k2.3 | while read IX; do printf "%s\n" ${ENTRIES[$IX]}; done | paste -sd"\t\t\t\n"
111.122.133.20     unas15533     unas    # UNAS
111.122.133.77     15533-wlan    wlan    # WLAN Access Point
111.122.133.101    15533-rdp1    rdp1    # RDP-Terminal 1
111.122.133.102    15533-rdp2    rdp2    # RDP-Terminal 2

Aside: How did you create those arrays? Mayhap all this messing around could be avoided, and your output correctly computed in the first place?
Thank you so much

This works perfect for me:
Code:
IFS=$'\n'
echo "${!ENTRIES[*]}" | sort -t, -k1,1n -k2,2.2r -k2.3 | while read IX; do printf "%-20s\n" ${ENTRIES[$IX]}; done | paste -sd"\t\t\t\n"

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

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

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

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

4. Programming

Multidimensional arrays and sort.

My language is C++. I have a multidimensional vector that I would like to sort by a specific "cell" or "field" within the main vector. Does anyone have any information on how to do this? I have searched all over the internet and every reference manual I can find. So far I have found very little to... (2 Replies)
Discussion started by: sepoto
2 Replies

5. Programming

Multidimensional array of strings with vector.

I've been struggling with this for quite some time. I decided I should get some help with this. Nothing is working. I'm getting a segmentation fault or out of bounds error when I try to load the entries in the for loop.I'm really frustrated. :mad: Compiling isn't the problem. It's crapping out on... (5 Replies)
Discussion started by: sepoto
5 Replies

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

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

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