|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Need perl or shell script to sort vertical lines to horizontal line in csv format
Post 302698101 by sreedhargouda.h on Saturday 8th of September 2012 03:58:43 AM
09-08-2012
Need perl or shell script to sort vertical lines to horizontal line in csv format
Need perl or shell script to sort vertical lines to horizontal line in csv format
My file like below
-------------------------
================================================================================
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
Need out put like
----------------
1) PATH EXCOM1000 I7-1 AU4#1-ROSY1000 I3-1 AU4#15-UP-NA-943109961A MAIN ROUTEPINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845A Zenta1000-2#I7-1-sl4p04 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
2) 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 EXCOM1000#I7/1--sl16p03 01 ASON7_EXCOM/r01s3b04p02 44
So on
please help me.....
My file like below
-------------------------
================================================================================
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
Need out put like
----------------
1) PATH EXCOM1000 I7-1 AU4#1-ROSY1000 I3-1 AU4#15-UP-NA-943109961A MAIN ROUTEPINKY1000#I1-1-ZENTA1000-2#I7-1-ASON-SBR-UP-943113845A Zenta1000-2#I7-1-sl4p04 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
2) 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 EXCOM1000#I7/1--sl16p03 01 ASON7_EXCOM/r01s3b04p02 44
So on
please help me.....
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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
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
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 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
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
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
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
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
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
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