Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: metaphilex
- Order by date
-
fileA a x b, fileB a x c, how to get a file which is a x b x c
PHV, thanks I like the idea " ara[$1,++ara2[$1]]=$0 ", creative and inspiring. It is much faster.- metaphilex
- Post #6
- Forum: AWK
-
fileA a x b, fileB a x c, how to get a file which is a x b x c
Hi, Annihilannnic my code, as below, is not efficient since it takes a really long time to run on two large-size input files. I am sure there must be much more efficient coding than I did. awk 'BEGIN { FS=OFS="\t"} NR==FNR{ara[$1,$2]=$0;ara2[$1]=1; next} { if(ara2[$1]) { for(s in ara) {...- metaphilex
- Post #3
- Forum: AWK
-
fileA a x b, fileB a x c, how to get a file which is a x b x c
Hi, all FileA (each firm has two records) firm1 rec1 firm1 rec2 firm2 rec1 firm2 rec2 FileB (each firm owned by two institutions) firm1 ppf1 firm2 ppf1 firm1 ppf2 firm2 ppf2 I want to do a "firm x records x owner" expansion (if the first field in each row of fileB is the same as the first...- metaphilex
- Thread
- Replies: 5
- Forum: AWK
