Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Organize of Data

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Organize of Data
# 1  
Old 06-08-2010
Organize of Data
Hello Expert,

I am new in awk. I would like to know how to arrange data like

Input File:
Code:
lpar1
1
2
3
4
5
6
lpar10
4
5
6
lpar3
4
5
10
1
22
lpar9
10
20
40

Output File :
Code:
      lpar1   
  lpar10   
  lpar3   
  lpar9       1   
  4   
  4   
  10       2   
  5   
  5   
  20       3   
  6   
  10   
  40       4   
  
  
  1   
  
      5   
  
  
  22   
  
      6






Thanks in advance

---------- Post updated at 01:14 PM ---------- Previous update was at 01:13 PM ----------

output file is incorrect it should be like

Code:
lpar1      lpar2......so on
1            3
2            4

Last edited by Franklin52; 06-08-2010 at 07:18 AM.. Reason: Please use code tags!
# 2  
Old 06-08-2010
Use gawk, /usr/xpg4/bin/awk or nawk on Solaris:


Code:
awk 'END {
  for (j = 0; ++j <= O;)
    printf "%s", o[j] (j < O ? OFS : RS)
  while (++i <= m) 
    for (j = 0; ++j <= O;) 
      printf "%s", d[i, o[j]] (j < O ? OFS : RS)
  }
/lpar/ { 
  c > m && m = c; c = x 
  k = $1; o[++O] = k; next 
  }
{ 
  c++; d[c, k] = $1 
  }' OFS='\t' infile

Note that the original order of the lpars is preserved in the output.
Let me know if you want a different one.
This User Gave Thanks to radoulov For This Post:
shah09
# 3  
Old 06-08-2010
Thanks a lot...its working .....
# 4  
Old 06-08-2010
Smilie radoulov Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Organize output with awk

Hello, maybe someone could help me with this. I'm trying to print in a more ordered way this input. the input file is: AB XY UT ZW PRAT 0 3 4 7214800 93 0 3 4 730770 ... (8 Replies)
Discussion started by: Ophiuchus
8 Replies

2. Shell Programming and Scripting

Is there a way to organize bash_profile across different platforms

I want to have one .bash_profile works on multiple platform, ubuntu, debian, redhat, cygwin, osx. So how should I organize .bash_profile? It can be multiple files in some subdir Let me brief you: what i want is a way to organize bash_profile across platforms so I can use one set of profiles... (2 Replies)
Discussion started by: John_Peter
2 Replies

3. Shell Programming and Scripting

Discover unique names and organize

I'm attempting to write a script that will look into a directory, discover all unique names, create directories for their prefix names and place the files inside. I do this now one by one with a simple script but I'd like to automate the process. The directory would contain something like: ... (6 Replies)
Discussion started by: scribling
6 Replies

4. Shell Programming and Scripting

Organize file according to their extension

Hi Everyone ! i want to make an application which is written in shell script and in Bourne shell (sh) i want, when my script is executed, it read all the files in the directly and move them to folders according to their extension. suppose i have a files: test.txt test.jpg test.docx... (1 Reply)
Discussion started by: me_newbie
1 Replies

5. Shell Programming and Scripting

Help with re-organize data by adding "-" in empty place

Input file data_1 data_2 A B C data_1 data_2 B D data_1 data_2 A C data_1 data_2 A data_1 data_2 B C data_1 data_2 C data_1 data_2 A B data_1 data_2 data_1 data_2 C B A . . Output file data_1 data_2 A B C data_1 data_2 - B D data_1 data_2 A - C (3 Replies)
Discussion started by: perl_beginner
3 Replies

6. Shell Programming and Scripting

need help for a script to organize data

Hey all, I have a file with info like this 12:05:44 DEV001 (15F6) 71 5 1372 131 58 100 6 0 17 DEV002 (15FA) 60 0 928 15 50 N/A 2 N/A 5 DEV003 (15FE) 77 2 961 59 51 100 1 0 2... (2 Replies)
Discussion started by: leo.maveriick
2 Replies

7. UNIX and Linux Applications

Organize (pretty) code

I'm looking for terminal programs, which organize and pretty code like HTML or JavaScript. Thanks! ---------- Post updated at 07:01 AM ---------- Previous update was at 01:49 AM ---------- Found this Online javascript beautifier (1 Reply)
Discussion started by: borobudur
1 Replies

8. Shell Programming and Scripting

how organize my log file ( tabs )

hello i have written a multitask script which performs verifications on the server (RHEL 5 tikanga); based on list of rules. since the results are huge both in length and number and I am sending them all to my log file. Is there any method to organize the STATUS of my results in a defined... (1 Reply)
Discussion started by: goswami.c
1 Replies

9. Shell Programming and Scripting

looking for a simple way to organize envs on our unix box...

would like to standardize how we set envs on our unix box, so I thought a menu would be a great way to accomplish this. The problem I'm experiencing, is the value is set...but ONLY during the time the menu is initiated. please see below: > /home/is/bin/r12MENU.sh ... (2 Replies)
Discussion started by: mr_manny
2 Replies

10. UNIX for Dummies Questions & Answers

How do I organize a series of files in date order?

I'd like to ls a group of files in date order but I'm not sure what the commands would be. Can anyone help with this? (1 Reply)
Discussion started by: hedgehog001
1 Replies
Login or Register to Ask a Question