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
wmanager
WMANAGER(1) BSD General Commands Manual WMANAGER(1)NAME
wmanager -- choose a window manager and launch it
SYNOPSIS
wmanager [OPTIONS ...]
DESCRIPTION
The wmanager program displays a choice of the window managers listed in the ~/.wmanagerrc file. When one is picked, the related command is
written to standard output, intended to be used by shell scripts. If the program is exited without choosing a window manager, ``-1'' is
written to standard output.
-fg COLOR
Set the foreground color.
-bg COLOR
Set the background color.
-bg2 COLOR
Set the widget background color
-di[splay] host:n.n
Set the X display.
-dn[d], -nod[nd]
Enable/disable drag & drop, probably does nothing.
-g[eometry] WxH+X+Y
Set the window size and location.
-i[conic]
Start as iconified.
-k[bd], -nok[bd]
Enable/disable keyboard support.
-na[me] CLASSNAME
Set the X window class.
-s[cheme] SCHEME
Unknown, probably does nothing useful.
-ti[tle] WINDOWTITLE
Set the window title.
-to[oltips], -not[ooltips]
Enable/disable tooltips, probably does nothing.
EXAMPLE
To start using wmanager, create a ~/.wmanagerrc file - generally with wmanagerrc-update(1) - and add something like the following at the end
of your ~/.xsession file:
WM="$(wmanager -geometry +570+585)"
...
exec $WM
See also wmanager-loop(1) for a nicer way to start wmanager.
SEE ALSO wmanager(1), wmanager-loop(1), wmanagerrc-update(1), X(7x)HISTORY
The wmanager program was written by Meik Tessmer in 1999. This manual page was originally written in perldoc format by Tommi Virtanen in
2000, and converted to mdoc format by Peter Pentchev in 2008.
AUTHORS
The wmanager program - Meik Tessmer <fuller@daemogorgon.net>.
The manual page - Tommi Virtanen <tv@debian.org> and Peter Pentchev <roam@ringlet.net>.
BSD May 22, 2008 BSD