11-30-2010
re vlookup
Thankyou very much. It worked well!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
i am facing a problem in merging two files using awk,
the problem is as stated below,
file1:
A|B|C|D|E|F|G|H|I|1
M|N|O|P|Q|R|S|T|U|2
AA|BB|CC|DD|EE|FF|GG|HH|II|1
....
....
....
file2 :
1|Mn|op|qr (2 Replies)
Discussion started by: shashi1982
2 Replies
2. Shell Programming and Scripting
Hello,
I have a application software plink. It can merge files with some kinds of way.
The command likes:
plink --file 1 --merge 2 --recode --out merged
That means merge file 1 and 2 then output file "merged".
However I have 23 files (1,2,3,...22,23)to be merged together. How can I use... (2 Replies)
Discussion started by: zhshqzyc
2 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
Hi,
My requirement is,there is a directory location like:
:camp/current/
In this location there can be different flat files that are generated in a single day with same header and the data will be different, differentiated by timestamp, so i need to verify how many files are generated... (10 Replies)
Discussion started by: srikanth_sagi
10 Replies
5. Shell Programming and Scripting
Dear Gents,
Please I need your help... I need small script :) to do the following.
I have a thousand of files in a folder produced daily.
I need first to merge all files called. txt (0009.txt, 0010.txt, 0011.txt) and and to output a resume of all information on 2 separate files in csv... (14 Replies)
Discussion started by: jiam912
14 Replies
6. Shell Programming and Scripting
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
7. Shell Programming and Scripting
I need to vlookup and check the server not found.
Source file 1
server1
server2
server3
server4
server5_root
server6_silver
server7
server7-test
server7-temp
Source file 2
server1_bronze (6 Replies)
Discussion started by: ranjancom2000
6 Replies
8. Shell Programming and Scripting
File1
alias:server1_00,20:f1:0a:25:b5:03:02:90
alias:server2_00,20:f1:0a:25:b5:03:02:91
alias:server3_00,50:00:09:75:50:0d:bd:da
alias:server4_00,20:f1:0a:25:b5:03:02:93
alias:server5_00,21:00:00:24:ff:8b:e1:fe
alias:server6_00,50:00:09:75:50:08:54:44... (17 Replies)
Discussion started by: ranjancom2000
17 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 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
LEARN ABOUT ULTRIX
pnmdepth
pnmdepth(1) General Commands Manual pnmdepth(1)
NAME
pnmdepth - change the maxval in a portable anymap
SYNOPSIS
pnmdepth newmaxval [pnmfile]
DESCRIPTION
Reads a portable anymap as input. Scales all the pixel values, and writes out the image with the new maxval. Scaling the colors down to a
smaller maxval will result in some loss of information.
Be careful of off-by-one errors when choosing the new maxval. For instance, if you want the color values to be five bits wide, use a max-
val of 31, not 32.
One important use of pnmdepth is to convert a new format 2-byte-per-sample PNM file to the older 1-byte-per-sample format. Before April
2000, essentially all raw (binary) format PNM files had a maxval less than 256 and one byte per sample, and many programs may rely on that.
If you specify a newmaxval less than 256, the resulting file should be readable by any program that worked with PNM files before April
2000.
SEE ALSO
pnm(5), ppmquant(1), ppmdither(1)
AUTHOR
Copyright (C) 1989, 1991 by Jef Poskanzer.
08 April 2000 pnmdepth(1)