parsing


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers parsing
# 1  
Old 03-26-2007
parsing

Hi,

I want to parse this file....

( 0 , 0 ) =>heading1
( 0 , 1 ) =>value1.1a
( 0 , 2 ) =>value2.1a
( 1 , 0 ) =>heading2
( 1 , 1 ) =>value1.1b
( 1 , 2 ) =>value2.1b
( 2 , 0 ) =>heading3
( 2 , 1 ) =>value1.1c
( 2 , 2 ) =>value2.1c
( 3 , 0 ) =>heading4
( 3 , 1 ) =>value1.1d
( 3 , 2 ) =>value2.1 d

i want to have this kind of output.

first file

heading1=value1.1a
heading2=value1.1b
heading3=value1.1c
heading4=value1.1d

second file
heading1=value2.1a
heading2=value2.1b
heading3=value2.1c
heading4=value2.1d

help please.i want to use awk
# 2  
Old 03-26-2007
You want to use awk or the assigment tells you to use ask?
# 3  
Old 03-26-2007
Hi,

you can give me some variation solution. i think it would be better to use awk to parse.
# 4  
Old 03-26-2007
if you have Python, here's an alternative:
Code:
#!/usr/bin/python
data = open("file").readlines()
data = [i.strip() for i in data]
items = [ items.split("=>")[1] for items in data ]
for num,i in enumerate(items):
    if "heading" in i:
        print "%s = %s" % (i, items[num+1])
for num,i in enumerate(items):
    if "heading" in i:
        print "%s = %s" % (i, items[num+2])

output:
Code:
 # ./test.py
heading1 = value1.1a
heading2 = value1.1b
heading3 = value1.1c
heading4 = value1.1d
heading1 = value2.1a
heading2 = value2.1b
heading3 = value2.1c
heading4 = value2.1d

# 5  
Old 03-26-2007
Sad to say,

I dont have python installed and will not use python.

thanks.
# 6  
Old 03-27-2007
Here is a solution , give a try on this...

Code:
cat filename | tr -d "( )" | tr "=>" ", " | awk -F"," '{ if($2=="0") head=$3" ="; if ($2=="1") print head $3>"file1";if ($2=="2") print  head $3>"file2"; }'

Output
cat file1
heading1 = value1.1a
heading2 = value1.1b
heading3 = value1.1c
heading4 = value1.1d
cat file2
heading1 = value2.1a
heading2 = value2.1b
heading3 = value2.1c
heading4 = value2.1d

Last edited by dennis.jacob; 03-27-2007 at 01:46 AM..
# 7  
Old 03-27-2007
Code:
awk -F"=>" '{ if( $0 ~ "heading" ) { title=$2"=" } else { if ( $0 ~ "value1" ) { print title$2 > "first" } else { print title$2 > "second" } } }' filename

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

parsing

Can some body show me a sed command to remove everyhing upto a '/' and leave the rest of the line. cat data.out This is the directory /tmp/xxx/yy.ksh I only want to get the fullpath name /tmp/xxx.yy.ksh Thanks in advance to all who answer. (3 Replies)
Discussion started by: BeefStu
3 Replies

2. Shell Programming and Scripting

Parsing the file

Hi all, Could anyone help me out? My input file is like: M1SYSNPENGGQINDNINYSE21PTMLPENLSLSNYDMDSFLGQFPSDNNMQLPHSTYEQHLQGEQQNPTNPNYFPPEFDEN2VDW1QE2 output is: M1 M1SYSNPENGGQINDNINYSE2 M1SYSNPENGGQINDNINYSE21 SYSNPENGGQINDNINYSE2 SYSNPENGGQINDNINYSE21 ... (2 Replies)
Discussion started by: yinyuemi
2 Replies

3. Shell Programming and Scripting

sed (parsing value)

All, Can somebody provide me with some sed expertise on how to parse the following line. 27-MAR-2011 10:28:01 * (CONNECT_DATA=(SID=dmart)(CID=(PROGRAM=sqlplus)(HOST=mtasnprod1)(USER=mtasnord))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.197.7.47)(PORT=54881)) * establish * dmart * 0 I would like... (3 Replies)
Discussion started by: BeefStu
3 Replies

4. Shell Programming and Scripting

Parsing through Awk

Hi All, I have an input file something like this: Line1 Line2 .... LineN Identifier ( Field1a, Field1b; Field2a, Field1b; Field3a, Field1b; ..... ) LineN+1 LineN+2 etc.. I basically need Field1a, Field2a, Field3a.... from the above file (6 Replies)
Discussion started by: tostay2003
6 Replies

5. Shell Programming and Scripting

Need help with parsing a file

I trying to get only the highest version of the file names from an file which has list of file names. EX: CATEGORYDISPLAY JSP.A-SRC_BLD;2.4 CATEGORYDISPLAY JSP.A-SRC_BLD;2.5 CATEGORYDISPLAY JSP.A-SRC_BLD;2.1 CATEGORYDISPLAY JSP.A-SRC_BLD;2.2 The Script should display only the highest... (7 Replies)
Discussion started by: rocker_me2002
7 Replies

6. Shell Programming and Scripting

iterative parsing

I have always struggled when parsing a file vertically vs. by line horizontally. Can't seem to get my head around the concept. Here again I need to convert vertical output to horizontal output. original output root@acuransx:bpplsched 2000-STAND3 -v -M acuransx -l <2>bpplsched: INITIATING:... (4 Replies)
Discussion started by: jouuu
4 Replies

7. Shell Programming and Scripting

Parsing of file for Report Generation (String parsing and splitting)

Hey guys, I have this file generated by me... i want to create some HTML output from it. The problem is that i am really confused about how do I go about reading the file. The file is in the following format: TID1 Name1 ATime=xx AResult=yyy AExpected=yyy BTime=xx BResult=yyy... (8 Replies)
Discussion started by: umar.shaikh
8 Replies

8. Shell Programming and Scripting

Perl parsing compared to Ksh parsing

#! /usr/local/bin/perl -w $ip = "$ARGV"; $rw = "$ARGV"; $snmpg = "/usr/local/bin/snmpbulkget -v2c -Cn1 -Cn2 -Os -c $rw"; $snmpw = "/usr/local/bin/snmpwalk -Os -c $rw"; $syst=`$snmpg $ip system sysName sysObjectID`; sysDescr.0 = STRING: Cisco Internetwork Operating System Software... (1 Reply)
Discussion started by: popeye
1 Replies

9. Shell Programming and Scripting

Need some help with parsing

I have a big xml file with little formatting in it. It contains over 600 messages that I need to break each message out in its own separate file. The xml file looks in the middle of it something like this: </Title></Msg><Msg><Opener> Hello how are you?<Title> Some says hello</Title><Body>... (3 Replies)
Discussion started by: quixoticking11
3 Replies

10. Shell Programming and Scripting

Parsing Binary

I have a binary file a particular format. It contains the Length Bytes and the Type bytes i.e the first four bytes if the file indicate the length of the Type which is to follow. for eg, if the int value of the first four bytes is 80, then it means that the length of the following "Type" is 80.... (2 Replies)
Discussion started by: xgringo
2 Replies
Login or Register to Ask a Question