Sponsored Content
Top Forums Shell Programming and Scripting Need perl or shell script to sort vertical lines to horizontal line in csv format Post 302698187 by durden_tyler on Saturday 8th of September 2012 08:02:31 PM
Old 09-08-2012
Code:
$
$
$ cat f11
================================================================================
PATH PINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845
================================================================================

***** MAIN ROUTE *******

PINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845A
Zenta1000-2#I7-1-sl4p04 28
ASON6_TECHNO/r01s3b04p04 28
ASON6_TECHNO/r01s3b06p01 05
ASON5_PINKY/r01s3b05p02 05
ASON5_PINKY/r01s3b16p01 12
PINKY1000#I1/1-sl16p01 12
PINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-94311384500

***** SPARE ROUTE *******

ASON6_TECHNO/r01s3b04p04 28
ASON6_TECHNO/r01s3b09p03 15
ASON5_PINKY/r01s3b09p03 15
ASON5_PINKY/r01s3b16p01 12

================================================================================
PATH EXCOM1000 I7-1 AU4#1-ROSY1000 I3-1 AU4#15-UP-NA-943109961
================================================================================

***** MAIN ROUTE *******

EXCOM1000 I7-1 AU4#1-ROSY1000 I3-1 AU4#15-UP-NA-943109961A
EXCOM1000#I7/1--sl16p03 01
ASON7_EXCOM/r01s3b16p03 01
ASON7_EXCOM/r01s3b04p02 44
ASON14_TURBHE2/r01s3b02p03 44
ASON14_TURBHE2/r01s3b04p02 03
ASON12_TURBHE/r01s3b19p02 03
ASON12_TURBHE/r01s3b05p01 30
ASON13_BALKRISHNA/r01s3b05p01 30
ASON13_BALKRISHNA/r01s3b04p04 15
Rosymery#I3/1-Balk#4/4 15
EXCOM1000 I7-1 AU4#1-ROSY1000 I3-1 AU4#15-UP-NA-94310996100
$
$
$ perl -lne 's/^\*+ (.*) \*+$/$1/;
             if (/^=+/){$i++; do{print join",",@x; @x=()} if ($i>2 and $i%2==1)}
             elsif(/^\S/i) {push @x,$_}
             END {print join ",",@x}
            ' f11
PATH PINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845 ,MAIN ROUTE,PINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845A ,Zenta1000-2#I7-1-sl4p04 28 ,ASON6_TECHNO/r01s3b04p04 28 ,ASON6_TECHNO/r01s3b06p01 05 ,ASON5_PINKY/r01s3b05p02 05 ,ASON5_PINKY/r01s3b16p01 12 ,PINKY1000#I1/1-sl16p01 12 ,PINK
Y1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-94311384500 ,SPARE ROUTE,ASON6_TECHNO/r01s3b04p04 28,ASON6_TECHNO/r01s3b09p03 15 ,ASON5_PINKY/r01s3b09p03 15 ,ASON5_PINKY/r01s3b16p01 12
PATH EXCOM1000 I7-1 AU4#1-ROSY1000 I3-1 AU4#15-UP-NA-943109961 ,MAIN ROUTE,EXCOM1000 I7-1 AU4#1-ROSY1000 I3-1 AU4#15-UP-NA-943109961A ,EXCOM1000#I7/1--sl16p03 01 ,ASON7_EXCOM/r01s3b16p03 01 ,ASON7_EXCOM/r01s3b04p02 44 ,ASON14_TURBHE2/r01s3b02p03 44 ,ASON14_TURBHE2/r01s3b04p02 03 ,ASON12_TURBHE/r01s3
b19p02 03 ,ASON12_TURBHE/r01s3b05p01 30 ,ASON13_BALKRISHNA/r01s3b05p01 30 ,ASON13_BALKRISHNA/r01s3b04p04 15 ,Rosymery#I3/1-Balk#4/4 15 ,EXCOM1000 I7-1 AU4#1-ROSY1000 I3-1 AU4#15-UP-NA-94310996100
$
$

tyler_durden
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

converting horizontal line to vertical line

how to use "tr" command to display horizontal line to vertical line for vertical to horizontal, the command is tr '\n' '\t' <inputfile but what is the command for horizontal to vertical Thanks Vasikaran (3 Replies)
Discussion started by: vasikaran
3 Replies

2. Shell Programming and Scripting

Draw a Horizontal and Vertical line on UNIX

I want to draw a horizontal and vertical line on Unix. Please suggest some solution. (11 Replies)
Discussion started by: allways4u21
11 Replies

3. Shell Programming and Scripting

Need help in changing vertical lines to horizontal line in a file

Hi, I have a file like below robert PREF: 3 AVAIL: henry PREF: 234 AVAIL: john PREF: 145,178 AVAIL: 123 matt PREF: 564,932 AVAIL: ten PREF: 389 AVAIL: kill (2 Replies)
Discussion started by: rocky1954
2 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

change log vertical to horizontal lines

Hi, Need help unix command to change this : become this Anyone can help me?:wall: (2 Replies)
Discussion started by: justbow
2 Replies

6. Shell Programming and Scripting

Script awk vertical to horizontal with some condition

hi all.. i have problem, right now i want to processing some data with input like this BIMAB ACF-0168 QTS-0465 QUA 2013-08-17 14:16:09.34 ** ALAR ORX -004 NDORIDUNGGA (21943) 7745 ABOVE DEFINED 02 00 01 00 00 00 01 00 00 01 03... (12 Replies)
Discussion started by: buncit8
12 Replies

7. Shell Programming and Scripting

Help! output format from vertical to horizontal

Hi All, please help to achieve the desired output Example: I have a file which contains the below data empname robert empid 787 design consultant empname alex empid 898 design advocate Desired output should be empname empid design robert 787 consultant (19 Replies)
Discussion started by: rocky2013
19 Replies

8. Shell Programming and Scripting

Change the vertical logs to horizontal line

Hi, cat log EPC-SubsId: 3333 EPC-GrIds: RTGHUPA:1:15-11-2013T19:59,22-11-2013T19:59 EPC-GrIds: PrimaXGB_23:10 EPC-SubsId: 4444 EPC-GrIds: RTGHUPB:1:15-11-2013T19:59,22-11-2013T19:59 EPC-SubId: 5555 EPC-GrIds: RTGHUPC:1:15-11-2013T19:59,22-11-2013T19:59 EPC-SubsId: 6666... (1 Reply)
Discussion started by: justbow
1 Replies

9. Emergency UNIX and Linux Support

Help parsing log from vertical to horizontal line

Hi Expert, i have log in attached (log.txt) i want the log result become horizontal line : recordOpeningTime,servedMSISDN,ratingGroup,datavolumeFBCUplink,datavolumeFBCDownlink 1502260153422B0800,196738930571,3,7946,2219 1502260153422B0800,196738930571,3,233,174... (4 Replies)
Discussion started by: justbow
4 Replies

10. UNIX for Beginners Questions & Answers

Convert a horizontal lines to vertical lines in a csv file

Hi.. I need some help in converting the below horizontal lines to vertical lines format. can anyone help me on this. input file Hour,1,2,3,4,5 90RT,106,111,111,112,111 output file Hour,90RT 1,106 2,111 3,111 4,112 5,111 (3 Replies)
Discussion started by: Raghuram717
3 Replies
fb.modes(8)						     Linux frame buffer utils						       fb.modes(8)

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> 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) 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 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 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) local Aug 1996 fb.modes(8)
All times are GMT -4. The time now is 07:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy