Deleting lines on matching certain pattern Post: 302944867

Sponsored Content

Top Forums Shell Programming and Scripting Deleting lines on matching certain pattern Post 302944867 by sunnyboy on Friday 22nd of May 2015 11:18:21 PM

05-23-2015

Registered User

Hi

What I have done is a i have taken a output of the xml query and generated this xml using a script however in the xml wherever there is more than 2 child i have this problem which i could not resolve

I'm sorry for the large example ,For easier understanding
I have cut a portion of the earlier xml . What i'm looking for is if the 3 rd line after the tag
</invoices> (Only the closing tag which i have made in bold) is

<portCode> then no need to do any action but if it is

<invoiceSerialNo> then i have to delete the line
</invoices> and the next line
</shippingBill>

Code:

<discountAmtIC>0</discountAmtIC>          <closeOfBillIndicator>1</closeOfBillIndicator>          <remitterName>SOLIDARIDAD Y TRABAJO</remitterName>          <remitterCountry>ES</remitterCountry>         </invoice>       </invoices>     </shippingBill>     <shippingBill>        <portCode>INDIG6</portCode>        <exportType>1</exportType>        <recordIndicator>1</recordIndicator>        <shippingBillNo>7627181</shippingBillNo>        <shippingBillDate>05/02/2015</shippingBillDate>        <formNo></formNo>        <LEODate>05/02/2015</LEODate>        <adCode>0242412</adCode>        <ebrcNumber>N41EXCU150730003</ebrcNumber>     <invoices>      <invoice>          <invoiceSerialNo>1</invoiceSerialNo>          <invoiceNo>2015EUEX000000043</invoiceNo>          <invoiceDate></invoiceDate>          <realizationStatus>2</realizationStatus>          <FIRCNumber></FIRCNumber>          <FIRCADCode></FIRCADCode>          <realizedCurrencyCode>USD</realizedCurrencyCode>          <realizationDate>23/04/2015</realizationDate>          <accountNumber></accountNumber>          <bankingChargesAmt>25</bankingChargesAmt>          <FOBAmt>11551.68</FOBAmt>          <FOBAmtIC>11526.68</FOBAmtIC>          <freightAmt>573.95</freightAmt>          <freightAmtIC>573.95</freightAmtIC>          <insuranceAmt>3.63</insuranceAmt>          <insuranceAmtIC>3.63</insuranceAmtIC>          <commissionAmt>0</commissionAmt>          <commissionAmtIC>0</commissionAmtIC>          <packagingChargesAmt>0</packagingChargesAmt>          <packagingChargesAmtIC>0</packagingChargesAmtIC>          <deductionAmt>0</deductionAmt>          <deductionAmtIC>0</deductionAmtIC>          <discountAmt>0</discountAmt>          <discountAmtIC>0</discountAmtIC>          <closeOfBillIndicator>2</closeOfBillIndicator>          <remitterName>CONCENTRIC ITASCA INC</remitterName>          <remitterCountry>US</remitterCountry>         </invoice>      <invoice>          <invoiceSerialNo>3066846</invoiceSerialNo>          <invoiceNo>DC-G/NSEZ/364/14-15</invoiceNo>          <invoiceDate>02/01/2015</invoiceDate>          <realizationStatus>2</realizationStatus>          <FIRCNumber></FIRCNumber>          <FIRCADCode></FIRCADCode>          <realizedCurrencyCode>USD</realizedCurrencyCode>          <realizationDate>24/04/2015</realizationDate>          <accountNumber></accountNumber>          <bankingChargesAmt>0</bankingChargesAmt>          <FOBAmt>1292.15</FOBAmt>          <FOBAmtIC>1292.15</FOBAmtIC>          <freightAmt>10</freightAmt>          <freightAmtIC>200</freightAmtIC>          <insuranceAmt>1</insuranceAmt>          <insuranceAmtIC>1</insuranceAmtIC>          <commissionAmt>0</commissionAmt>          <commissionAmtIC>0</commissionAmtIC>          <packagingChargesAmt>0</packagingChargesAmt>          <packagingChargesAmtIC>0</packagingChargesAmtIC>          <deductionAmt>0</deductionAmt>          <deductionAmtIC>0</deductionAmtIC>          <discountAmt>0</discountAmt>          <discountAmtIC>0</discountAmtIC>          <closeOfBillIndicator>2</closeOfBillIndicator>          <remitterName>HISTOIRE D OR SA</remitterName>          <remitterCountry>FR</remitterCountry>         </invoice>       <discountAmtIC>0</discountAmtIC>          <closeOfBillIndicator>1</closeOfBillIndicator>          <remitterName>SOLIDARIDAD Y TRABAJO</remitterName>          <remitterCountry>ES</remitterCountry>         </invoice>       </invoices>     </shippingBill>     <shippingBill>        <portCode>INDIG6</portCode>        <exportType>1</exportType>        <recordIndicator>1</recordIndicator>        <shippingBillNo>7627181</shippingBillNo>        <shippingBillDate>05/02/2015</shippingBillDate>        <formNo></formNo>        <LEODate>05/02/2015</LEODate>        <adCode>0242412</adCode>        <ebrcNumber>N41EXCU150730003</ebrcNumber>     <invoices>     <invoice>         <invoiceSerialNo>1</invoiceSerialNo>          <invoiceNo>2015EUEX000000043</invoiceNo>          <invoiceDate></invoiceDate>          <realizationStatus>2</realizationStatus>          <FIRCNumber></FIRCNumber>          <FIRCADCode></FIRCADCode>          <realizedCurrencyCode>USD</realizedCurrencyCode>          <realizationDate>23/04/2015</realizationDate>          <accountNumber></accountNumber>          <bankingChargesAmt>25</bankingChargesAmt>          <FOBAmt>11551.68</FOBAmt>          <FOBAmtIC>11526.68</FOBAmtIC>          <freightAmt>573.95</freightAmt>          <freightAmtIC>573.95</freightAmtIC>          <insuranceAmt>3.63</insuranceAmt>          <insuranceAmtIC>3.63</insuranceAmtIC>          <commissionAmt>0</commissionAmt>          <commissionAmtIC>0</commissionAmtIC>          <packagingChargesAmt>0</packagingChargesAmt>          <packagingChargesAmtIC>0</packagingChargesAmtIC>          <deductionAmt>0</deductionAmt>          <deductionAmtIC>0</deductionAmtIC>          <discountAmt>0</discountAmt>          <discountAmtIC>0</discountAmtIC>          <closeOfBillIndicator>2</closeOfBillIndicator>          <remitterName>CONCENTRIC ITASCA INC</remitterName>          <remitterCountry>US</remitterCountry>         </invoice>      <invoice>          <invoiceSerialNo>3066846</invoiceSerialNo>          <invoiceNo>DC-G/NSEZ/364/14-15</invoiceNo>          <invoiceDate>02/01/2015</invoiceDate>          <realizationStatus>2</realizationStatus>          <FIRCNumber></FIRCNumber>          <FIRCADCode></FIRCADCode>          <realizedCurrencyCode>USD</realizedCurrencyCode>          <realizationDate>24/04/2015</realizationDate>          <accountNumber></accountNumber>          <bankingChargesAmt>0</bankingChargesAmt>          <FOBAmt>1292.15</FOBAmt>          <FOBAmtIC>1292.15</FOBAmtIC>          <freightAmt>10</freightAmt>          <freightAmtIC>200</freightAmtIC>          <insuranceAmt>1</insuranceAmt>          <insuranceAmtIC>1</insuranceAmtIC>          <commissionAmt>0</commissionAmt>          <commissionAmtIC>0</commissionAmtIC>          <packagingChargesAmt>0</packagingChargesAmt>          <packagingChargesAmtIC>0</packagingChargesAmtIC>          <deductionAmt>0</deductionAmt>          <deductionAmtIC>0</deductionAmtIC>          <discountAmt>0</discountAmt>          <discountAmtIC>0</discountAmtIC>          <closeOfBillIndicator>2</closeOfBillIndicator>          <remitterName>HISTOIRE D OR SA</remitterName>          <remitterCountry>FR</remitterCountry>         </invoice>       </invoices>     </shippingBill>      <invoice>          <invoiceSerialNo>3066850</invoiceSerialNo>          <invoiceNo>DC-G/NSEZ/365/14-15</invoiceNo>       </shippingBill>      <invoice>          <invoiceSerialNo>3066850</invoiceSerialNo>          <invoiceNo>DC-G/NSEZ/365/14-15</invoiceNo>

