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)
Hi,
I am trying to find a way to read an excel work book with multiple worksheets.
And write each worksheet into a new excel file using perl. My environment is Unix.
For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Hi,
I need to zip/compress a data file and send to a vendor. The vendor does have only unzip utility and can accept only .ZIP files. I do not have zip utility in my server.
How do I zip/compress the file so that it can be deflated using unzip command ? I tried gzip & compress commands, but... (1 Reply)
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)
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
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)
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)
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
LEARN ABOUT DEBIAN
app::nopaste::command
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)