awk to print specific line in file based on criteria


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk to print specific line in file based on criteria
# 8  
Old 09-26-2016
I'm not sure that I fully understand what you're trying to do, but I think the following comes close to what you have described:
Code:
awk -F'"[]},:]* *"*' -v RS='{' '
# Function to extract the portion of the data associated with the Alignments
# tag that is to be printed.
function pA(arg,	string) {
	string = arg
	sub(/_R_.*/, "", string)
	return string
}
{	for(i = 2; i < NF - 1; i++) {
		# Look for a "path" entry with the desired "plugin" value.
		if($i == "path") {
			if($(i + 2) == "plugin" &&
			   $(i + 3) == "/rundb/api/v1/plugin/49/") {
				# Set found flag to indicate that we have found
				# a path to be processed.
				found = 1

				# Print the selected path.
				print (u = $(i+1)) "    -- path from " FILENAME

				# Grab the "_user_[^_]*" string from the
				# selected path.
				sub(/.*_user_/, "", u)
				sub(/_.*/, "", u)
				sub(/^/, "user_", u)

				# Skip next 4 fields.
				i += 3
			}
			continue
		}
		if(found == 1) {
			if($i == "Aligned Reads" && index($(i + 1), u)) {
				# We found an Aligned Reads element with the
				# correct user.  Print it, set found to
				# indicate that we have found both a path and
				# an Aligned Reads, and skip over next field.
				print $(i+1) "    -- Aligned Reads from " \
				    FILENAME
				found = 2
				i++
			}
			continue
		}
		if(found == 2)
			if($i == "Alignments")
				print pA($(i+1)) "    -- Alignments from " \
				    FILENAME
			else if($i  == "Sample Name")
				print $(i+1) "    -- Sample Name from " FILENAME
			else if($i == "Aligned Reads")
				# We have found a new Aligned Reads, clear the
				# found flag until we find another matching
				# path.
				found = 0
	}
}' index.html

which, with your sample index.html file produces the output:
Code:
/results/analysis/output/Home/Auto_user_S5-00580-4-Medexome_65_028/plugin_out/FileExporter_out.52    -- path from index.html
R_2016_09_01_10_24_52_user_S5-00580-4-Medexome    -- Aligned Reads from index.html
IonXpress_004    -- Alignments from index.html
MEV42    -- Sample Name from index.html
IonXpress_005    -- Alignments from index.html
MEV43    -- Sample Name from index.html
IonXpress_006    -- Alignments from index.html
MEV44    -- Sample Name from index.html

If you want to reverse the output from the Sample Name and Alignments (as shown in one of your other recent threads), that could be done with a change to two lines in this script.

Does this give you what you wanted?

As always, if someone wants to try this on a Solaris/SunOS system, they would need to change awk in this script to /usr/xpg4/bin/awk or nawk.
This User Gave Thanks to Don Cragun For This Post:
# 9  
Old 09-29-2016
Yes, it works great.... thank you very much Smilie.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Awk/sed/cut to filter out records from a file based on criteria

I have two files and would need to filter out records based on certain criteria, these column are of variable lengths, but the lengths are uniform throughout all the records of the file. I have shown a sample of three records below. Line 1-9 is the item number "0227546_1" in the case of the first... (15 Replies)
Discussion started by: MIA651
15 Replies

2. Shell Programming and Scripting

awk to print line based on two keywords

I am starting to write a multi-line awk and using the file below which is tab-delimited, print only the line with oncomineGeneClass and oncomineVariantClass and PASS. The script execute but seems to be printing the entire file, not the desired line. Thank you :). file ... (8 Replies)
Discussion started by: cmccabe
8 Replies

3. Shell Programming and Scripting

Need a Linux command for find/replace column based on specific criteria.

I'm new to shell programming, I have a huge text file in the following format, where columns are separated by single space: ACA MEX 4O_ $98.00 $127.40 $166.60 0:00 0:00 0 ; ACA YUL TS_ $300.00 $390.00 $510.00 0:00 0:00 0 ; ACA YYZ TS_ $300.00 $390.00 $510.00 0:00 0:00 0 ; ADZ YUL TS_ $300.00... (3 Replies)
Discussion started by: transat
3 Replies

4. Shell Programming and Scripting

Only print specific xml values that meet two criteria in python

I have a large XML file that I want to parse, and only print one specific value if two values are met. This is the code so far: #!/usr/local/bin/python import xml.etree.ElementTree as ET tree = ET.parse('onedb-dhcp.xml') root = tree.getroot() # This successfully gets all... (1 Reply)
Discussion started by: brianjb
1 Replies

5. Shell Programming and Scripting

Extract error records based on specific criteria from Unix file

Hi, I look for a awk one liner for below issue. input file ABC 1234 abc 12345 ABC 4567 678 XYZ xyz ght 678 ABC 787 yyuu ABC 789 7890 777 zxr hyip hyu mno uii 678 776 ABC ty7 888 All lines should be started with ABC as first field. If a record has another value for 1st... (7 Replies)
Discussion started by: ratheesh2011
7 Replies

6. Shell Programming and Scripting

Passing parameter in sed or awk commands to print for the specific line in a file

Hi, I am trying to print a specific line in a file through sed or awk. The line number will be passed as a parameter from the previous step. My code looks as below. TEMP3=`sed -n '$TEMP2p' $FILEPATH/Log.txt` $TEMP2, I am getting from the previous step which is a numerical value(eg:3). ... (2 Replies)
Discussion started by: satyasrin82
2 Replies

7. Shell Programming and Scripting

AWK Print Line If Specific Character Is Matched

Hello, I have a file as such: FFFFFFF6C000000 225280 225240 - - rwxs- FFFFFFFF79C00000 3240 3240 - - rwxs- FFFFFFFF7A000000 4096 4096 - - rwxs- FFFFFFFF7A400000 64 64 ... (3 Replies)
Discussion started by: PointyWombat
3 Replies

8. Shell Programming and Scripting

Extract data based on specific search criteria

I have a huge file (about 2 millions records) contains data separated by “,” (comma). As part of the requirement, I can't change the format. The objective is to remove some of the records with the following condition. If the 23rd field on each line start with 302 , I need to remove that from the... (4 Replies)
Discussion started by: jaygamini
4 Replies

9. Shell Programming and Scripting

Append specific lines to a previous line based on sequential search criteria

I'll try explain this as best I can. Let me know if it is not clear. I have large text files that contain data as such: 143593502 09-08-20 09:02:13 xxxxxxxxxxx xxxxxxxxxxx 09-08-20 09:02:11 N line 1 test line 2 test line 3 test 143593503 09-08-20 09:02:13... (3 Replies)
Discussion started by: jesse
3 Replies

10. Shell Programming and Scripting

To print a specific line in Shell or awk.

Hi, I want to echo the 15th line from a file named as abc.txt, also i want to echo only the values in that line not the line number. Thanks in advance:) (4 Replies)
Discussion started by: tushar_tus
4 Replies
Login or Register to Ask a Question