OraFAQ Forum: Unix » Problem with AWK in formating the data

Home » Infrastructure » Unix » Problem with AWK in formating the data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with AWK in formating the data [message #140975]

Thu, 06 October 2005 08:03

rajus19
Messages: 18
Registered: September 2005

Junior Member

Hi All,

I am using "awk" command to find the sum of the sal for all the emps. The emp data is available in a flat file (in_file). The sal field is from the 21st to 32nd character (right justified with Zeros).

I am using the below command to find the tatal sal, but its not giving the output in proper format.

total=`awk '{(tot_sal=tot_sal+ substr($0,21,12))} END {print tot_sal}' ${in_file}`

Your help will be greatly appreciated.

Thanks
Raju

Report message to a moderator

Re: Problem with AWK in formating the data [message #140987 is a reply to message #140975]

Thu, 06 October 2005 08:41

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

Use printf "%.12d\n", tot_sal

Best regards.

Frank

Report message to a moderator

Re: Problem with AWK in formating the data [message #141006 is a reply to message #140987]

Thu, 06 October 2005 10:24

rajus19
Messages: 18
Registered: September 2005

Junior Member

Thanks Frank,

Could you please help me how to display the output in the format of right justified with spaces using awk.

Thanks
Raju

Report message to a moderator

Re: Problem with AWK in formating the data [message #141175 is a reply to message #141006]

Fri, 07 October 2005 06:37

Frank Naude
Messages: 4581
Registered: April 1998

Senior Member

I haven't tested it, but printf()'s output should be right-justified, unless you place a minus sign right after the % sign.

Best regards.

Frank

Report message to a moderator

Re: Problem with AWK in formating the data [message #141177 is a reply to message #141175]

Fri, 07 October 2005 06:43

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

just one more thing to add,

this printf() follows C-language formatting so get any book on C language and look into the formatting .

Report message to a moderator

Re: Problem with AWK in formating the data [message #141203 is a reply to message #140975]

Fri, 07 October 2005 08:34

rajus19
Messages: 18
Registered: September 2005

Junior Member

Thank You very much Guys.

Regards,
Raju

Report message to a moderator

Previous Topic:	Blank Space problem in unix
Next Topic:	DISPLAY setting for Oracle 9.2.0.6.0 on SunOs 5.8

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 19:37:04 CST 2024