Sponsored Content
Top Forums Shell Programming and Scripting Help With AWK Matching and Re-printing Lines Post 302634557 by rhoderidge on Thursday 3rd of May 2012 01:15:56 PM
Old 05-03-2012
Help With AWK Matching and Re-printing Lines

Hi All,

I'm looking to use AWK to pattern match lines in XML file - Example patten for below sample would be /^<apple>/
The sample I wrote out is very basic compared to what I am actually working with but it will get me started
I would like to keep the matched line(s) unchanged but have them re-printed third line up from the bottom of file
If a previous line was already printed it would just get pushed up one by the next line to be printed.
There will always be at least 1 line to match but any number is possible after that
The newly re-printed line(s) tags need to be unique - a number or anything, really, would work.
I'm using GNU AWK on Windows XP to be put in a batch script. One-liner would be great if possible.
I've ordered a couple AWK books but by the time I figure this out I'll be an older old man.
Thank you in advance for any ideas.

Input:

Code:
<Request>
<Products>
<orange>Florida</orange>
<apple>Macintosh</apple>
<banana>Chiquita</banana>
<pineapple>Dole</pineapple>
<apple>Granny Smith</apple>
<corn>Green Giant</corn>
<peas>Birdseye</peas>
</Products>
</Request>

Output:

Code:
<Request>
<Products>
<orange>Florida</orange>
<apple>Macintosh</apple>
<banana>Chiquita</banana>
<pineapple>Dole</pineapple>
<apple>Granny Smith</apple>
<corn>Green Giant</corn>
<peas>Birdseye</peas>
<apple1>Macintosh</apple1>
<apple2>Granny Smith</apple2>
</Products>
</Request>

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Printing lines with specific awk NF

I have this files: ./frm/lf_mt1_cd.Ic_cell_template.attr ./die/addgen_tb_pumd.Ic_cell_template.attr ./min_m1_n.Ic_cell_template.attr When I use: awk -F\/ '{print NF}' Would result to: 3 3 2 I would like to list the files with 3 fields on it. Any Suggestions? (1 Reply)
Discussion started by: jehrome_rando
1 Replies

2. Shell Programming and Scripting

printing two lines in awk as two columns in excel

hi guys, i would like to print two lines from a file as two adjacent columns using excel using awk.. i have this so far: awk '{for(i=1; i<=NF; i++) {printf("%s\n",$i)}}' "$count".ttt > "$count".csv #this to print the first line from the .ttt file as rows of the first column in the .csv... (9 Replies)
Discussion started by: npatwardhan
9 Replies

3. Shell Programming and Scripting

Printing entire field, if at least one row is matching by AWK

Dear all, I have been trying to print an entire field, if the first line of the field is matching. For example, my input looks something like this. aaa ddd zzz 123 987 126 24 0.650 985 354 9864 0.32 0.333 4324 000 I am looking for a pattern,... (5 Replies)
Discussion started by: Chulamakuri
5 Replies

4. Shell Programming and Scripting

fgrep not printing non matching lines

I'm using this: fgrep -f file1.txt file2.txt To find lines in file1 that match patterns found in file2. When I add -v: egrep -v -f file1.txt file2.txt It won't return non matching lines, I just get a blank. Can anyone help? PS. file1.txt contains 3 million lines...each string... (2 Replies)
Discussion started by: Nonito84
2 Replies

5. Shell Programming and Scripting

Matching and printing line with awk

Hi there, I'm trying to use awk to print out the entire line that contains a match to a certain regex and then append some text,plus the match to the end of the line. So far I have: awk -F: '{print "RG:Z:" $2}' file Which prints out the match I want plus the additional text, but I'm stuck... (3 Replies)
Discussion started by: jim_lad
3 Replies

6. 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 (11 Replies)
Discussion started by: essem
11 Replies

7. Shell Programming and Scripting

UNIX awk pattern matching and printing lines

I have the below plain text file where i have some result, in order to mail that result in html table format I have written the below script and its working well. cat result.txt Page 2015-01-01 2000 Colors 2015-02-01 3000 Landing 2015-03-02 4000 #!/bin/sh LOG=/tmp/maillog.txt... (1 Reply)
Discussion started by: close2jay
1 Replies

8. Shell Programming and Scripting

awk - printing new lines based of 2 dates

I have some test data that is seperated out into annual records, each record has a start date (COL7), an end date (COL8) and a maturity date (COL18) - What I need to do is ensure that there is one record to cover each year right up until Maturity date (COL18). In the first group of the below... (10 Replies)
Discussion started by: Ads89
10 Replies

9. Shell Programming and Scripting

awk to combine matching lines in file

I am trying to combine all matching lines in the tab-delimited using awk. The below runs but no output results. Thank you :). input chrX 110925349 110925532 ALG13 chrX 110925349 110925532 ALG13 chrX 110925349 110925532 ALG13 chrX 47433390 47433999 SYN1... (3 Replies)
Discussion started by: cmccabe
3 Replies

10. UNIX for Beginners Questions & Answers

Continued trouble matching fields in different files and selective field printing ([g]awk)

I apologize in advance, but I continue to have trouble searching for matches between two files and then printing portions of each to output in awk and would very much appreciate some help. I have data as follows: File1 PS012,002 PRQ 0 1 1 17 1 0 -1 3 2 1 2 -1 ... (7 Replies)
Discussion started by: jvoot
7 Replies
getOpenFile(3)						User Contributed Perl Documentation					    getOpenFile(3)

NAME
getOpenFile, getSaveFile - pop up a dialog box for the user to select a file to open or save. SYNOPSIS
$widget->getOpenFile(?-option=>value, ...>?) $widget->getSaveFile(?-option=>value, ...>?) DESCRIPTION
The methods getOpenFile and getSaveFile pop up a dialog box for the user to select a file to open or save. The getOpenFile method is usually associated with the Open command in the File menu. Its purpose is for the user to select an existing file only. If the user enters an non-existent file, the dialog box gives the user an error prompt and requires the user to give an alternative selection. If an application allows the user to create new files, it should do so by providing a separate New menu command. The getSaveFile method is usually associated with the Save as command in the File menu. If the user enters a file that already exists, the dialog box prompts the user for confirmation whether the existing file should be overwritten or not. If the user selects a file, both getOpenFile and getSaveFile return the full pathname of this file. If the user cancels the operation, both commands return an undefined value. The following option-value pairs are possible as command line arguments to these two commands: -defaultextension => extension Specifies a string that will be appended to the filename if the user enters a filename without an extension. The default value is the empty string, which means no extension will be appended to the filename in any case. This option is ignored on the Macintosh platform, which does not require extensions to filenames, and the UNIX implementation guesses reasonable values for this from the -filetypes option when this is not supplied. -filetypes => [filePattern ?, ...?] If a File types listbox exists in the file dialog on the particular platform, this option gives the filetypes in this listbox. When the user choose a filetype in the listbox, only the files of that type are listed. If this option is unspecified, or if it is set to the empty list, or if the File types listbox is not supported by the particular platform then all files are listed regardless of their types. See "SPECIFYING FILE PATTERNS" below for a discussion on the contents of filePatterns. -initialdir => directory Specifies that the files in directory should be displayed when the dialog pops up. If this parameter is not specified, then the files in the current working directory are displayed. This option may not always work on the Macintosh. This is not a bug. Rather, the General Controls control panel on the Mac allows the end user to override the application default directory. -initialfile => filename Specifies a filename to be displayed in the dialog when it pops up. This option is ignored by the getOpenFile method. -multiple Allows the user to choose multiple files from the Open dialog. On the Macintosh, this is only available when Navigation Services are installed. -message => string Specifies a message to include in the client area of the dialog. This is only available on the Macintosh, and only when Navigation Services are installed. -title => titleString Specifies a string to display as the title of the dialog box. If this option is not specified, then a default title is displayed. This option is ignored on the Macintosh platform. SPECIFYING FILE PATTERNS
The filePatterns given by the -filetypes option are a list of file patterns. Each file pattern is a list of the form typeName [extension ?extension ...?] ?[macType ?macType ...?]? typeName is the name of the file type described by this file pattern and is the text string that appears in the File types listbox. extension is a file extension for this file pattern. macType is a four-character Macintosh file type. The list of macTypes is optional and may be omitted for applications that do not need to execute on the Macintosh platform. Several file patterns may have the same typeName, in which case they refer to the same file type and share the same entry in the listbox. When the user selects an entry in the listbox, all the files that match at least one of the file patterns corresponding to that entry are listed. Usually, each file pattern corresponds to a distinct type of file. The use of more than one file patterns for one type of file is necessary on the Macintosh platform only. On the Macintosh platform, a file matches a file pattern if its name matches at least one of the extension(s) AND it belongs to at least one of the macType(s) of the file pattern. For example, the C Source Files file pattern in the sample code matches with files that have a .c extension AND belong to the macType TEXT. To use the OR rule instead, you can use two file patterns, one with the extensions only and the other with the macType only. The GIF Files file type in the sample code matches files that EITHER have a .gif extension OR belong to the macType GIFF. On the Unix and Windows platforms, a file matches a file pattern if its name matches at at least one of the extension(s) of the file pattern. The macTypes are ignored. SPECIFYING EXTENSIONS
On the Unix and Macintosh platforms, extensions are matched using glob-style pattern matching. On the Windows platforms, extensions are matched by the underlying operating system. The types of possible extensions are: (1) the special extension * matches any file; (2) the special extension "" matches any files that do not have an extension (i.e., the filename contains no full stop character); (3) any character string that does not contain any wild card characters (* and ?). Due to the different pattern matching rules on the various platforms, to ensure portability, wild card characters are not allowed in the extensions, except as in the special extension *. Extensions without a full stop character (e.g, ~) are allowed but may not work on all platforms. CAVEATS
See "CAVEATS" in Tk::chooseDirectory. EXAMPLE
my $types = [ ['Text Files', ['.txt', '.text']], ['TCL Scripts', '.tcl' ], ['C Source Files', '.c', 'TEXT'], ['GIF Files', '.gif', ], ['GIF Files', '', 'GIFF'], ['All Files', '*', ], ]; my $filename = $widget->getOpenFile(-filetypes=>$types); if ($filename ne "") { # Open the file ... } SEE ALSO
Tk::FBox, Tk::FileSelect KEYWORDS
file selection dialog perl v5.12.1 2007-11-08 getOpenFile(3)
All times are GMT -4. The time now is 03:16 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy