Help fixing awk code to print values from 2 files Post: 302564948

Sponsored Content

Top Forums Shell Programming and Scripting Help fixing awk code to print values from 2 files Post 302564948 by Ophiuchus on Saturday 15th of October 2011 04:23:24 PM

10-15-2011

Registered User

Hi birei,

Many thatnks for your reply, it works just perfect!! thank you, thank you.

Only one more thing to finish, how to write in a shorter way the "print part" using "printf"?
I need to print what I already have and 2 more lines at the beginning and one at the end as follow.
(the blue lines are what I need to add, the lines in red are those I want to write in a better way using Printf.
I want to learn how to do it within the same awk code)

Code:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
    <si><t>Report</t></si>
    <si><t>Tittle</t></si>
    <si><t>Number</t></si>
    <si><t>Address</t></si>
    <si><t>Date</t></si>
    <si><t>Description</t></si>
    <si><t>Title 1 and 2</t></si>
    <si><t>Title 1</t></si>
    <si><t>No. 1234</t></si>
    <si><t>Address 1</t></si>
    <si><t>October 07, 2009</t></si>
    <si><t>Some text</t></si>
    <si><t>Title 2</t></si>
    <si><t>No. 457</t></si>
    <si><t>Address 2</t></si>
    <si><t>October 15, 2009</t></si>
    <si><t>Some text</t></si>
    <si><t>Report o</t></si>
    <si><t>Report t</t></si>
    <si><t>Report u</t></si>
    <si><t>Report x</t></si>
    <si><t>Report y</t></si>
</sst>

Many thanks again for your help.

Grettings

Last edited by Ophiuchus; 10-15-2011 at 05:32 PM..

Ophiuchus

View Public Profile for Ophiuchus

Find all posts by Ophiuchus

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk to print distinct col values

Hi Guys... I am newbie to awk and would like a solution to probably one of the simple practical questions. I have a test file that goes as: 1,2,3,4,5,6 7,2,3,8,7,6 9,3,5,6,7,3 8,3,1,1,1,1 4,4,2,2,2,2 I would like to know how AWK can get me the distinct values say for eg: on col2...

2. Shell Programming and Scripting

Print a key with its all values using awk/others

input COL1 a1 b1 c1 d1 e1 f1 C1 10 10 10 100 100 1000 C2 20 20 200 200 200 2000 output C1 a1 10 1 C1 b1 10 1 C1 c1 10 1 C1 d1 100 2 C1 e1 100 2 C1 f1 1000 3 C2 ...

3. UNIX for Advanced & Expert Users

Awk to print values of second file

Hello, I have a data file with 300,000 records in it, and another file which contains only the line numbers of roughly 13,000 records in the data file which have data integrity issues. I'm trying to find a way to print the original data by line number identified in the second file. How can I do...

4. Shell Programming and Scripting

Compare values in two files. For matching rows print corresponding values from File 1 in File2.

- I have two files (File 1 and File 2) and the contents of the files are mentioned below. - I am trying to compare the values of Column1 of File1 with Column1 of File2. If a match is found, print the corresponding value from Column2 of File1 in Column5 of File2. - I tried to modify and use...

5. Shell Programming and Scripting

Print minimum and maximum values using awk

Can I print the minimum and maximum values of values in first 4 columns ? input 3038669 3038743 3037800 3038400 m101c 3218627 3218709 3217600 3219800 m290 ............. output 3037800 3038743 m101c 3217600 3219800 m290

6. Shell Programming and Scripting

How to print in awk matching $1 values ,to $1,$4 example given.?

Hi Experts, I am trying to get the output from a matching pattern but unable to construct the awk command: file : aa bb cc 11 dd aa cc 33 cc 22 45 68 aa 33 44 44 dd aa cc 37 aa 33 44 67 I want the output to be : ( if $1 match to "aa" start of the line,then print $4 of that line, and...

7. Shell Programming and Scripting

awk print odd values

value=$(some command) for all in `echo $value` do awk checks each value (all) to see if it is a odd number. if so, prints the value done sounds easy enough but i've been unable to find anything on google.

8. Shell Programming and Scripting

Print values within groups of lines with awk

Hello to all, I'm trying to print the value corresponding to the words A, B, C, D, E. These words could appear sometimes and sometimes not inside each group of lines. Each group of lines begins with "ZYX". My issue with current code is that should print values for 3 groups and only is...

9. Shell Programming and Scripting