Need help parsing data with sed and/or nawk Post: 302604965

Sponsored Content

Top Forums Shell Programming and Scripting Need help parsing data with sed and/or nawk Post 302604965 by Corona688 on Tuesday 6th of March 2012 11:36:01 AM

03-06-2012

Registered User

How to stream the order really depends on what defines the order. Is parameter13 given last because it's called parameter13, or because it happened to be the 13th in the order and you always want the 13th parameter there?

---------- Post updated at 10:36 AM ---------- Previous update was at 10:22 AM ----------

If it's the order and not their names:

Code:

$ cat treatment2.awk

BEGIN { FS=","; OFS=","
        split("1,2,5,3,4,6,7,10,9,11,10,12,15,14,13", ORDER);
}

!T { TITLE=$1 ; T=1 ; next }

/^[ \t]*,/ { C[T++]=$2 }

/;;/ {  $0="";  T=""
        for(X in ORDER) $(ORDER[X])=" "C[X];
        $1=TITLE $1
        print
}

$ awk -f treatment2.awk data

Treatment parmeter1=value, parmeter2=value, parmeter4=value, parmeter5=value, parmeter3=value, parmeter6=value, parmeter7=value,, parmeter9=value, parmeter11=value, parmeter10=value, parmeter12=value, parmeter15=value, parmeter14=value, parmeter13=value
Treatment parmeter1=value, parmeter2=value, parmeter4=value, parmeter5=value, parmeter3=value, parmeter6=value, parmeter7=value,, parmeter9=value, parmeter11=value, parmeter10=value, parmeter12=value, parmeter15=value, parmeter14=value, parmeter13=value

$

Corona688

View Public Profile for Corona688

Visit Corona688's homepage!

Find all posts by Corona688

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help in sed or nawk replace RE

Dear Friends, I am trying to replace the following pattern , But I cant understand how to express the RE in this case . Please help me with a sed command to replace . (Address = 918h : Initial = 0000h : RD /WR (Address = 91Ah : Initial =...

2. Shell Programming and Scripting

sed selective data parsing

i have file in the following format *RECORD* *FIELD NO* 123456 *FIELD TX* this is a sample entry *FIELD SA* See Also *FIELD RF* References *FIELD CS* Clinical Symptoms *FIELD AV* Allelic Variants *FIELD EH* Edit History *RECORD* *FIELD NO* 123456

3. Shell Programming and Scripting

Format - Inventory Row data into Column - Awk - Nawk

Hi All, I have the following file that has computer data for various pcs in my network... Snap of the file is as follows ******************************************************************************* Serial 123456 Computer IP Address lo0:...

4. Shell Programming and Scripting

parsing(xml) using nawk/awk

Hi , I have an xml format as shown below: <Info> <last name="sean" first name="john"/> <period="5" time="11"/> <test value="1",test2 value="2",test3 value="3",test4 value="5"> <old> <value1>1</value1> <value2>2</value2> </old> <new> <value1>4</value1> <value2>3</value2> </new>...

5. Shell Programming and Scripting

Help in parsing xml file (sed/nawk)

I have a large xml file as shown below: <input> <blah> <blah> <atr="blah blah value = ""> <blah> <blah> </input> ..2nd chunk... ..3rd chunk... ...4th chunk... All lines between <input> and </input> is one 'order' and this 'order' is repeated...

6. Shell Programming and Scripting

Sed/Nawk help

Hi all, I have the following piece of code which reformats a file but the part that isn't working converts a date from dd mmm ccyy format to 2 fields containing dd/mm/ccyy,ccyy-mm-dd hh:mm:ss.000000 This is for a DB2 load file. The problem I have is that the input dd values (the dd variable...

7. Shell Programming and Scripting

XML parsing using nawk help needed

i need one 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 guys. <xn:MeContext id="LSVLKY001"> <xn:ManagedElement id="1"> <un:RncFunction id="1"> <un:UtranCell...

8. Shell Programming and Scripting

Help with parsing data with awk , eliminating unwanted data

Experts , Below is the data: --- Physical volumes --- PV Name /dev/dsk/c1t2d0 VG Name /dev/vg00 PV Status available Allocatable yes VGDA 2 Cur LV 8 PE Size (Mbytes) 8 Total PE 4350 Free PE 2036 Allocated PE 2314 Stale PE 0 IO Timeout (Seconds) default --- Physical volumes ---...

9. Shell Programming and Scripting

Parsing XML (and insert data) then output data (bash / Solaris)

Hi folks I have a script I wrote that basically parses a bunch of config and xml files works out were to add in the new content then spits out the data into a new file. It all works - apart from the xml and config file format in the new file with XML files the original XML (that ends up in...

LEARN ABOUT REDHAT

mailcap.order

MAILCAP.ORDER(5)                                               Order Mailcap Entries                                              MAILCAP.ORDER(5)

NAME

       /etc/mailcap.order - the mailcap ordering specifications

DESCRIPTION

       The  order  of  entries in the /etc/mailcap file can be altered by editing the /etc/mailcap.order file.  Each line of that file specifies a
       package and an optional mime type.  Mailcap entries that match will be placed in the order of this file.  Entries that don't match will  be
       placed later.

   Example
           mime-support:*/*
           gv:application/postscript
           netscape:text/html
           less:text/*
           emacs:text/*

       The above would make any entries provided by the mime-support package (as found in the /usr/lib/mime/packages directory) take priority over
       everything else.  The gv package will be used over anything else when it comes to postscript documents.  Netscape will be used for any html
       documents  and  less will be used for any remaining text documents.  However, since neither netscape or less provide for editing documents,
       any edit or compose actions will fall through to the emacs rules.

       After modifying this file, be sure to run /usr/sbin/update-mime (as root) to propagate the changes into the /etc/mailcap file.

       Remember that this files takes package names and not executable names.  If you want to define rules that reference specific  programs,  the
       best way is to include them in ~/.mailcap or the user section of the /etc/mailcap file.

LIMITATIONS

       There  is  currently  no way to break out a certain type from a wildcard rule.  If, for example, both xv and gimp were to specify "image/*"
       rules, it isn't possible to use xv for gif images but use gimp for jpeg images.

       Also, I would like to add the ability to specify certain actions in the rules.  For example, if netscape were to have an edit  rule  but  I
       wanted to use emacs for editing/creating html documents, I could place a line like

         emacs:text/* action=edit|compose

       before  the  netscape  entry.  The update-mime program would then spit out entries such that netscape view rule comes before the emacs view
       rule but have the netscape edit rule comes after the emacs edit rule.

SEE ALSO

       mailcap(5) run-mailcap(1) update-mime(8)

AUTHOR

       The mailcap.order specification was written by Brian White <bcwhite@pobox.com>

Debian Project                                                     16th Aug 1998                                                  MAILCAP.ORDER(5)