Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Formatting Output from a file
Top Forums Shell Programming and Scripting Formatting Output from a file Post 302486523 by andylbh on Sunday 9th of January 2011 06:23:48 AM
Old 01-09-2011
Formatting Output from a file
Hi guys.
I'm new to Bash Programming.
I've a little problem here.

I have a text file, lets say data.txt, with the data:
Code:
John Tan:Male:20:Singapore
Mary:Female:23:Malaysia
Abdul Rahman Bin Ali:Male:30:India

(: is the delimiter)

I want to display it like this:
Code:
Name Gender Age Country
John Tan Male 20 Singapore
Mary Female 23 Malaysia
Abdul Rahman Bin Ali Male 30 India

I tried using cat data.txt | tr ":" "\t" , but the problem with that is when the name is too long, the formatting will be messed up. (like above)
How can I display the output nicely formatted, like as if they are in a table?
Can I do this using sed command?
Thanks in advance!
Last edited by Franklin52; 01-10-2011 at 10:27 AM.. Reason: Please use code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Formatting Output file

Hi, I have a file.... File1: Num Name ID Place ADDR City Country 1024|Name1|ID1|Street1|ADDR1|Boston|UK 1025|Name2|ID3|Street2|ADDR2|London|USA The above file is varaiable length file. I have to insert 2 values in every record of the above file. Output: ... (3 Replies)
Discussion started by: manneni prakash
3 Replies

2. Shell Programming and Scripting

Need help with formatting an output file

Hi guys, I need help with formatting the output of a file. Below is the script I use to generate a file called output.xls. DAY=`TZ=MYT+16 date '+%b'` DAY1=`TZ=MYT+16 date '+%e'` ls -ltr /bscswork_bi2/WORK/UMOBILE/IR/IN/ALL/PROCESSED | grep "$DAY $DAY1" | awk '{print $9}' | sort | cut -c3-7... (4 Replies)
Discussion started by: kumaran21
4 Replies

3. Shell Programming and Scripting

formatting output

my script is as follows cnt=`ps -ef |grep pmon|grep -v grep|awk 'END {{print NR}}'` cnt2=`ps -ef |grep tns|grep -v grep|awk 'END {{print NR}}'` if then if then rman target/ catalog recdb/recdb@recdb cmdfile report_need_backup.sql > report_need_backup.txt ... (1 Reply)
Discussion started by: swkambli
1 Replies

4. Shell Programming and Scripting

File output formatting

I have a file that list information about users and want to format the output into columns using Shell scripting. There are about 50 to 75 users. Example current file output fname lname address hiredate dept fname lname address hiredate dept Desired output fname ... (4 Replies)
Discussion started by: daveisme
4 Replies

5. Shell Programming and Scripting

Output formatting .

below is a CPU utilization Log for ABC server. However for every 15 minutes it generates 3 CPU values(with interval of 2 sec). Host CPU CPUtotal CPU% time ABC 101.1 2 50.55 14 : 15 ABC 100.5 2 50.25 14 : 15 ABC 100.2 2 50.1 14 : 15 ABC 100.9 2 50.45 14 : 30 ABC 100.5 2 50.25 14 : 30 ABC... (5 Replies)
Discussion started by: pinga123
5 Replies

6. Shell Programming and Scripting

Formatting output

Hi, I have a file like this -------------------------- 1 aaa xxx 55 -------------------------- 1 aaa www 32 -------------------------- 2 bbb yyy 11 -------------------------- 2 bbb zzz 34 ------------------------- 2 bbb ttt ... (3 Replies)
Discussion started by: tdev457
3 Replies

7. Shell Programming and Scripting

Formatting output

I have the output like below: DEV#: 9 DEVICE NAME: hdisk9 TYPE: 1750500 ALGORITHM: Load Balance SERIAL: 68173531021 ========================================================================== Path# Adapter/Path Name State Mode Select Errors 0 ... (4 Replies)
Discussion started by: Daniel Gate
4 Replies

8. Shell Programming and Scripting

Formatting the Output

Hi, I am trying to use printf command and format certain output in a specific format as under: While the left side (upto |) of the above format is part of a fixed header function, the right side is where i am expecting data to be printed. However, as seen, Row1 value is reflecting on last... (5 Replies)
Discussion started by: EmbedUX
5 Replies

9. Shell Programming and Scripting

Help needed in formatting the Output file

Hi All, Need your help in resolving the below issue. I've a file called "data.txt" with the below lines: TT: <tell://me/sreenivas> <tell://me/100> TT: <tell://me/sudheer> <tell://me/300> TT: <tell://me/sreenivas> <tell://me/200> TT: <tell://me/sudheer> <tell://me/400> ... (3 Replies)
Discussion started by: raosr020
3 Replies

10. Shell Programming and Scripting

Formatting File Decryption Output

Below is the out put of the decrypt command. Decrypt Command: /usr/bin/gpg --yes --batch --output file.xml --decrypt file.xml.gpg Output: gpg: encrypted with 2048-bit RSA key, ID 96301328, created 2014-04-29 "XYZ <xyz@abc.com>" gpg: encrypted with 2048-bit ELG-E key, ID ECB614CF,... (5 Replies)
Discussion started by: Ariean
5 Replies

LEARN ABOUT DEBIAN

html::formfu::element::radiogroup

HTML::FormFu::Element::Radiogroup(3pm)			User Contributed Perl Documentation		    HTML::FormFu::Element::Radiogroup(3pm)

NAME

       HTML::FormFu::Element::Radiogroup - Group of radiobutton form fields

SYNOPSIS

       YAML config:

	   ---
	   elements:
	     - type: Radiogroup
	       name: sex
	       options:
		 - [ 'm', 'Male' ]
		 - [ 'f', 'Female' ]

DESCRIPTION

       Convenient to use group of radio button fields.

       Use the same syntax as you would to create a Select element optgroup to create RadioGroup sub-groups, see "options" in
       HTML::FormFu::Element::_Group for details.

METHODS

   options
       See "options" in HTML::FormFu::Element::_Group.

   values
       See "values" in HTML::FormFu::Element::_Group.

   value_range
       See "value_range" in HTML::FormFu::Element::_Group.

   empty_first
       See "empty_first" in HTML::FormFu::Element::_Group.

   auto_id
       In addition to the substitutions documented by "auto_id" in HTML::FormFu, %c will be replaced by an incremented integer, to ensure there
       are no duplicated ID's.

	   ---
	   elements:
	     type: Radiogroup
	     name: foo
	     auto_id: "%n_%c"

   reverse_group
       See "reverse_group" in HTML::FormFu::Element::Checkboxgroup.

SEE ALSO

       Is a sub-class of, and inherits methods from HTML::FormFu::Element::Checkboxgroup, HTML::FormFu::Element::_Group,
       HTML::FormFu::Element::_Field, HTML::FormFu::Element

       HTML::FormFu

AUTHOR

       Carl Franks, "cfranks@cpan.org"

LICENSE

       This library is free software, you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2012-01-23				    HTML::FormFu::Element::Radiogroup(3pm)
All times are GMT -4. The time now is 09:01 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy