Sponsored Content
Full Discussion: Transposing a file
Top Forums Shell Programming and Scripting Transposing a file Post 302580030 by rymnd_12345 on Wednesday 7th of December 2011 08:50:10 AM
Old 12-07-2011
Hi Mr.bean,

I've tried your script and Yes it worked, but I have some problems here, why is that it outputs only one IMSI, see example below:
Code:
======== MOBILITY EVENT (W): ATTACH REJECT =========
Time      : <date time>
Node      : <node>
GMM Cause : <code>
Details   : <details>
Attach    : <attach>
IMSI      : <imsi_01>
PTMSI     : <ptmsi>
RA New    : <ra_new>
RA Old    : <ra_old>
HLR addr  : <hlr_addr>


======== MOBILITY EVENT (G): ATTACH REJECT =========
Time      : <date time>
Node      : <node>
GMM Cause : <code>
Details   : <details>
Attach    : <attach>
IMSI      : <imsi_02>
PTMSI     : <ptmsi>
RA New    : <ra_new>
RA Old    : <ra_old>
HLR addr  : <hlr_addr>


Output:
Code:
Mobility Event    Time            Node        GMM Cause        Details        Attach        IMSI
W                     <date time>   <node>         <code>            <details>      <attach>    imsi01
G                      <date time>   <node>         <code>            <details>      <attach>    imsi01
W                     <date time>   <node>          <code>            <details>      <attach>    imsi01
G                      <date time>   <node>          <code>            <details>      <attach>    imsi01

IMSI data is the same in all lines, but as per checking the file that contains the actual data, IMSI is unique and different from each other.

Note: IMSI = 15digit_nos


Please advise Smilie


Br,
Rymnd

Last edited by Franklin52; 12-07-2011 at 09:53 AM.. Reason: Please use code tags for code and data samples, thank you
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

transposing letters

Hi, I've written a shell function in bash that reads letters into an array, then outputs them in one column with: for n in "${array}"; do echo $n done I was wondering if anyone knew how i would transpose the letters that are output by the for loop. Right now my output is: aabbcc... (4 Replies)
Discussion started by: myscsa2004
4 Replies

2. Shell Programming and Scripting

file transposing

Hello, Is there a way to transpose a file in shell scripting? For instance, from a1 a2 a3 a4 a5 a6 a7 .... b1 b2 b3 b4 b5 b6 b7 .... c1 c2 c3 c4 c5 c6 c7 .... d1 d2 d3 d4 d5 d6 d7 ... ... ... ... to a1 b1 c1 d1 .... a2 b2 c2 d2 .... a3 b3 c3 d3 .... a4 b3 c3 d4 .... ... ... (24 Replies)
Discussion started by: mskcc
24 Replies

3. Shell Programming and Scripting

Another transposing issue

Hello I need to sort a file with data such as so it breaks on column 1 and all the data in column 2 is sorted into rows with a unique column 1: 1 5 1 6 1 7 2 3 2 4 3 7 3 0 3 9 So it comes out as: 1 5 6 7 2 3 4 3 7 0 9 I've tried many iterations of nawk but can't get it... (14 Replies)
Discussion started by: stevesmith
14 Replies

4. UNIX Desktop Questions & Answers

More than transposing!

Hi everyone, I have a poblem like that: I have a file which includes data looks like: 0.65214 0.3597 1.0 0.65244 0.3502 1.0 0.65273 0.3553 1.0 0.65305 0.3544 1.0 0.65327 0.3505 1.0 0.65359 0.3516 1.0 0.65578 0.6464 1.0 0.65605 0.6453 1.0 0.65633 0.6437 1.0 0.65660 0.6488 1.0... (3 Replies)
Discussion started by: bulash
3 Replies

5. Shell Programming and Scripting

Transposing a file

i have a file as: 1 2 3 4 5 i want output as : 1 2 3 4 5 can anybody help on this?? (14 Replies)
Discussion started by: vikas_kesarwani
14 Replies

6. Shell Programming and Scripting

Transposing column to row, joining with another file, then sorting columns

Hello! I am very new to Linux and I do not know where to begin... I have a column with >64,000 elements (that are not in numberical order) like this: name 2 5 9 . . . 64,000 I would like to transpose this column into a row that will later become the header of a very large file... (2 Replies)
Discussion started by: doobedoo
2 Replies

7. Shell Programming and Scripting

Transposing a file

Hi All, I have a input file say FILEA. FILEA -------- empid1 sal1 location1 manager1 empid2 sal2 location2 manager2 empid3 sal3 location3 manager3 . . . (3 Replies)
Discussion started by: 46019
3 Replies

8. Shell Programming and Scripting

transposing square matrixs or blocks in a big file

Hi I do have a big file of the following format a b c d e f g 2 3 5 6 6 6 7 3 4 5 6 7 9 0 4 5 7 8 9 9 0 1 2 4 5 6 7 8 3 5 6 7 2 3 4 5 6 7 4 3 2 4 5 4 5 6 3 5 5 r h i j k l m 2 3 4 5 6 7 8 4 5 7 8 9 9 0 3 5 6 7 2 3 4 2 3 5 6 6 6 7 5 5 7 8 9 2 3 1 2... (7 Replies)
Discussion started by: Lucky Ali
7 Replies

9. Shell Programming and Scripting

Transposing lines in a csv file with sed

Hi I have a large csv file with lines like below Date,Status,orig,dest,in,out,when,where 2012-01-01 00:30:37,I,48,56,23,98,83,34 2012-06-17 15:00:38,I,72,43,12,65,34,12I will really appreciate if someone can help with a sed script to transpose this to 2012-01-01 00:30:37,I,orig,48... (5 Replies)
Discussion started by: kaf3773
5 Replies

10. UNIX for Dummies Questions & Answers

Transposing a huge space delimited file

Hi, How do I transpose a huge space delimited file with more than 2 million columns and about 100 rows? Thanks! (10 Replies)
Discussion started by: evelibertine
10 Replies
XPath::Node(3)						User Contributed Perl Documentation					    XPath::Node(3)

NAME
XML::XPath::Node - internal representation of a node API
The Node API aims to emulate DOM to some extent, however the API isn't quite compatible with DOM. This is to ease transition from XML::DOM programming to XML::XPath. Compatibility with DOM may arise once XML::DOM gets namespace support. new Creates a new node. See the sub-classes for parameters to pass to new(). getNodeType Returns one of ELEMENT_NODE, TEXT_NODE, COMMENT_NODE, ATTRIBUTE_NODE, PROCESSING_INSTRUCTION_NODE or NAMESPACE_NODE. UNKNOWN_NODE is returned if the sub-class doesn't implement getNodeType - but that means something is broken! The constants are exported by default from XML::XPath::Node. The constants have the same numeric value as the XML::DOM versions. getParentNode Returns the parent of this node, or undef if this is the root node. Note that the root node is the root node in terms of XPath - not the root element node. to_sax ( $handler | %handlers ) Generates sax calls to the handler or handlers. See the PerlSAX docs for details (not yet implemented correctly). MORE INFO
See the sub-classes for the meaning of the rest of the API: o XML::XPath::Node::Element o XML::XPath::Node::Attribute o XML::XPath::Node::Namespace o XML::XPath::Node::Text o XML::XPath::Node::Comment o XML::XPath::Node::PI perl v5.18.2 2003-01-26 XPath::Node(3)
All times are GMT -4. The time now is 05:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy