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
SMP_REP_ROUTE_INFO(8)						     SMP_UTILS						     SMP_REP_ROUTE_INFO(8)

NAME
smp_rep_route_info - invoke REPORT ROUTE INFORMATION SMP function SYNOPSIS
smp_rep_route_info [--help] [--hex] [--index=IN] [--interface=PARAMS] [--multiple] [--num=NUM] [--phy=ID] [--raw] [--sa=SAS_ADDR] [--ver- bose] [--version] [--zero] SMP_DEVICE[,N] DESCRIPTION
Sends a SAS Management Protocol (SMP) REPORT ROUTE INFORMATION function request to a SMP target. The SMP target is identified by the SMP_DEVICE and the SAS_ADDR. Depending on the interface, the SAS_ADDR may be deduced from the SMP_DEVICE. The mpt interface uses SMP_DEVICE to identify a HBA (an SMP initiator) and needs the additional ,N to differentiate between HBAs if there are multiple present. There are two expander route table types: phy-based and expander-based. The expander-based route table was introduced in SAS-2 and super- sedes the phy-based route tables. The REPORT ROUTE INFORMATION function is associated with a phy-based route table. The CONFIGURE ROUTE INFORMATION function is provided to manually set up a phy-based route table. Each phy in a SAS expander that has an associated routing attribute of "table" has a router table. The number of rows (or entries) in each router table is given by the "expander route indexes" field in the response of the REPORT GENERAL function. When the --multiple option is given, the REPORT ROUTE INFORMATION function is called multiple times. The index value increments on each iteration, starting from --index=IN (default 0). If --num=NUM is given and NUM is greater than zero then that is the maximum number of iterations performed. If --num=NUM is not given (or NUM is zero) then iterations continue until there are 4 adjacent disabled route entries (or some error is detected). OPTIONS
Mandatory arguments to long options are mandatory for short options as well. -h, --help output the usage message then exit. -H, --hex output the response (less the CRC field) in hexadecimal. -i, --index=IN expander route index. IN is a value between 0 and 65535. Default is 0. More precisely the maximum index value is (expander_route_indexes - 1). -I, --interface=PARAMS interface specific parameters. In this case "interface" refers to the path through the operating system to the SMP initiator. See the smp_utils man page for more information. -m, --multiple call the REPORT ROUTE INFORMATION function multiple times, starting at --index=IN, incrementing the index value on each iteration for a maximum of --num=NUM iterations. For each enabled route table entry, one line is output. If --num=NUM is not given (or NUM is zero) then iterations continue until 4 adjacent disabled entries are found (or some error occurs). -n, --num=NUM used with --multiple option to specify the maximum number of iterations. -p, --phy=ID phy identifier. ID is a value between 0 and 254. Default is 0. -r, --raw send the response (less the CRC field) to stdout in binary. All error messages are sent to stderr. -s, --sa=SAS_ADDR specifies the SAS address of the SMP target device. Typically this is an expander. This option may not be needed if the SMP_DEVICE has the target's SAS address within it. The SAS_ADDR is in decimal but most SAS addresses are shown in hexadecimal. To give a number in hexadecimal either prefix it with '0x' or put a trailing 'h' on it. -v, --verbose increase the verbosity of the output. Can be used multiple times. -V, --version print the version string and then exit. -z, --zero zero the Allocated Response Length field in the request. This option also zeros the Request Length field in the request. This is required for strict SAS-1.1 compliance. However this option should not be given in SAS-2 and later; if it is given an abridged response may result. CONFORMING TO
The SMP REPORT ROUTE INFORMATION function was introduced in SAS-1 . The "Expander change count" field was added in SAS-2 . AUTHORS
Written by Douglas Gilbert. REPORTING BUGS
Report bugs to <dgilbert at interlog dot com>. COPYRIGHT
Copyright (C) 2006-2011 Douglas Gilbert This software is distributed under a FreeBSD license. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PUR- POSE. SEE ALSO
smp_utils, smp_rep_general(smp_utils) smp_utils-0.96 May 2011 SMP_REP_ROUTE_INFO(8)
All times are GMT -4. The time now is 07:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy