Sponsored Content
Top Forums Shell Programming and Scripting Convert data to a tabular format Post 302843522 by lazydev on Tuesday 13th of August 2013 03:29:25 PM
Old 08-13-2013
Convert data to a tabular format

How can i convert the below data to a simpler format :-

Code:
 
cat tabular.txt
 
User 1 Details :-
First Name = Tom
Middle Name =
Last Name = Hanks
Age = 40
Address =
User 2 details :-
 
First Name = Mike
Middle Name =
Last Name = Tyson
Age = 50
Address =

Want to display the output as :-

Code:
 
First Name Middle Name Last Name Age 
Tom                           Hanks       40 
Mike                           Tyson       50

Moderator's Comments:
Mod Comment quote tags != code tags

Last edited by DukeNuke2; 08-13-2013 at 04:37 PM.. Reason: changed quote to code tags
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

converting a tabular format data to comma seperated data in KSH

Hi, Could anyone help me in changing a tabular format output to comma seperated file pls in K-sh. Its very urgent. E.g : username empid ------------------------ sri 123 to username,empid sri,123 Thanks, Hema:confused: (2 Replies)
Discussion started by: Hemamalini
2 Replies

2. Shell Programming and Scripting

Convert array data to excel format

I need your help in changing the script I have data has below text file :> cat my_emp Employee array(0) Name : Albert No : 1234 Address: stationstraat City: Utrecht Employee array (1) Name : Kouwen No : 1256 Address: stationstraat City: Amsterdam Employee array (2) Name : Peter... (2 Replies)
Discussion started by: LinuxLearner
2 Replies

3. Shell Programming and Scripting

Displaying output in the tabular format

Hi I want to display the following input data into the tabular format as shown in the output. Input.txt: Following jobs are in pending state for more than 10 minutes: JOB_ID JOB_SUBMIT_ID MAHAR 784308 PUNJA 109367 Following jobs are running for longer time: JOB_ID... (1 Reply)
Discussion started by: dats
1 Replies

4. Shell Programming and Scripting

Generate tabular data based on a column value from an existing data file

Hi, I have a data file with : 01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083 I... (1 Reply)
Discussion started by: himanish
1 Replies

5. Shell Programming and Scripting

Extract data in tabular format from multiple files

Hi, I have directory with multiple files from which i need to extract portion of specif lines and insert it in a new file, the new file will contain a separate columns for each file data. Example: I need to extract Value_1 & Value_3 from all files and insert in output file as below: ... (2 Replies)
Discussion started by: belalr
2 Replies

6. Shell Programming and Scripting

Convert text file to HTML tabular format.

Please provide script/commands to convert text file to HTML tabular format. No need of styles and colours, just output and a heading in table is required. Output file will be send via email and will be seen from outlook. (script required without using awk). output file content: (sar... (7 Replies)
Discussion started by: Veera_V
7 Replies

7. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies

8. Shell Programming and Scripting

Convert data into tabular matrix

Hi There, I want to convert the following data into tabular matrix, based on column 4th and 5th, and output the column 10th value chr1 2804449 2804450 NACpG_1 window1 + chr1 2804443 2804475 1 chr1 2804450 2804451 NACpG_1 window2 + chr1 2804443 ... (3 Replies)
Discussion started by: ChiragNepal
3 Replies

9. Shell Programming and Scripting

Convert csv data to html format

I am new to html and need to convert the attached csv file data to html format ; running into issues. please assist. #!/bin/ksh echo "<html>" ; echo "<head><style> table {border-collapse: collapse;} table, td, th {border: 1px solid black;} </style></head>" echo "<title> REPORT </title>" echo... (0 Replies)
Discussion started by: archana25
0 Replies

10. Shell Programming and Scripting

To have a mail in tabular format

Hello Guys, developing a monitoring shell script to have my queue depth count over mail . here is the sample input file to the script which has all the queue names 1 : DISPLAY QUEUE(*) WHERE (CURDEPTH GT 0) ZFC8409: Display Queue details. QUEUE(QL.GVR.ATA.CACHE.01) ... (10 Replies)
Discussion started by: wims
10 Replies
LES(8)							       Maintenance Commands							    LES(8)

NAME
les, bus - ATM LAN Emulation service demons SYNOPSIS
les [-d module] [-m module] [-f configuration_file] bus [-d module] [-m module] [-f configuration_file] DESCRIPTION
LE Service consists of three components: LAN Emulation Configuration Server (lecs(8)), LAN Emulation Server (les) and Broadcast and Unknown Server (bus). Les performs the control coordination function for the emulated LAN. LE clients register MAC addresses and/or route descriptors they rep- resent to les, and later query it when they want to resolve MAC addresses/route descriptors into ATM addresses. Other LE control messages which are to be distributed to every client in ELAN are also sent to les. Les forwards these messages using Control Distribute VCC which it has set up to every client in ELAN. Bus handles data sent by clients to broadcast and multicast MAC addresses and some of the data directed to unicast addresses. LE Client has a possibility to send data directed to some unicast address to the bus before target's ATM address has been resolved and the Data Direct VCC has been established. Configuration file example for les and bus: [main] memdebug=True debug=True [load] #memdebug=True #debug=True [conn] debug=True #S1, LE Server's ATM address #S1=:47:00:23:00:00:00:03:00:00:01:00:02:01:00:20:ea:00:05:aa:00 S1=:47:00:23:00:00:00:03:03:00:01:00:02:01:00:20:ea:00:0a:e9:01 #S2, LAN Type S2="802.3" #S3, Maximum Frame Size S3=1516 #S4, Join Timeout, s S4=15 #S5, Maximum Frame Age, s S5=6 #S6, BUS Atm address S6=:47:00:23:00:00:00:03:03:00:01:00:02:01:00:20:ea:00:0a:e9:02 #viulu #S6=0,0,170 #ELANNAME="asdf" The configuration file contains each modules name in brackets followed by variable definitions for that module. The definitions are of form variable=value, where value can be either an integer, a truth value (True/False), a string enclosed in double quotes ("string") or an ATM address in hexadecimal format. Variables that can be set are the debug/memdebug for each module and variables S1-S6 as defined in LE speci- fication. S1=Address of the LES. This address is used in ATM signalling. S2=Type of the emulated LAN. Valid values is "802.3". S3=Maximum frame size. Valid value is 1516. S4=Join Timeout. Time in seconds which LES waits for LE_JOIN_REQUEST before tearing down a connection. S5=Maximum frame Age. Currently not used. S6=Address of the BUS. This address is used in ATM signalling. ELANNAME= Name of the emulated LAN SIGHUP causes restart of the server. All resources are released and server is started. SIGUSR1 causes the server to dump its internal state. SIGUSR2 shuts down the server (hopefully) gracefully. OPTIONS
-d module Set debugging messages on for a module. "All" sets debugging on for all modules. -m module Set memory debugging messages on for a module. "All" sets debugging on for all modules. -f configuration_file Use the specified configuration file instead of .lanevars. FILES
.lanevars configuration file BUGS
Servers don't establish point-to-multipoint connections to LE clients as the specification states, which means that some LE clients won't work with these servers. Supports only IEEE 802.3 / Ethernet type of ELANs. This manual page is confusing. AUTHOR
Marko Kiiskila, TUT <carnil@cs.tut.fi> SEE ALSO
lecs(8), atmsigd(8), zeppelin(8) Linux Sep 11, 1996 LES(8)
All times are GMT -4. The time now is 03:57 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy