Sponsored Content
Full Discussion: Print lines meet requirement
Top Forums UNIX for Dummies Questions & Answers Print lines meet requirement Post 302921776 by RudiC on Monday 20th of October 2014 09:14:17 AM
Old 10-20-2014
Why doesn't "8269229412" show up thrice in your sample output file?

Try (adapting your own approach):
Code:
awk     'NR==FNR        {h[$1] = $0; next}
         $1 in h        {print h[$1],$NF; N[$1]}
         END            {for (i in h) if (!(i in N)) print h[i]}
        ' FS=\| OFS=\| file1 file2
8269229289|CROATIA|LUX|1100100020
8269229289|CROATIA|LUX|1100100122
8269229412|ASIA|LUX|1100100128
8269229412|ASIA|LUX|1100100195
8269229412|ASIA|LUX|1100100202
8269229355|LANE|LUX|1100100550
8269229484|EGYPT|LUX|1100100568
8269229484|EGYPT|LUX|1100100612
8269229371|EUROPE|LUX
8269229469|SWISS|LUX
8269229477|HAMBURG|LUX
8269229485|GERMANY|LUX
8269229498|CROATIA|LUX

@Akshay Hegde: your approach seems to print extra lines:
Code:
8269229289|CROATIA|LUX|
8269229289|CROATIA|LUX|1100100020
8269229289|CROATIA|LUX|1100100122
etc.


Last edited by RudiC; 10-20-2014 at 10:21 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

print lines AFTER lines cointaining a regexp (or print every first and fourth line)

Hi all, This should be very easy but I can't figure it out... I have a file that looks like this: @SRR057408.1 FW8Y5CK02R652T length=34 AGCAGTGGTATCAACGCAGAGTAAGCAGTGGTAT +SRR057408.1 FW8Y5CK02R652T length=34 FIIHFF6666?=:88@@@BBD:::?@ABBAAA>8 @SRR057408.2 FW8Y5CK02TBMHV length=52... (1 Reply)
Discussion started by: kmkocot
1 Replies

2. Shell Programming and Scripting

print first few lines, then apply regex on a specific column to print results.

abc.dat tty cpu tin tout us sy wt id 0 0 7 3 19 71 extended device statistics r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device 0.0 133.2 0.0 682.9 0.0 1.0 0.0 7.2 0 79 c1t0d0 0.2 180.4 0.1 5471.2 3.0 2.8 16.4 15.6 15 52 aaaaaa1-xx I want to skip first 5 line... (4 Replies)
Discussion started by: kchinnam
4 Replies

3. UNIX for Dummies Questions & Answers

Count when meet requirement

I have my file input Land,A,091374346294,Cathay,165 Island,B,091370291502,Cathay,3325 Island,P,091366545904,Cathay,440 Island,C,091368476591,Cathay,99000 Land,A,091379924879,Cathay,0 Land,P,091378222275,Cathay,245 Water,X,091369911459,Cathay,0 Island,B,091377596759,Cathay,0... (5 Replies)
Discussion started by: radius
5 Replies

4. UNIX for Dummies Questions & Answers

awk - (URGENT!) Print lines sort and move lines if match found

URGENT HELP IS NEEDED!! I am looking to move matching lines (01 - 07) from File1 and 77 tab the matching string from File2, to File3.txt. I am almost done but - Currently, script is not printing lines to File3.txt in order. - Also the matching lines are not moving out of File1.txt ... (1 Reply)
Discussion started by: High-T
1 Replies

5. Shell Programming and Scripting

awk to print matching lines in files that meet critera

In the tab delimited files below I am trying to match $2 in file1 to $2 of file2. If a match is found the awk checks $3 of file2 and if it is greater than 40% and $4 of file2 is greater than 49, the line in file1 is printed. In the desired output line3 of file1 is not printed because $3 off file2... (9 Replies)
Discussion started by: cmccabe
9 Replies

6. 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

7. Shell Programming and Scripting

awk to capture lines that meet either condition

I am trying to modify and understand an awk written by @Scrutinizer The below awk will filter a list of 30,000 lines in the tab-delimited file. What I am having trouble with is adding a condition to SVTYPE=CNV that will only print that line if CI=,0.95: portion in blue in file is <1.9. The... (2 Replies)
Discussion started by: cmccabe
2 Replies

8. Shell Programming and Scripting

Print header and lines that meet both conditions in awk

In the awk below I am trying to print only the header lines starting with # or ## and the lines that $7 is PASS and AF= is less than 5%. The awk does execute but returns an empty file and I am not sure what I am doing wrong. Thank you. file ... (0 Replies)
Discussion started by: cmccabe
0 Replies

9. Shell Programming and Scripting

awk to print lines that meet conditions and have value in another file

I am trying to use awk to print lines that satisfy either of the two conditions below: condition 1: $2 equals CNV and the split of $3, the value in red, is greater than or equal to 4. ---- this is a or so I think condition 2: $2 equals CNV and the split of $3, the value in red --- this is a... (4 Replies)
Discussion started by: cmccabe
4 Replies

10. UNIX for Beginners Questions & Answers

Print number of lines for files in directory, also print number of unique lines

I have a directory of files, I can show the number of lines in each file and order them from lowest to highest with: wc -l *|sort 15263 Image.txt 16401 reference.txt 40459 richtexteditor.txt How can I also print the number of unique lines in each file? 15263 1401 Image.txt 16401... (15 Replies)
Discussion started by: spacegoose
15 Replies
GENDERGENDER(3) 							 1							   GENDERGENDER(3)

The GenderGender class

INTRODUCTION
CLASS SYNOPSIS
GenderGender GenderGender Constants o const integer$GenderGender::IS_FEMALE70 o const integer$GenderGender::IS_MOSTLY_FEMALE102 o const integer$GenderGender::IS_MALE77 o const integer$GenderGender::IS_MOSTLY_MALE109 o const integer$GenderGender::IS_UNISEX_NAME63 o const integer$GenderGender::IS_A_COUPLE67 o const integer$GenderGender::NAME_NOT_FOUND32 o const integer$GenderGender::ERROR_IN_NAME69 o const integer$GenderGender::ANY_COUNTRY0 o const integer$GenderGender::BRITAIN1 o const integer$GenderGender::IRELAND2 o const integer$GenderGender::USA3 o const integer$GenderGender::SPAIN4 o const integer$GenderGender::PORTUGAL5 o const integer$GenderGender::ITALY6 o const integer$GenderGender::MALTA7 o const integer$GenderGender::FRANCE8 o const integer$GenderGender::BELGIUM9 o const integer$GenderGender::LUXEMBOURG10 o const integer$GenderGender::NETHERLANDS11 o const integer$GenderGender::GERMANY12 o const integer$GenderGender::EAST_FRISIA13 o const integer$GenderGender::AUSTRIA14 o const integer$GenderGender::SWISS15 o const integer$GenderGender::ICELAND16 o const integer$GenderGender::DENMARK17 o const integer$GenderGender::NORWAY18 o const integer$GenderGender::SWEDEN19 o const integer$GenderGender::FINLAND20 o const integer$GenderGender::ESTONIA21 o const integer$GenderGender::LATVIA22 o const integer$GenderGender::LITHUANIA23 o const integer$GenderGender::POLAND24 o const integer$GenderGender::CZECH_REP25 o const integer$GenderGender::SLOVAKIA26 o const integer$GenderGender::HUNGARY27 o const integer$GenderGender::ROMANIA28 o const integer$GenderGender::BULGARIA29 o const integer$GenderGender::BOSNIA30 o const integer$GenderGender::CROATIA31 o const integer$GenderGender::KOSOVO32 o const integer$GenderGender::MACEDONIA33 o const integer$GenderGender::MONTENEGRO34 o const integer$GenderGender::SERBIA35 o const integer$GenderGender::SLOVENIA36 o const integer$GenderGender::ALBANIA37 o const integer$GenderGender::GREECE38 o const integer$GenderGender::RUSSIA39 o const integer$GenderGender::BELARUS40 o const integer$GenderGender::MOLDOVA41 o const integer$GenderGender::UKRAINE42 o const integer$GenderGender::ARMENIA43 o const integer$GenderGender::AZERBAIJAN44 o const integer$GenderGender::GEORGIA45 o const integer$GenderGender::KAZAKH_UZBEK46 o const integer$GenderGender::TURKEY47 o const integer$GenderGender::ARABIA48 o const integer$GenderGender::ISRAEL49 o const integer$GenderGender::CHINA50 o const integer$GenderGender::INDIA51 o const integer$GenderGender::JAPAN52 o const integer$GenderGender::KOREA53 Methods o public boolean GenderGender::connect (string $dsn) o public GenderGender::__construct ([string $dsn]) o public array GenderGender::country (integer $country) o public integer GenderGender::get (string $name, [integer $country]) o public array GenderGender::isNick (string $name0, string $name1, [integer $country]) o public array GenderGender::similarNames (string $name, [integer $country]) PREDEFINED CONSTANTS
o GenderGender::IS_FEMALE - o GenderGender::IS_MOSTLY_FEMALE - o GenderGender::IS_MALE - o GenderGender::IS_MOSTLY_MALE - o GenderGender::IS_UNISEX_NAME - o GenderGender::IS_A_COUPLE - o GenderGender::NAME_NOT_FOUND - o GenderGender::ERROR_IN_NAME - o GenderGender::ANY_COUNTRY - o GenderGender::BRITAIN - o GenderGender::IRELAND - o GenderGender::USA - o GenderGender::SPAIN - o GenderGender::PORTUGAL - o GenderGender::ITALY - o GenderGender::MALTA - o GenderGender::FRANCE - o GenderGender::BELGIUM - o GenderGender::LUXEMBOURG - o GenderGender::NETHERLANDS - o GenderGender::GERMANY - o GenderGender::EAST_FRISIA - o GenderGender::AUSTRIA - o GenderGender::SWISS - o GenderGender::ICELAND - o GenderGender::DENMARK - o GenderGender::NORWAY - o GenderGender::SWEDEN - o GenderGender::FINLAND - o GenderGender::ESTONIA - o GenderGender::LATVIA - o GenderGender::LITHUANIA - o GenderGender::POLAND - o GenderGender::CZECH_REP - o GenderGender::SLOVAKIA - o GenderGender::HUNGARY - o GenderGender::ROMANIA - o GenderGender::BULGARIA - o GenderGender::BOSNIA - o GenderGender::CROATIA - o GenderGender::KOSOVO - o GenderGender::MACEDONIA - o GenderGender::MONTENEGRO - o GenderGender::SERBIA - o GenderGender::SLOVENIA - o GenderGender::ALBANIA - o GenderGender::GREECE - o GenderGender::RUSSIA - o GenderGender::BELARUS - o GenderGender::MOLDOVA - o GenderGender::UKRAINE - o GenderGender::ARMENIA - o GenderGender::AZERBAIJAN - o GenderGender::GEORGIA - o GenderGender::KAZAKH_UZBEK - o GenderGender::TURKEY - o GenderGender::ARABIA - o GenderGender::ISRAEL - o GenderGender::CHINA - o GenderGender::INDIA - o GenderGender::JAPAN - o GenderGender::KOREA - PHP Documentation Group GENDERGENDER(3)
All times are GMT -4. The time now is 04:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy