Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: XML to Text file Parsing Using shell scripting
Operating Systems Solaris XML to Text file Parsing Using shell scripting Post 302636185 by tech_frk on Monday 7th of May 2012 06:24:48 AM
Old 05-07-2012
wow that was really fast. if time permits i need one more help below is one more xml file with diff pattern i tried it but dint get it , iam sure its a peice of cake for you.

Code:
<xn:MeContext id="LSVLKY001">
                    <xn:ManagedElement id="1">
                        <un:RncFunction id="1">
                            <un:UtranCell id="KYLSU17A">
                                <un:attributes>
                                    <un:localCellId>10071</un:localCellId>
                                    <un:uarfcnUl>862</un:uarfcnUl>
                                    <un:uarfcnDl>1087</un:uarfcnDl>
                                    <un:primaryScramblingCode>361</un:primaryScramblingCode>
                                    <un:primaryCpichPower>315</un:primaryCpichPower>
                                    <un:maximumTransmissionPower>416</un:maximumTransmissionPower>
                                    <un:primarySchPower>-18</un:primarySchPower>
                                    <un:cId>10071</un:cId>
                                    <un:secondarySchPower>-35</un:secondarySchPower>
                                    <un:bchPower>-31</un:bchPower>
                                    <un:lac>15913</un:lac>
                                    <un:rac>13</un:rac>
                                    <un:sac>10071</un:sac>
                </un:attributes>
                                <xn:VsDataContainer id="KYLSU17A">
                                    <xn:attributes>
                                    <es:cellReserved>1</es:cellReserved>
                                    <es:administrativeState>1</es:administrativeState>
                                   </xn:attributes>
                                </xn:VsDataContainer>
                            </un:UtranCell>
            </un:RncFunction>
                    </xn:ManagedElement>
                </xn:MeContext>

The xml file has the following lines in the file
There are n number of Mecontext id loops
there are y number of utrancell id loops in each Mecontext loop.
I deleted some unwanted data. i want the output to be in the following format

Code:
RNC   UtranCell   cId   uarfcnUl   uarfcnDl   primaryScramblingCode   primaryCpichPower   maximumTransmissionPower   primarySchPower   secondarySchPower   bchPower   lac   rac   sac   cellReserved   administrativeState 
                             LSVLKY53RNC01   KYLSUTOY6552C   65523   862   1087   3   337   446   -18   -35   -31   15913   13   65523   1   1       
LSVLKY53RNC01   KYLSUTOY6552B   65524   862   1087   3   337   446   -18   -35   -31   15913   13   65523   1   1       
LSVLKY53RNC01 TNLSUTOY2018T 20183   862   1087   3   337   446   -18   -35   -31   15913   13   65523   1   1       
SNJNLIDCR0R03   PRSJUTOY0051Y   51   812   1037   246   337   446   -18   -35   -31   51799   255   51   1   1
SNJNLIDCR0R03   PRSJUTOY0051X   51   812   1037   246   337   446   -18   -35   -31   51799   255   51   1   1

Last edited by tech_frk; 05-07-2012 at 05:08 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Plz Help To convert xml file to text file using bourn shell scripts

If someone out there could help me out with this problem. I would really appreciate it. I am trying to convert xml into text file(fixed length) using Unix Borne shell scripts. My xml file: <root> <header_rec recordtype="00"> <record_id>00</record_id> <country_code>AK></country_code>... (0 Replies)
Discussion started by: ram2s2001
0 Replies

2. Shell Programming and Scripting

XML to Text file Parsing Using shell scripting

Hi folks, Need some help with XML to text file parsing , the following is the content of the XML File. <xn:SubNetwork id="SNJNPRZDCR0R03"> <xn:MeContext id="PRSJU0005"> <xn:VsDataContainer id="PRSJU0005"> <xn:attributes> ... (6 Replies)
Discussion started by: tech_frk
6 Replies

3. UNIX for Dummies Questions & Answers

Delete a record in a xml file using shell scripting

