Sponsored Content
Top Forums Shell Programming and Scripting Transform vertical into horizontal list Post 302950011 by reignangel2003 on Monday 20th of July 2015 04:57:57 AM
Old 07-20-2015
Transform vertical into horizontal list

Hi,

I am creating a script that will pull data from database. The only thing missing now is that i have to transform the lines into horizontal list.

Code:
EXAMPLE

Code:
2015-07-15 09:00:00.0    |TCSERVER01     |5354                
2015-07-15 09:01:00.0    |TCSERVER01     |6899                
2015-07-15 09:02:00.0    |TCSERVER01     |3857                
2015-07-15 09:03:00.0    |TCSERVER01     |3380                
2015-07-15 09:04:00.0    |TCSERVER01     |3835                
2015-07-15 09:05:00.0    |TCSERVER01     |5357                
2015-07-15 09:00:00.0    |TCSERVER02     |5580                
2015-07-15 09:01:00.0    |TCSERVER02     |8979                
2015-07-15 09:02:00.0    |TCSERVER02     |3722                
2015-07-15 09:03:00.0    |TCSERVER02     |3325                
2015-07-15 09:04:00.0    |TCSERVER02     |3743                
2015-07-15 09:05:00.0    |TCSERVER02     |5006                
2015-07-15 09:00:00.0    |TCSERVER03     |2923                
2015-07-15 09:01:00.0    |TCSERVER03     |4412                
2015-07-15 09:02:00.0    |TCSERVER03     |2215                
2015-07-15 09:03:00.0    |TCSERVER03     |2010                
2015-07-15 09:04:00.0    |TCSERVER03     |2013                
2015-07-15 09:05:00.0    |TCSERVER03     |3712                
2015-07-15 09:00:00.0    |TCSERVER04     |2441                
2015-07-15 09:01:00.0    |TCSERVER04     |3464                
2015-07-15 09:02:00.0    |TCSERVER04     |1910                
2015-07-15 09:03:00.0    |TCSERVER04     |1978                
2015-07-15 09:04:00.0    |TCSERVER04     |2093                
2015-07-15 09:05:00.0    |TCSERVER04     |2673

Code:
OUTPUT

Code:
LOGTIME					SERVER01		SERVER02		SERVER03		SERVER04
2015-07-15 09:00:00.0	5354			5580			2923			2441
2015-07-15 09:01:00.0	6899			8979			4412			3464
2015-07-15 09:02:00.0	3857			3722			2215			1910
2015-07-15 09:03:00.0	3380			3325			2010			1978
2015-07-15 09:04:00.0	3835			3743			2013			2093
2015-07-15 09:05:00.0	5357			5006			3712			2673

Hope you can help me out.

Last edited by Don Cragun; 07-20-2015 at 07:36 PM.. Reason: Add CODE tags.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Vertical an horizontal pivoing in unix

Please help me to do Vertical an horizontal pivoing in unix in single run. The input file is like this- MRKT|PROD|PRD|FACT1|FACT2|FACT3|FACT4 M1|P1|PR1|F11|F12|F13|F14 M1|P1|PR2|F21|F22|F23|F24 M1|P1|PR3|F31|F32|F33|F34 M2|P2|PR1|F41|F42|F43|F44 M2|P2|PR2|F51|F53|F54|F55... (4 Replies)
Discussion started by: marut_ashu
4 Replies

2. UNIX for Dummies Questions & Answers

Horizontal to vertical

Hi, Silly question, if I have an excel file that looks something like this: ................. Subject 1 Subject 2 Subject 3 Subject 4 Fever..............13...........9.............23..........14 Headache.........2............12...........18..........23... (3 Replies)
Discussion started by: Xterra
3 Replies

3. UNIX for Dummies Questions & Answers

vertical to horizontal

dear all, i'm new to unix and i try to figure out the best case for making list of vertical text to become horizontal and skip the line 1 and 2. example text : Data DATE XXXXX MAX 47 53 49 51 48 48 7 46 51 8 25 (6 Replies)
Discussion started by: andrisetia
6 Replies

4. UNIX for Dummies Questions & Answers

How to move vertical line to Horizontal...

How to move a vertical line to Horizontal line.....Can i use a tr command? code is: StudentID Java .Net C# I want to move this line like this: StudentID Java .Net C# Please use code tags! (3 Replies)
Discussion started by: Arsh10
3 Replies

5. Shell Programming and Scripting

Vertical And Horizontal Pivoting

Hi All, My Input data is: A=1 B=2 My desired Output should be: A|B 1|2 Thanks in advance... (3 Replies)
Discussion started by: kmsekhar
3 Replies

6. Shell Programming and Scripting

awk in horizontal and vertical math

Based on input ail,UTT,id1_0,COMBO,21,24,21,19,85 al,UTHAST,id1_0,COMBO,342,390,361,361,1454 and awk code as awk -F, '{ K=0; for(i=NF; i>=(NF-4); i--) { K=K+$i; J=J+$i;} { print K } } END { for ( l in J ) printf("%s ",J); }' I'm trying to add columns and lines in single line. line... (6 Replies)
Discussion started by: busyboy
6 Replies

7. Shell Programming and Scripting

How do i do the vertical to horizontal??

51009 8746 8912 17986 20315 24998 5368 38934 7805 8566 (4 Replies)
Discussion started by: nikhil jain
4 Replies

8. UNIX for Dummies Questions & Answers

Change Vertical to Horizontal

I need to change data from vertical to horizontal but with condition input USA|80 AUS|40 BRA|33 VEGAS|40 KENTUCKY|50 NEWYORK|21 DARWIN|33 ADELAIDE|21 SAOPAOLO|44 RIO|89 GAPIZA|44 BENFLEX|32 AXIS|44 ACRE|56 HEIGHT|22 (5 Replies)
Discussion started by: radius
5 Replies

9. UNIX for Dummies Questions & Answers

Print vertical to horizontal

Hi Masters, I need help to change my vertical data to horisontal input 2015-04-13|JS|741667 2015-04-13|JSJ|2272 2015-04-13|TMS|107099 2015-04-12|JMD|47945 2015-04-13|TM|760024 2015-04-13|JM|484508 2015-04-14|JMJ|318 2015-04-14|JSD|54436 2015-04-13|JM|15410 Output... (2 Replies)
Discussion started by: radius
2 Replies

10. Shell Programming and Scripting

Need to move vertical to horizontal using paste

Source file Name:hostname1 Masking views : Yes Storage Group Names : hostname1 device (5): Name:hostname2 Masking views : Yes Storage Group Names : hostname2 device (5): Name:hostname3 Masking views : no Storage Group Names : hostname3 device (5):... (9 Replies)
Discussion started by: ranjancom2000
9 Replies
fb.modes(5)						     Linux frame buffer utils						       fb.modes(5)

NAME
fb.modes - frame buffer modes file DESCRIPTION
/etc/fb.modes contains an unlimited number of video mode descriptions. The general format of a video mode is: mode geometry <xres> <yres> <vxres> <vyres> <depth> timings <pixclock> <left> <right> <upper> <lower> <hslen> <vslen> options <value> rgba <red,green,blue,alpha> endmode OPTIONS
geometry options: xres visible horizontal resolution (in pixels) yres visible vertical resolution (in pixels) vxres virtual horizontal resolution (in pixels) vyres virtual vertical resolution (in pixels) depth display depth (in bits per pixel) timing options: pixclock length of one pixel (in picoseconds) left left margin (in pixels) right right margin (in pixels) upper upper margin (in pixel lines) lower lower margin (in pixel lines) hslen horizontal sync length (in pixels) vslen vertical sync length (in pixel lines) rgba options (only valid with truecolor): red red color bitfields (in length or length/offset) green green color bitfields (in length or length/offset) blue blue color bitfields (in length or length/offset) alpha alpha color bitfields (in length or length/offset) other options: the first value of this options is the default hsync {low|high} the horizontal sync polarity vsync {low|high} the vertical sync polarity csync {low|high} the composite sync polarity gsync {low|high} the sync on green polarity bcast {false|true} enable or disable broadcast modes. If enabled the frame buffer generates the exact timings fot several broadcast modes (e.g. PAL or NTSC). Note that this option may not be supported by every frame buffer extsync {false|true} enable or disable external resync. If enabled the sync timings are not generated by the frame buffer device and must be pro- vided externally instead. Note that this option may not be supported by every frame buffer device laced {false|true} enable or disable interlace. If enabled the display will be split in two frames, each frame contains only even and odd lines respectively. These two frames will be displayed alternating, this way twice the lines can be displayed and the vertical fre- quency for monitor stays the same, but the visible vertical frequency gets halved double {false|true} enable or disable doublescan. If enabled every line will be displayed twice and this way the horizontal frequency can easily be doubled, so that the same resolution can be displayed on different monitors, even if the horizontal frequency specifica- tion differs. Note that this option may not be supported by every frame buffer device nostd <number> select nonstandard video mode accel {false|true} enable or disable hardware text acceleration grayscale {false|true} enable or disable graylevels instead of colors INTERNALS
Generally a frame buffer display is organized as follows: +---+---------------+---+---+ | | ^ | | | | | | 5 | | | | | v | | | +---#################---+---+ | # ^ # | | | # | # | | | # | # | | | 1 # | 2 # 3 | 4 | |<->#<------+------>#<->|<->| | # | # | | | # | 6 # | | | # | # | | | # v # | | +---#################---+---+ | | ^ | | | | | | 7 | | | | | v | | | +---+---------------+---+---+ | | ^ | | | | | | 8 | | | | | v | | | +---+---------------+---+---+ 1 left margin 2 xres 3 right margin 4 horizontal sync len 5 upper margin 6 yres 7 lower margin 8 vertical sync len The area bordered with `#' is the visible display area. Horizontal and vertical frequencies can now easily be calculated, for this the sum of horizontal or vertical values are important htotal = left + xres + right + hslen vtotal = upper + yres + lower + vslen The length of one line can now be calculated with pixclock line = pixclock * htotal and we have the horizontal frequency hfreq = 1E12 / line = 1E12 / (pixclock * htotal) To get the vertical frequency vtotal must eventually adjusted. If the display is laced, vtotal must be halved or if the display is a dou- blescan one, vtotal must be doubled. Now we can calculate the length of one frame if (lace) vtotal /= 2 if (double) vtotal *= 2 frame = vtotal * line and we get also the vertical frequency vfreq = 1E12 / frame = hfreq / vtotal SEE ALSO
fbset(8), fbdev(4) 2.1 2003-08-07 fb.modes(5)
All times are GMT -4. The time now is 02:20 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy