|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Command for vlookup function
Post 302928653 by makelifeeasier on Saturday 13th of December 2014 04:29:29 PM
12-13-2014
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear All,
i want to implement vookup function which is there in excel into Unix. Suppose i have 2 files. The files are given below.
File1:
MSC Cell SDCA
Patna-1 12 Bihar
Patna-2 45 Ranchi
Bhopal-1 85 Raigarh
Bhopal-2 ... (8 Replies)
Discussion started by: pravani1
8 Replies
2. Shell Programming and Scripting
Hi please help in the below request
Input File 1:
a,1
b,2
c,3
d,4
e,5
f,6
Input File 2:
2
5
3
1
Output Required:
b 2
e 5
c 3 (3 Replies)
Discussion started by: ravin
3 Replies
3. Shell Programming and Scripting
hi frnds
i have 2 files. 1st is dddd and 2nd is ssss
==> dddd <==:
1,charit
2,gilhotra
==> ssss <==:
1,sajan
2,doda
3,hello
and i want o/p ...mean join and vlookup both files
sajan,charit (4 Replies)
Discussion started by: dodasajan
4 Replies
4. Shell Programming and Scripting
Hello,
I am trying to use vlookup (Excel function) using awk but there is some problem :(
--file1--
ABC123
101F
X1 A $P=Z
X2 A $P=X
X3 B $P=F
X4 C $P=G
MNK180
END
--file2--
X1 A_t $P=Z
X2 A_t $P=X
X3 B_u $P=F
X4 C_o $P=G (2 Replies)
Discussion started by: young
2 Replies
5. Shell Programming and Scripting
Hi folks,
awk 'NR==FNR {m=$0; next} $1 in m{$0=m} {print}' file2 file1
Works a charm for a vlookup type query, sourced from https://www.unix.com/shell-programming-and-scripting/215998-vlookup-using-awk.html
However my column content has white spaces and numbers. Example
file1
The Man... (6 Replies)
Discussion started by: pshields1984
6 Replies
6. Shell Programming and Scripting
I have two files
File1
175552 st_497858.1 rs86052.1 rs92185.1 st_001022416.1 174841 175552_174841
179912 st_001122967.2 rs90435.1 rs89122.1 st_001022583.1 175545 179912_175545
179912 st_001122967.2 rs90435.1 rs89122.1 st_001022584.1 175545 179912_175545
179967 st_001256606.1 rs93516.2... (1 Reply)
Discussion started by: sammy777888
1 Replies
7. Shell Programming and Scripting
Hello Everybody
I am looking for vlookup like functionality in Linux since two files I have are very big(1000MB each) and its not opening completely in excel.
Here the requirement
file1
11,12,13
16,14,12
28,21,22
22,23,24 file 3
18,16,16
14,12,12
23,22,24
16,11,13 here... (8 Replies)
Discussion started by: shanul karim
8 Replies
8. Shell Programming and Scripting
Hi everyone,
I need to replace values of column 2 array1 with values of column 2 array2 based on a lookup of column 4 value, but only return a value IF the values in column 1 of BOTH array1 and array2 match, otherwise keep original value in column 2 of array1. Both files are tab delimited... (2 Replies)
Discussion started by: Geneanalyst
2 Replies
9. UNIX for Beginners Questions & Answers
Hello, i am trying to print group name column(etc/group) on script (etc/passwd) since group name is not listed on etc/passwd columns. Im trying to do a vlookup. but i cant figure out how i can insert the vlookup command FNR==NR inside the print out command or the output. I also tried exporting... (2 Replies)
Discussion started by: joonisio
2 Replies
10. UNIX for Beginners Questions & Answers
Hi I just want again to ask for help on what command to use to vlookup f1 group name in "/etc/group" matching f3 of it to "/etc/passwd" f4. I do need to display group name in the output of /etc/passwd without using awk or NR==FNR command. thank you
while
IFS=: read -r f1 f2 f3 f4 f5 f6 f7... (4 Replies)
Discussion started by: joonisio
4 Replies
LEARN ABOUT DEBIAN
datetime::locale::ga
DateTime::Locale::ga(3pm) User Contributed Perl Documentation DateTime::Locale::ga(3pm) NAME
DateTime::Locale::ga - DateTime locale package for "ga" SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'ga' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for Irish. DATA
This locale inherits from the DateTime::Locale::root locale. It contains the following data. Days Wide (format) De Luain De Mairt De Ceadaoin Deardaoin De hAoine De Sathairn De Domhnaigh Abbreviated (format) Luan Mairt Cead Dear Aoine Sath Domh Narrow (format) L M C D A S D Wide (stand-alone) De Luain De Mairt De Ceadaoin Deardaoin De hAoine De Sathairn De Domhnaigh Abbreviated (stand-alone) Luan Mairt Cead Dear Aoine Sath Domh Narrow (stand-alone) L M C D A S D Months Wide (format) Eanair Feabhra Marta Aibrean Bealtaine Meitheamh Iuil Lunasa Mean Fomhair Deireadh Fomhair Samhain Nollaig Abbreviated (format) Ean Feabh Marta Aib Beal Meith Iuil Lun MFomh DFomh Samh Noll Narrow (format) E F M A B M I L M D S N Wide (stand-alone) Eanair Feabhra Marta Aibrean Bealtaine Meitheamh Iuil Lunasa Mean Fomhair Deireadh Fomhair Samhain Nollaig Abbreviated (stand-alone) Ean Feabh Marta Aib Beal Meith Iuil Lun MFomh DFomh Samh Noll Narrow (stand-alone) E F M A B M I L M D S N Quarters Wide (format) 1u raithe 2u raithe 3u raithe 4u raithe Abbreviated (format) R1 R2 R3 R4 Narrow (format) 1 2 3 4 Wide (stand-alone) 1u raithe 2u raithe 3u raithe 4u raithe Abbreviated (stand-alone) R1 R2 R3 R4 Narrow (stand-alone) 1 2 3 4 Eras Wide Roimh Chriost Anno Domini Abbreviated RC AD Narrow RC AD Date Formats Full 2008-02-05T18:30:30 = De Mairt 5 Feabhra 2008 1995-12-22T09:05:02 = De hAoine 22 Nollaig 1995 -0010-09-15T04:44:23 = De Sathairn 15 Mean Fomhair -10 Long 2008-02-05T18:30:30 = 5 Feabhra 2008 1995-12-22T09:05:02 = 22 Nollaig 1995 -0010-09-15T04:44:23 = 15 Mean Fomhair -10 Medium 2008-02-05T18:30:30 = 5 Feabh 2008 1995-12-22T09:05:02 = 22 Noll 1995 -0010-09-15T04:44:23 = 15 MFomh -10 Short 2008-02-05T18:30:30 = 05/02/2008 1995-12-22T09:05:02 = 22/12/1995 -0010-09-15T04:44:23 = 15/09/-010 Default 2008-02-05T18:30:30 = 5 Feabh 2008 1995-12-22T09:05:02 = 22 Noll 1995 -0010-09-15T04:44:23 = 15 MFomh -10 Time Formats Full 2008-02-05T18:30:30 = 18:30:30 UTC 1995-12-22T09:05:02 = 09:05:02 UTC -0010-09-15T04:44:23 = 04:44:23 UTC Long 2008-02-05T18:30:30 = 18:30:30 UTC 1995-12-22T09:05:02 = 09:05:02 UTC -0010-09-15T04:44:23 = 04:44:23 UTC Medium 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 09:05:02 -0010-09-15T04:44:23 = 04:44:23 Short 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 09:05 -0010-09-15T04:44:23 = 04:44 Default 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 09:05:02 -0010-09-15T04:44:23 = 04:44:23 Datetime Formats Full 2008-02-05T18:30:30 = De Mairt 5 Feabhra 2008 18:30:30 UTC 1995-12-22T09:05:02 = De hAoine 22 Nollaig 1995 09:05:02 UTC -0010-09-15T04:44:23 = De Sathairn 15 Mean Fomhair -10 04:44:23 UTC Long 2008-02-05T18:30:30 = 5 Feabhra 2008 18:30:30 UTC 1995-12-22T09:05:02 = 22 Nollaig 1995 09:05:02 UTC -0010-09-15T04:44:23 = 15 Mean Fomhair -10 04:44:23 UTC Medium 2008-02-05T18:30:30 = 5 Feabh 2008 18:30:30 1995-12-22T09:05:02 = 22 Noll 1995 09:05:02 -0010-09-15T04:44:23 = 15 MFomh -10 04:44:23 Short 2008-02-05T18:30:30 = 05/02/2008 18:30 1995-12-22T09:05:02 = 22/12/1995 09:05 -0010-09-15T04:44:23 = 15/09/-010 04:44 Default 2008-02-05T18:30:30 = 5 Feabh 2008 18:30:30 1995-12-22T09:05:02 = 22 Noll 1995 09:05:02 -0010-09-15T04:44:23 = 15 MFomh -10 04:44:23 Available Formats d (d) 2008-02-05T18:30:30 = 5 1995-12-22T09:05:02 = 22 -0010-09-15T04:44:23 = 15 EEEd (d EEE) 2008-02-05T18:30:30 = 5 Mairt 1995-12-22T09:05:02 = 22 Aoine -0010-09-15T04:44:23 = 15 Sath HHmm (HH:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 09:05 -0010-09-15T04:44:23 = 04:44 HHmmss (HH:mm:ss) 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 09:05:02 -0010-09-15T04:44:23 = 04:44:23 Hm (H:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 9:05 -0010-09-15T04:44:23 = 4:44 hm (h:mm a) 2008-02-05T18:30:30 = 6:30 p.m. 1995-12-22T09:05:02 = 9:05 a.m. -0010-09-15T04:44:23 = 4:44 a.m. Hms (H:mm:ss) 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 9:05:02 -0010-09-15T04:44:23 = 4:44:23 hms (h:mm:ss a) 2008-02-05T18:30:30 = 6:30:30 p.m. 1995-12-22T09:05:02 = 9:05:02 a.m. -0010-09-15T04:44:23 = 4:44:23 a.m. M (L) 2008-02-05T18:30:30 = 2 1995-12-22T09:05:02 = 12 -0010-09-15T04:44:23 = 9 Md (d/M) 2008-02-05T18:30:30 = 5/2 1995-12-22T09:05:02 = 22/12 -0010-09-15T04:44:23 = 15/9 MEd (E, M-d) 2008-02-05T18:30:30 = Mairt, 2-5 1995-12-22T09:05:02 = Aoine, 12-22 -0010-09-15T04:44:23 = Sath, 9-15 MMdd (dd/MM) 2008-02-05T18:30:30 = 05/02 1995-12-22T09:05:02 = 22/12 -0010-09-15T04:44:23 = 15/09 MMM (LLL) 2008-02-05T18:30:30 = Feabh 1995-12-22T09:05:02 = Noll -0010-09-15T04:44:23 = MFomh MMMd (MMM d) 2008-02-05T18:30:30 = Feabh 5 1995-12-22T09:05:02 = Noll 22 -0010-09-15T04:44:23 = MFomh 15 MMMEd (E MMM d) 2008-02-05T18:30:30 = Mairt Feabh 5 1995-12-22T09:05:02 = Aoine Noll 22 -0010-09-15T04:44:23 = Sath MFomh 15 MMMMd (d MMMM) 2008-02-05T18:30:30 = 5 Feabhra 1995-12-22T09:05:02 = 22 Nollaig -0010-09-15T04:44:23 = 15 Mean Fomhair MMMMEd (E MMMM d) 2008-02-05T18:30:30 = Mairt Feabhra 5 1995-12-22T09:05:02 = Aoine Nollaig 22 -0010-09-15T04:44:23 = Sath Mean Fomhair 15 mmss (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 ms (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 y (y) 2008-02-05T18:30:30 = 2008 1995-12-22T09:05:02 = 1995 -0010-09-15T04:44:23 = -10 yM (y-M) 2008-02-05T18:30:30 = 2008-2 1995-12-22T09:05:02 = 1995-12 -0010-09-15T04:44:23 = -10-9 yMEd (EEE, y-M-d) 2008-02-05T18:30:30 = Mairt, 2008-2-5 1995-12-22T09:05:02 = Aoine, 1995-12-22 -0010-09-15T04:44:23 = Sath, -10-9-15 yMMM (y MMM) 2008-02-05T18:30:30 = 2008 Feabh 1995-12-22T09:05:02 = 1995 Noll -0010-09-15T04:44:23 = -10 MFomh yMMMEd (EEE, y MMM d) 2008-02-05T18:30:30 = Mairt, 2008 Feabh 5 1995-12-22T09:05:02 = Aoine, 1995 Noll 22 -0010-09-15T04:44:23 = Sath, -10 MFomh 15 yMMMM (y MMMM) 2008-02-05T18:30:30 = 2008 Feabhra 1995-12-22T09:05:02 = 1995 Nollaig -0010-09-15T04:44:23 = -10 Mean Fomhair yQ (y Q) 2008-02-05T18:30:30 = 2008 1 1995-12-22T09:05:02 = 1995 4 -0010-09-15T04:44:23 = -10 3 yQQQ (y QQQ) 2008-02-05T18:30:30 = 2008 R1 1995-12-22T09:05:02 = 1995 R4 -0010-09-15T04:44:23 = -10 R3 yyMM (MM/yy) 2008-02-05T18:30:30 = 02/08 1995-12-22T09:05:02 = 12/95 -0010-09-15T04:44:23 = 09/-10 yyMMM (MMM yy) 2008-02-05T18:30:30 = Feabh 08 1995-12-22T09:05:02 = Noll 95 -0010-09-15T04:44:23 = MFomh -10 yyQ (Q yy) 2008-02-05T18:30:30 = 1 08 1995-12-22T09:05:02 = 4 95 -0010-09-15T04:44:23 = 3 -10 yyyyMM (MM/yyyy) 2008-02-05T18:30:30 = 02/2008 1995-12-22T09:05:02 = 12/1995 -0010-09-15T04:44:23 = 09/-010 yyyyMMMM (MMMM y) 2008-02-05T18:30:30 = Feabhra 2008 1995-12-22T09:05:02 = Nollaig 1995 -0010-09-15T04:44:23 = Mean Fomhair -10 Miscellaneous Prefers 24 hour time? Yes Local first day of the week De Luain SUPPORT
See DateTime::Locale. AUTHOR
Dave Rolsky <autarch@urth.org> COPYRIGHT
Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's license. perl v5.10.1 2010-03-19 DateTime::Locale::ga(3pm)