Summary using awk Post: 302386911

Sponsored Content

Top Forums Shell Programming and Scripting Summary using awk Post 302386911 by gregarion on Thursday 14th of January 2010 04:36:02 AM

01-14-2010

Registered User

Summary using awk

Displaying information using awk
Hey guys, i am using awk to display my information in a certain order.

Database :

Code:

 Persia:42:John
France:50:Mabel 
Persia:50:Rach
Germany:60:John

My expected output is :

Code:

Code:

Title             Price           Author
Persia             42              John
France             50              Mabel
Persia             50              Rach
Germany            60              John

So i first tried using awk command which goes like this :
Code:

Code:

Title=$(awk -F":" '{printf"\n" $1 }' fruit)
       Price=$(awk -F":" '{printf"\n" $2 }' fruit)
       Author=$(awk -F":" '{printf"\n" $3 }' fruit)

Reason being, i was thinking by arranging the variables under the each Columm name such as Title, Price and Author, it will arrange itself neatly. Let me show u what i meant.

Code:

Code:

echo  Title             Price           Author
echo  $Title             $Price          $Author

but for some reason, when i save the results in a variable, the formatting will be gone, instead of displaying the information in a neat columm, it displays the information on one line like the example below :

Code:

Code:

Title             Price           Author
PersiaFrancePersiaGermany

I tried using cut command but it also gives me the same problem. If i do not assign it to a variable, how am i able to format it to display it in the correct format?

gregarion

View Public Profile for gregarion

Find all posts by gregarion

6 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

System Summary Tools

Are there any system sumary tools for Linux? What are some good ones for Solaris and HP-Ux?

2. UNIX for Dummies Questions & Answers

Directory Summary Command

Is there a unix command to provides the number of files in a directory?

3. Shell Programming and Scripting

summary line help

$ cat file a:12:56:12 b:23:12:23 d:32:24:12 c:90:12:24 required output: a:12:56:12 b:23:12:23 d:32:24:12 c:90:12:24 t:157:104:71 t line is the total line, which will be the last line in the output. Please help. I tried this:

4. Shell Programming and Scripting

Using awk to create a summary of a structured file

I am trying to use awk to create a summary of a structured file. Here is what it looks like: (random text) H1 H2 H3 H4 44 78 99 30 31 -- 32 21 12 33 55 21 I'd like to be able to specify a column, say H2, and then have information about that column printed. ...

5. Shell Programming and Scripting

Generating summary data (use awk?)

I have a data file similar to this (but many millions of lines long). You can assume that it is totally unsorted but has no duplicate rows. Date ,Tool_Type ,Tool_ID ,Time_Used 3/13/2014,Screwdriver,Screwdriver02, 6 3/13/2014,Screwdriver,Screwdriver02,20...

6. Shell Programming and Scripting

Files summary using awk based on index key

Hello , I have several files which are looking similar to : file01.txt keyA001 350 X string001 value001 keyA001 450 X string002 value007 keyA001 454 X string002 value004 keyA001 500 X string003 value005 keyA001 255 X string004 value006 keyA001 388 X string005 value008 keyA001 1278 X...

LEARN ABOUT SUSE

igawk

IGAWK(1)							 Utility Commands							  IGAWK(1)

NAME

       igawk - gawk with include files

SYNOPSIS

       igawk [ all gawk options ] -f program-file [ -- ] file ...
       igawk [ all gawk options ] [ -- ] program-text file ...

DESCRIPTION

       Igawk is a simple shell script that adds the ability to have ``include files'' to gawk(1).

       AWK programs for igawk are the same as for gawk, except that, in addition, you may have lines like

	      @include getopt.awk

       in your program to include the file getopt.awk from either the current directory or one of the other directories in the search path.

OPTIONS

       See gawk(1) for a full description of the AWK language and the options that gawk supports.

EXAMPLES

       cat << EOF > test.awk
       @include getopt.awk

       BEGIN {
	    while (getopt(ARGC, ARGV, "am:q") != -1)
		 ...
       }
       EOF

       igawk -f test.awk

SEE ALSO

       gawk(1)

       Effective AWK Programming, Edition 1.0, published by the Free Software Foundation, 1995.

AUTHOR

       Arnold Robbins (arnold@skeeve.com).

Free Software Foundation					    Nov 3 1999								  IGAWK(1)

6 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

System Summary Tools

Discussion started by: vader

2. UNIX for Dummies Questions & Answers

Directory Summary Command

Discussion started by: rbarlow

3. Shell Programming and Scripting

summary line help

Discussion started by: uwork72

4. Shell Programming and Scripting

Using awk to create a summary of a structured file

Discussion started by: afulldevnull

5. Shell Programming and Scripting

Generating summary data (use awk?)

Discussion started by: Michael Stora

6. Shell Programming and Scripting

Files summary using awk based on index key

Discussion started by: alex2005

LEARN ABOUT SUSE

igawk