01-04-2013
im running this through Cygwin
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Kindly help me to build the script similar to VLOOKUP function of MS Excell. (5 Replies)
Discussion started by: hjoshi
5 Replies
2. 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
3. Shell Programming and Scripting
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)
Discussion started by: sandeep78
2 Replies
4. Shell Programming and Scripting
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)
Discussion started by: Sabari Nath S
1 Replies
5. 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
6. Shell Programming and Scripting
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)
Discussion started by: Anamika08
1 Replies
7. 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
8. 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
9. 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
10. 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
LEARN ABOUT OSX
inline-support5.16
Inline-Support(3) User Contributed Perl Documentation Inline-Support(3)
NAME
Inline-Support - Support Information for Inline.pm and related modules.
DESCRIPTION
This document contains all of the latest support information for "Inline.pm" and the recognized Inline Language Support Modules (ILSMs)
available on CPAN.
SUPPORTED LANGUAGES
The most important language that Inline supports is "C". That is because Perl itself is written in "C". By giving a your Perl scripts
access to "C", you in effect give them access to the entire glorious internals of Perl. (Caveat scriptor :-)
As of this writing, Inline also supports:
- C++
- Java
- Python
- Tcl
- Assembly
- CPR
- And even Inline::Foo! :)
Projects that I would most like to see happen in the year 2001 are:
- Fortran
- Ruby
- Lisp
- Guile
- Bash
- Perl4
SUPPORTED PLATFORMS
"Inline::C" should work anywhere that CPAN extension modules (those that use XS) can be installed, using the typical install format of:
perl Makefile.PL
make
make test
make install
It has been tested on many Unix and Windows variants.
NOTE: "Inline::C" requires Perl 5.005 or higher because "Parse::RecDescent" requires it. (Something to do with the "qr" operator)
Inline has been successfully tested at one time or another on the following platforms:
Linux
Solaris
SunOS
HPUX
AIX
FreeBSD
OpenBSD
BeOS
OS X
WinNT
Win2K
WinME
Win98
Cygwin
The Microsoft tests deserve a little more explanation. I used the following:
Windows NT 4.0 (service pack 6)
Perl 5.005_03 (ActiveState build 522)
MS Visual C++ 6.0
The "nmake" make utility (distributed w/ Visual C++)
"Inline::C" pulls all of its base configuration (including which "make" utility to use) from "Config.pm". Since your MSWin32 version of
Perl probably came from ActiveState (as a binary distribution) the "Config.pm" will indicate that "nmake" is the system's "make" utility.
That is because ActiveState uses Visual C++ to compile Perl.
To install "Inline.pm" (or any other CPAN module) on MSWin32 w/ Visual C++, use these:
perl Makefile.PL
nmake
nmake test
nmake install
Inline has also been made to work with Mingw32/gcc on all Windows platforms. This is a free compiler for Windows. You must also use a perl
built with that compiler.
The "Cygwin" test was done on a Windows 98 machine using the Cygwin Unix/Win32 porting layer software from Cygnus. The "perl" binary on
this machine was also compiled using the Cygwin tool set ("gcc"). This software is freely available from http://sources.redhat.com/cygwin/
If you get Inline to work on a new platform, please send me email email. If it doesn't work, let me know as well and I'll see what can be
done.
SEE ALSO
For general information about Inline see Inline.
For information about using Inline with C see Inline::C.
For sample programs using Inline with C see Inline::C-Cookbook.
For information on writing your own Inline Language Support Module, see Inline-API.
Inline's mailing list is inline@perl.org
To subscribe, send email to inline-subscribe@perl.org
AUTHOR
Brian Ingerson <INGY@cpan.org>
COPYRIGHT
Copyright (c) 2000-2002. Brian Ingerson.
Copyright (c) 2008, 2010, 2011. Sisyphus.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
See http://www.perl.com/perl/misc/Artistic.html
perl v5.16.2 2012-10-08 Inline-Support(3)