Last edited by Don Cragun; 05-23-2015 at 12:47 AM.. Reason: Add CODE tags.

sunnyboy

View Public Profile for sunnyboy

Find all posts by sunnyboy

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

counting the lines matching a pattern, in between two pattern, and generate a tab

Hi all, I'm looking for some help. I have a file (very long) that is organized like below: >Cluster 0 0 283nt, >01_FRYJ6ZM12HMXZS... at +/99% 1 279nt, >01_FRYJ6ZM12HN12A... at +/99% 2 281nt, >01_FRYJ6ZM12HM4TS... at +/99% 3 283nt, >01_FRYJ6ZM12HM946... at +/99% 4 279nt,...

2. Shell Programming and Scripting

sed: deleting 5 lines after a specified pattern

As an example (just an example, this could apply to any block of text) say I have this: architecture x86_64 cputype CPU_TYPE_X86_64 cpusubtype CPU_SUBTYPE_X86_64_ALL offset 4096 size 2972420 align 2^12 (4096) architecture ppc64 cputype CPU_TYPE_POWERPC64 cpusubtype...

3. Shell Programming and Scripting

pattern matching over multiple lines and deleting the first

I've got a longish log file with content such as Uplink traffic: Downlink traffic: I want to parse the log file and remove any line that contains the string "Uplink traffic:" at the beginning of the line, but only if the line following it beginnings with the string "Downlink traffic:" (in...

4. Shell Programming and Scripting

pattern matching lines using the date, and then joining the lines

Hi Guys, Was trying to attempt the below using awk and sed, have no luck so far, so any help would be appreciated. Current Text File: The first line has got an "\n", and the second line has got spaces/tabs then the word and "\n" TIME SERVER/CLIENT TEXT...

5. Shell Programming and Scripting

Finding lines matching the Pattern and their previous lines in a file

Hi, I am trying to locate the occurences of certain pattern like 'Possible network disconnect' in a text file. I can get the actual lines matching the pttern using: grep -w 'Possible network disconnect' file_name. But I am more interested in getting the timing of these events which are...

6. Shell Programming and Scripting

Deleting lines from a stream after matching a pattern

Hi, I have a requirement to to an ldapsearch and remove the shadow attributes in the output file. What I do is ldapsearch() | operation to remove shadow > FILE The ldapsearch gives output like this(with same line formation): objectClass: FSConfig objectClass: extensibleObject fsCAIP:...

7. Shell Programming and Scripting

Deleting a matching string(line) which is also in other lines

Hi, i need help with my shell script I have a file input.txt containing the following contents /. /usr /usr/share /usr/share/doc /usr/share/doc/wine /usr/share/doc/wine/copyright /usr/share/doc/wine/changelog.Debian.gz I need output as /usr/share/doc/wine /usr/share/doc/wine/copyright...

8. Shell Programming and Scripting

Help with a deleting lines based on a pattern

I have a header-detail file that goes like this: SHP00288820131021110921 ORDER0156605920131021110921INMMMMFN DETAIL0004 4C2Z 10769 AAFC 0000009600000094 4C2Z 10769 AAFC 0000672107 OIL DETAIL0002 ER3Z 14300 E 0000001300000012 ER3Z 14300 E 0000672107 OIL...

9. Shell Programming and Scripting

Sed: printing lines AFTER pattern matching EXCLUDING the line containing the pattern

'Hi I'm using the following code to extract the lines(and redirect them to a txt file) after the pattern match. But the output is inclusive of the line with pattern match. Which option is to be used to exclude the line containing the pattern? sed -n '/Conn.*User/,$p' > consumers.txt

10. UNIX for Dummies Questions & Answers

Grep -v lines starting with pattern 1 and not matching pattern 2

Hi all! Thanks for taking the time to view this! I want to grep out all lines of a file that starts with pattern 1 but also does not match with the second pattern. Example: Drink a soda Eat a banana Eat multiple bananas Drink an apple juice Eat an apple Eat multiple apples I...

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

counting the lines matching a pattern, in between two pattern, and generate a tab

Discussion started by: d.chauliac

2. Shell Programming and Scripting

sed: deleting 5 lines after a specified pattern

Discussion started by: pcwiz

3. Shell Programming and Scripting

pattern matching over multiple lines and deleting the first

Discussion started by: Yorkie99

4. Shell Programming and Scripting

pattern matching lines using the date, and then joining the lines

Discussion started by: eo29

5. Shell Programming and Scripting

Finding lines matching the Pattern and their previous lines in a file

Discussion started by: sagarparadkar

6. Shell Programming and Scripting

Deleting lines from a stream after matching a pattern

Discussion started by: lorzinian

7. Shell Programming and Scripting

Deleting a matching string(line) which is also in other lines

Discussion started by: Amit0991

8. Shell Programming and Scripting

Help with a deleting lines based on a pattern

Discussion started by: rbaggio666

9. Shell Programming and Scripting

Sed: printing lines AFTER pattern matching EXCLUDING the line containing the pattern

Discussion started by: essem

10. UNIX for Dummies Questions & Answers

Grep -v lines starting with pattern 1 and not matching pattern 2

Discussion started by: demmel