|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Vlookup using Ask from specific column from two files
Post 303014807 by RudiC on Wednesday 21st of March 2018 09:51:29 AM
03-21-2018
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I have two files, one is 1.6 GB. I would like to add one extra column of information to the large file at a specific location. After its 2nd column.
For example:
File 1 has two columns more than 1000 rows like this
MM009987 1
File 2 looks like this
MM00098 MM00076 3 4 2 4 2 1... (1 Reply)
Discussion started by: sogi
1 Replies
2. 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
3. Shell Programming and Scripting
Hi all, I'm needing help again on scripting. I have weekly files with 3 columns, and I need to do monthly averaging on the values on column 3, the file naming convention is as follows:
20000105.u- 2000:year 01:month 05:day
20000112.u
20000119.u
20000126.u
20000202.u
20020209.u
I need to... (15 Replies)
Discussion started by: ida1215
15 Replies
4. Shell Programming and Scripting
hello!
i need a little help from you :) ... i need to split a file into separate files depending on two conditions using scripting. The file has no delimiters. The conditions are col 17 = "P" and col 81 = "*", this will go to one output file; col 17 = "R" and col 81 = " ". Here is an example.
... (3 Replies)
Discussion started by: chanclitas
3 Replies
5. Shell Programming and Scripting
Dear all,
I have many files(.csv) in a directory.
I want to concatenate the files which have similar entries in a particular column and save into a new file like result_datetime.csv etc.
One example file is like below.
Sno,Step,Data1,Data2,Data3 etc.
1,0,2,3,4
2,1,3,4,5
3,2,0,1,1
... (4 Replies)
Discussion started by: ks_reddy
4 Replies
6. Shell Programming and Scripting
Hi everybody,
I have a folder with many files:
Files with 8 columns:
X 123 A B C D E F
And files with 7 columns:
X1234 A B C D E F
I am trying to find a way to extract the 5th column when the files have eight columns, or the 4th column when the files have... (3 Replies)
Discussion started by: Tzole
3 Replies
7. Shell Programming and Scripting
I have an xml file dumped from rrd file, that I want to "patch" so the xml file doesn't contain any blank hole in the resulting graph of the rrd file.
Here is the file.
<!-- 2015-10-12 14:00:00 WIB / 1444633200 --> <row><v> 4.0419731265e+07 </v><v> 4.5045912770e+06... (2 Replies)
Discussion started by: rk4k
2 Replies
8. Shell Programming and Scripting
Input file1
frame1,dummy,server1, 00C1C N/A RDF1+TDEV RW 51789
frame1,dummy,server1, 00C1D N/A RDF1+TDEV RW 51789
frame1,dummy,server1, 00C1E N/A RDF1+TDEV RW 51789
frame1,dummy,server1, 00C1F N/A RDF1+TDEV RW 51789
frame1,dummy,server1, 00C20 N/A RDF1+TDEV RW 51789
frame1,dummy,server1,... (10 Replies)
Discussion started by: ranjancom2000
10 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
file1:
Name,Threshold,Curr Samples,Curr Error%,Curr ART
GETHome,100,21601,0.00%,47
GETregistry,100,21592,0.00%,13
GEThomeLayout,100,30466,0.00%,17
file2:
Name,Threshold,Curr Samples,Curr Error%,Curr ART
GETHome,100,21601,0.00%,33
GETregistry,100,21592,0.00%,22... (6 Replies)
Discussion started by: Raghuram717
6 Replies
LEARN ABOUT REDHAT
protate
PROTATE(1) General Commands Manual PROTATE(1) NAME
protate - rotate a RADIANCE picture. SYNOPSIS
protate [ -c ][ -r ] input [ output ] DESCRIPTION
Protate rotates a RADIANCE picture 90 degrees. This is useful for output on hardcopy devices with aspect ratios opposite to the input pic- ture. By default, the image is rotated clockwise. The -r option may be used to rotate the image counter-clockwise instead. The -c option indicates that the action is to correct an improper original image orientation, thus the recorded scanline ordering should not be changed. NOTES
To rotate an image 180 degrees, use pflip(1) with both the -h and -v options. AUTHOR
Greg Ward SEE ALSO
getinfo(1), pcompos(1), pfilt(1), pflip(1), psign(1), rpict(1) RADIANCE
10/27/98 PROTATE(1)