find pattern, delete line with pattern and 3 lines above and 8 lines below the pattern. The pattern is "isup". The entire record with starting tag <record> and ending tag </record> containing the pattern is to be deleted and the rest to be retained. <record> ... (4 Replies)
Discussion started by: sdesstp
4 Replies

4. Shell Programming and Scripting

XML-Text Parsing Using shell scripting

HI Guys, I have to parse below xml file :- <xn:SubNetwork id="ONRM_ROOT_MO_R"> <xn:MeContext id="LP101"> <xn:ManagedElement id="1"> <xn:VsDataContainer id="1"> <xn:attributes> ... (8 Replies)
Discussion started by: asavaliya
8 Replies

5. Shell Programming and Scripting

XML: parsing of the Google contacts XML file

I am trying to parse the XML Google contact file using tools like xmllint and I even dived into the XSL Style Sheets using xsltproc but I get nowhere. I can not supply any sample file as it contains private data but you can download your own contacts using this script: #!/bin/sh # imports... (9 Replies)
Discussion started by: ripat
9 Replies

6. Shell Programming and Scripting

Scripting Language for Parsing XML

Hello, I want to know which shell scripting language (like AWk, Perl or any other) is the best for parsing and editing 1) space or Comma Separated Datsets 2) XML type Datasets. (1 Reply)
Discussion started by: ajayram
1 Replies

7. Shell Programming and Scripting

How to extract data from xml file using shell scripting?

Hi evry1, This is my 1st post in this forum.Pls help me I want to extract some data froma xml file which has 2000 lines using shell scripting. Actually my xml file has some "audio and video codes" which i need to arrange in a column wise format after extracting it using shell scripting.I... (4 Replies)
Discussion started by: arun_kohan
4 Replies

8. Shell Programming and Scripting

How to extract data from XML file using shell scripting?

Hi , I have input file as XML. following are input data #complex.xml Code: <?xml version="1.0" encoding="UTF-8"?><TEST_doc xmlns="http://www.w3.org/2001/XMLSchema-instance"> <ENTRY uid="123456"> <protein> <name>PROT001</name> <organism>Human</organism> ... (1 Reply)
Discussion started by: arun_kohan
1 Replies

9. UNIX for Dummies Questions & Answers

Shell script to read lines in a text file and filter user data Shell Programming and Scripting

sxsaaas (3 Replies)
Discussion started by: VikrantD
3 Replies

10. Programming

How to write in other language in text/xml file by reading english text/xml file using C++?

Hello Team, I have 2 files.one contains english text and another contains Japanese. so i have to read english text and replace the text with Japanesh text in third file. Basically, I need a help to write japanese language in text/xml file.I heard wstring does this.Not sure how do i write... (2 Replies)
Discussion started by: SA_Palani
2 Replies

LEARN ABOUT OPENSOLARIS

iconv_8859-5

iconv_8859-5(5)                                         Standards, Environments, and Macros                                        iconv_8859-5(5)

NAME

       iconv_8859-5 - code set conversion tables for ISO 8859-5 (Cyrillic)

DESCRIPTION

       The following code set conversions are supported:

       +-------------------------------------------------------------------------+
       |                     Code Set Conversions Supported                      |
       +--------------+--------+--------------+--------+-------------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |      Target Output      |
       +--------------+--------+--------------+--------+-------------------------+
       |ISO 8859-5    |iso5    |KOI8-R        |koi8    | KOI8-R                  |
       +--------------+--------+--------------+--------+-------------------------+
       |ISO 8859-5    |iso5    |PC Cyrillic   |alt     | Alternative PC Cyrillic |
       +--------------+--------+--------------+--------+-------------------------+
       |ISO 8859-5    |iso5    |MS 1251       |win5    | Windows Cyrillic        |
       +--------------+--------+--------------+--------+-------------------------+
       |ISO 8859-5    |iso5    |Mac Cyrillic  |mac     | Macintosh Cyrillic      |
       +--------------+--------+--------------+--------+-------------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   ISO 8859-5 to KOI8-R
       For the conversion of ISO 8859-5 to KOI8-R, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |  ISO 8859-5   |    KOI8-R      |  ISO 8859-5    |    KOI8-R     |
       |24             | 4              |320             |301            |
       |241            | 263            |321             |302            |
       |242            | 261            |322             |327            |
       |243            | 262            |323             |307            |
       |244            | 264            |324             |304            |
       |245            | 265            |325             |305            |
       |246            | 266            |327             |332            |
       |247            | 267            |330             |311            |
       |250            | 270            |331             |312            |
       |251            | 271            |332             |313            |
       |252            | 272            |333             |314            |
       |253            | 273            |334             |315            |
       |254            | 274            |335             |316            |
       |256            | 276            |336             |317            |
       |257            | 277            |337             |320            |
       |260            | 341            |340             |322            |
       |261            | 342            |341             |323            |
       |262            | 367            |342             |324            |
       |263            | 347            |343             |325            |
       |264            | 344            |344             |306            |
       |265            | 345            |345             |310            |
       |266            | 366            |346             |303            |
       |267            | 372            |347             |336            |
       |270            | 351            |350             |333            |
       |271            | 352            |351             |335            |
       |272            | 353            |352             |337            |
       |273            | 354            |353             |331            |
       |274            | 355            |354             |330            |
       |275            | 356            |355             |334            |
       |276            | 357            |356             |300            |
       |277            | 360            |357             |321            |
       |300            | 362            |360             |260            |
       |301            | 363            |361             |243            |
       |302            | 364            |362             |241            |
       |303            | 365            |363             |242            |
       |304            | 346            |364             |244            |
       |305            | 350            |365             |245            |
       |306            | 343            |366             |246            |
       |307            | 376            |367             |247            |
       |310            | 373            |370             |250            |
       |311            | 375            |371             |251            |
       |312            | 377            |372             |252            |
       |313            | 371            |373             |253            |
       |314            | 370            |374             |254            |
       |315            | 374            |375             |255            |
       |316            | 340            |376             |256            |
       |317            | 361            |                |               |
       +---------------+----------------+----------------+---------------+

   ISO 8859-5 to PC Cyrillic
       For the conversion of ISO 8859-5 to PC Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |  ISO 8859-5   |  PC Cyrillic   |  ISO 8859-5    | PC Cyrillic   |
       |24             | 4              |307             |227            |
       |200-240        | 40             |310             |230            |
       |241            | 360            |311             |231            |
       |242-254        | 40             |312             |232            |
       |255            | 260            |313             |233            |
       |256-257        | 40             |314             |234            |
       |260            | 200            |315             |235            |
       |261            | 201            |316             |236            |
       |262            | 202            |317             |237            |
       |263            | 203            |320             |240            |
       |264            | 204            |321             |241            |
       |265            | 205            |322             |242            |
       |266            | 206            |323             |243            |
       |267            | 207            |324             |244            |
       |270            | 210            |325             |245            |
       |271            | 211            |326             |246            |
       |272            | 212            |327             |247            |
       |273            | 213            |330             |250            |
       |274            | 214            |331             |251            |
       |275            | 215            |332             |252            |
       |276            | 216            |333             |253            |
       |277            | 217            |334             |254            |
       |300            | 220            |335             |255            |
       |301            | 221            |336             |256            |
       |302            | 222            |337             |257            |
       |303            | 223            |360-374         |40             |
       |304            | 224            |375             |260            |
       |305            | 225            |376             |40             |
       |306            | 226            |365             |40             |
       +---------------+----------------+----------------+---------------+

   ISO 8859-5 to MS 1251
       For the conversion of ISO 8859-5 to MS 1251, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |  ISO 8859-5   |    MS 1251     |  ISO 8859-5    |   MS 1251     |
       |24             | 4              |317             |337            |
       |200-237        | 40             |320             |340            |
       |241            | 250            |321             |341            |
       |242            | 200            |322             |342            |
       |243            | 201            |323             |343            |
       |244            | 252            |324             |344            |
       |245            | 275            |325             |345            |
       |246            | 262            |326             |346            |
       |247            | 257            |327             |347            |
       |250            | 243            |330             |350            |
       |251            | 212            |331             |351            |
       |252            | 214            |332             |352            |
       |253            | 216            |333             |353            |
       |254            | 215            |334             |354            |
       |255            | 210            |335             |355            |
       |256            | 241            |336             |356            |
       |257            | 217            |337             |357            |
       |260            | 300            |340             |360            |
       |261            | 301            |341             |361            |
       |262            | 302            |342             |362            |
       |263            | 303            |343             |363            |
       |264            | 304            |344             |364            |
       |265            | 305            |345             |365            |
       |266            | 306            |346             |366            |
       |267            | 307            |347             |367            |
       |270            | 310            |350             |370            |
       |271            | 311            |351             |371            |
       |272            | 312            |352             |372            |
       |273            | 313            |353             |373            |
       |274            | 314            |354             |374            |
       |275            | 315            |355             |375            |
       |276            | 316            |356             |376            |
       |277            | 317            |357             |377            |
       |300            | 320            |360             |271            |
       |301            | 321            |361             |270            |
       |302            | 322            |362             |220            |
       |303            | 323            |363             |203            |
       |304            | 324            |364             |272            |
       |305            | 325            |365             |276            |
       |306            | 326            |366             |263            |
       |307            | 327            |367             |277            |
       |310            | 330            |370             |274            |
       |311            | 331            |371             |232            |
       |312            | 332            |372             |234            |
       |313            | 333            |373             |236            |
       |314            | 334            |374             |235            |
       |315            | 335            |375             |210            |
       |316            | 336            |376             |242            |
       |376            | 331            |                |               |
       +---------------+----------------+----------------+---------------+

   ISO 8859-5 to Mac Cyrillic
       For the conversion of ISO 8859-5 to Mac Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       |  ISO 8859-5   | Mac Cyrillic   |  ISO 8859-5    | Mac Cyrillic  |
       |24             | 4              |317             |237            |
       |200-237        | 40             |320             |340            |
       |240            | 312            |321             |341            |
       |241            | 335            |322             |342            |
       |242            | 253            |323             |343            |
       |243            | 256            |324             |344            |
       |244            | 270            |325             |345            |
       |245            | 301            |326             |346            |
       |246            | 247            |327             |347            |
       |247            | 272            |330             |350            |
       |250            | 267            |331             |351            |
       |251            | 274            |332             |352            |
       |252            | 276            |333             |353            |
       |253            | 40             |334             |354            |
       |254            | 315            |335             |355            |
       |255            | 40             |336             |356            |
       |256            | 330            |337             |357            |
       |257            | 332            |340             |360            |
       |260            | 200            |341             |361            |
       |261            | 201            |342             |362            |
       |262            | 202            |343             |363            |
       |263            | 203            |344             |364            |
       |264            | 204            |345             |365            |
       |265            | 205            |346             |366            |
       |266            | 206            |347             |367            |
       |267            | 207            |350             |370            |
       |270            | 210            |351             |371            |
       |271            | 211            |352             |372            |
       |272            | 212            |353             |373            |
       |273            | 213            |354             |374            |
       |274            | 214            |355             |375            |
       |275            | 215            |356             |376            |
       |276            | 216            |357             |337            |
       |277            | 217            |360             |334            |
       |300            | 220            |361             |336            |
       |301            | 221            |362             |254            |
       |302            | 222            |363             |257            |
       |303            | 223            |364             |271            |
       |304            | 224            |365             |317            |
       |305            | 225            |366             |264            |
       |306            | 226            |367             |273            |
       |307            | 227            |370             |300            |
       |310            | 230            |371             |275            |
       |311            | 231            |372             |277            |
       |312            | 232            |373             |40             |
       |313            | 233            |374             |316            |
       |314            | 234            |375             |40             |
       |315            | 235            |376             |331            |
       |316            | 236            |                |               |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so             conversion modules

       /usr/lib/iconv/*.t              conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10                                                          18 Apr 1997                                                    iconv_8859-5(5)
All times are GMT -4. The time now is 01:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy