UNIX for Dummies Questions & Answers

How about this:

Code:

tn=m_TASK_UPDATESSS
awk 'NR>1&&/^<MAPPING/{print RS $0;next}1' f1 | awk -v x="$tn" 'BEGIN{p="NAME=." x ". "}/^<MAPPING/&&match($0,p)' RS=""

@Tmalik79

You have to replace "f1" with your filename.

By the way , what are you trying to achieve ?

1) filter out all <MAPPING ... > ... </MAPPING> block that not containing the pattern ?

or

2) filter out everything except the <MAPPING ... > ... </MAPPING> block that match the pattern ?

Please clarify what output you expect

Thanks for all your help and time. This is really helpful to me and my whole project delivery is dependent on this.

I have tried above stmt and changed file name to.. I may not filter the data. File which i given is modified to restrict no of lines original file will have 1000+ lines. The file is generated from informatica repository.

what I am trying to do is..

1. My file has lot of content which i need to read and print specific properties within open and close tag.
In the above example..
First I need to get unique mapping open line and immediate mapping close tag and get
all the data in between lines to string or file and grep certain columns values.

Line starts with <MAPPING and same line contains NAME='xxxx' unique always so get the data from above unique line to till immediate </MAPPING> close tag to file or string.
<MAPPING ..NAME='xxxx'.. > some data </MAPPING>
the solution I want to apply for more similar tags.
Lets says output of the <MAPPING ..NAME='xxxx'.. > some data </MAPPING> can have below data inside. again I want repeats same steps to get the SESSIONTRANS to data.
<SESSIONTRANS NAME=’XXXX’>some data</SESSIONTRANS>
<FIELDS NAME=’xxxx’>somedata</FIELDS>

In simple words.
Step 1 : Capture data from 2 different lines to file as said above .ex. File name= k4.txt
Repeat Step1: in K4.txt to get other tags data. Example <SESSIONTRANS NAME=’XXX’ >some data</ SESSIONTRANS >
This will go on like wise to capture all required properties.

Sorry but i don't get it, could you please provide and example of what final output you expect ?

Here is the sample input file.

<MAPPING DESCRIPTION='' ISVALID='YES' NAME='m_UPROCS_DEPENDENCIES_LST' OBJECTVERSION='1' VERSIONNUMBER='2'>
<TRANSFORMATION DESCRIPTION='' NAME='SQ_M_UPROCS_DEPENDENCIES_LST' OBJECTVERSION='1' REUSABLE='NO' TYPE='Source Qualifier' VERSIONNUMBER='2'>
<TASK DESCRIPTION='' NAME='EventWait' REUSABLE='NO' TYPE='Event Wait' VERSIONNUMBER='2'>
<ATTRIBUTE NAME='Target load type' VALUE='Bulk'/>
</TASK>
</MAPPING>
<MAPPING DESCRIPTION='' ISVALID='YES' NAME='m_RULE_INFO' OBJECTVERSION='1' VERSIONNUMBER='2'>
<TRANSFORMATION DESCRIPTION='' NAME='SQ_M_RULE_INFO' OBJECTVERSION='1' REUSABLE='NO' TYPE='Targer Defination' VERSIONNUMBER='2'>
<TASK DESCRIPTION='' NAME='EventWait' REUSABLE='NO' TYPE='Event Wait' VERSIONNUMBER='2'>
<ATTRIBUTE NAME='Target load type' VALUE='Null'/>
</TASK>
</MAPPING>


sample OutPut:

Mapping Name,Transformation name,TRANSFORMATION TYPE,TASK NAME,TASK TYPE,TARGET LOAD TYPE
m_UPROCS_DEPENDENCIES_LST,SQ_M_UPROCS_DEPENDENCIES_LST,Source Qualifier,EventWait,Event Wait,Bulk
m_RULE_INFO,SQ_M_RULE_INFO,Targer Defination,EventWait,Event Wait,Null