Sponsored Content
Top Forums Shell Programming and Scripting Want to implement VLOOKUP (Excel function) in Unix Post 302194919 by era on Wednesday 14th of May 2008 02:45:02 AM
Old 05-14-2008
Worked for me here, did you copy+paste correctly? Does Ygor's code work better for you?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

VLOOKUP utility in UNIX

Kindly help me to build the script similar to VLOOKUP function of MS Excell. (5 Replies)
Discussion started by: hjoshi
5 Replies

2. Programming

How to implement polling for a function using timer in C?

Hi, Can you please help me in implementing a timer based polling for function in C? ie. the function should be called in say 30secs(when 30secs has lapsed). Thanks (7 Replies)
Discussion started by: naan
7 Replies

3. Shell Programming and Scripting

Help require for vLookup Utility same as in EXCEL

Hi guys, can someone please help me with a vlookup utility in shell script that does the work similar to Excel. Ex: If File1.txt is 1 2 11 4 12 and File2.txt is 1 tab1 2 tab2 3 tab3 4 tab4 5 tab5 then the utility should create File3.txt with the below mentioned output: (24 Replies)
Discussion started by: viveklgupta007
24 Replies

4. UNIX for Dummies Questions & Answers

Implement the '&&' function in a shell

Hello, I'm currently implementing the && function in a shell using C. For example, if we input cmd1 && cmd2, then cmd2 executes only when cmd1 exits successfully. I'm thinking about: int main() { int i; char **args; while(1) { printf("yongfeng's shell:~$ "); args =... (5 Replies)
Discussion started by: Yongfeng
5 Replies

5. Shell Programming and Scripting

awk script to perform an action similar to vlookup between two csv files in UNIX

Hi, I am new to awk/unix and am trying to put together an awk script to perform an action similar to vlookup between the two csv files. Here are the contents of the two files: File 1: Date,ParentID,Number,Area,Volume,Dimensions 2014-01-01,ABC,247,83430.33,857.84,8110.76... (9 Replies)
Discussion started by: Prit Siv
9 Replies

6. UNIX for Dummies Questions & Answers

Command for vlookup function

Hello experts, I have large text files that need to be arranged using a function like excel's vlookup. I have been playing with awk command but didn't really come up with a solution. Could anyone please help me out? Below are my datasets and expected output. Any help would be greatly... (8 Replies)
Discussion started by: makelifeeasier
8 Replies

7. Shell Programming and Scripting

Trying to implement count_collatz_step function

Can anyone give me a clue why this code doesn't work as expected? The function count_collatz_step() take one parameter which a number that need to calculate collatz until it reaches 1. The func should return steps it takes. # # Count steps of collatz conjecture takes, until the number reach 1.... (8 Replies)
Discussion started by: Bunchhieng
8 Replies

8. Shell Programming and Scripting

Excel vlookup function like value mapping with awk

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

9. UNIX for Beginners Questions & Answers

Vlookup on 2 files - inserting vlookup command on another command

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

How to compare two files in UNIX using similar to vlookup?

Hi, I want to compare same column in two files, if values match then display the column or display "NA". Ex : File 1 : 123 abc xyz pqr File 2: 122 aab fdf pqr fff qqq rrr (1 Reply)
Discussion started by: hkoshekay
1 Replies
App::Nopaste::Command(3pm)				User Contributed Perl Documentation				App::Nopaste::Command(3pm)

NAME
App::Nopaste::Command - command-line utility for App::Nopaste nopaste - command-line utility to nopaste DESCRIPTION
This application will take some text on STDIN and give you a URL on STDOUT. You may also specify files as arguments, they will be concatenated together into one large nopaste. OPTIONS
-d, --desc The one line description of your paste. The default is usually the first few characters of your text. -n, --name Your nickname, usually displayed with the paste. Default: $NOPASTE_NICK then $USER. -l, --lang The language of the nopaste. The values accepted depend on the nopaste service. There is no mapping done yet. Default: perl. -c, --chan The channel for the nopaste, not always relevant. Usually tied to a pastebot in that channel which will announce your paste. -s, --services The nopaste services to try, in order. You may also specify this in $NOPASTE_SERVICES (space-separated list of service names, e.g. "Shadowcat Gist"). -L, --list List available nopaste services. -x, --copy If specified, automatically copy the URL to your clipboard, using the Clipboard module. -p, --paste If specified, use only the clipboard as input, using the Clipboard module. -o, --open If specified, automatically open the URL using Browser::Open. Browser::Open tries a number of different browser commands depending on your OS. --private If specified, the paste access will be restricted to those that know the URL. -q, --quiet If specified, do not warn or complain about broken services. perl v5.14.2 2011-08-26 App::Nopaste::Command(3pm)
All times are GMT -4. The time now is 03:31 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy