The following produces the output requested in post #1 from the two input files shown in post #1, but without a clear description explaining the logic that is supposed to be implemented, I have no idea if the actually implements what is desired:
Code:
awk -F'[_-]' '
FNR == NR {
for(i = 1; i <= NF; i++) {
tags[tag = tag $i]
# printf("Added possible tag \"%s\" from \"%s\"\n", tag, $0)
tag = substr($0, 1, length(tag) + 1)
}
tag = ""
next
}
{ print (($0 in tags) ? "" : "notfound ") $0
}' file2 file1
As always, if you're running this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk or nawk.
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)
Thanks Bartus11 for your help in the following code to compare the two files "t1" and "t2".
awk 'NR==FNR{a=1;next}$2 in a{print $2}' t1 t2
First can anyone explain that what is the purpose of assigning a =1?
Second, the current script is printing out the matched columns between the... (4 Replies)
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)
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)
Hi,
Is there possible to do vlookup in Mysql one table from another table based on one column values and placed the data in same table?
if it is possible in mysql itself pls share links for reference.
Here is the ex: i need to vlookup the cus.id in table to and place the cus.name in 4th... (3 Replies)
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)
Code used to find the server from cloum 3 and update needtotakesnap
Output came from above command
awk 'NR==FNR{A;next}$3 in A{$3 = "needtotakesnap " $3}1' /home/Others/active-server.txt /home/Others/all-server |grep server1
879 dummy server1_217_silver dummy 00870 TDEV 2071575
831 Tier1... (3 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)
Hi I just want again to ask for help on what command to use to vlookup f1 group name in "/etc/group" matching f3 of it to "/etc/passwd" f4. I do need to display group name in the output of /etc/passwd without using awk or NR==FNR command. thank you
while
IFS=: read -r f1 f2 f3 f4 f5 f6 f7... (4 Replies)
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 DEBIAN
fdk
FDK(1) Plastimatch FDK(1)NAME
fdk - cone-beam reconstruction from projections using the FDK algorithm
The term FDK refers to the authors Feldkamp, Davis, and Kress who wrote the seminal paper "Practical cone-beam algorithm" in 1984. Their
paper describes a filtered back-projection reconstruction algorithm for cone-beam geometries. The fdk program in plastimatch is an
implmenetation of the FDK algorithm.
FDK USAGE
The fdk program takes a directory of 2D projection images as input, and generates a single 3D volume as output.
The command line usage is:
Usage: fdk [options]
Options:
-A hardware Either "cpu" or "brook" or "cuda" (default=cpu)
-a "num ((num) num)" Use this range of images
-r "r1 r2 r3" Set output resolution (in voxels)
-f filter Either "none" or "ramp" (default=ramp)
-s scale Scale the intensity of the output file
-z "s1 s2 s3" Physical size of the reconstruction (in mm)
-I indir The input directory
-O outfile The output file
-F {F,H} Full or half fan bow-tie filter correction
The usage of the fdk program is best understood by following along with the tutorials: fdk_tutorial_i and fdk_tutorial_ii.
INPUT FILES
Three different formats of input files are supported. These are:
o Pfm format image files with geomtry txt files
o Raw format image files with geomtry txt files
o Varian hnd files
The pfm and raw files are similar, in that they store the image as an array of 4-byte little-endian floats. The only difference is that
the pfm file has a header which stores the image size, and the raw file does not.
Each pfm or raw image file must have a geometry file in the same directory with the .txt extension. For example, if you want to use
image_0000.pfm in a reconstruction, you should supply another file image_0000.txt which contains the geometry. A brief description of the
geometry file format is given in proj_mat_file_format.
The sequence of files should be stored with the pattern:
XXXXYYYY.ZZZ
where XXXX is a prefix, YYYY is a number, and .ZZZ is the extension of a known type (either .hnd, .pfm, or .raw).
For example the following would be a good directory layout for pfm files:
Files/image_00.pfm
Files/image_00.txt
Files/image_01.pfm
Files/image_01.txt
etc...
The Varian hnd files should be stored in the original layout. For example:
Files/ProjectionInfo.xml
Files/Scan0/Proj_0000.hnd
Files/Scan0/Proj_0001.hnd
etc...
No geometry txt files are needed to reconstruct from Varian hnd format.
IMAGE GEOMETRY
By default, when you generate a DRR, the image is oriented as if the virtual x-ray source were a camera. That means that for a right lat-
eral film, the columns of the image go from inf to sup, and the rows go from ant to post. The Varian OBI system produces HND files, which
are oriented differently. For a right lateral film, the columns of the HND images go from ant to post, and the rows go from sup to inf. An
illustration of this idea is shown in the figure below.
[image] Geometry of Varian HND files.UNINDENT
AUTHOR
Plastimatch is a collaborative project. For more documentation, please visit http://plastimatch.org. For questions, comments, and bug
reports, please visit http://groups.google.com/group/plastimatch.
COPYRIGHT
Plastimatch development team (C) 2010-2011. You are free to use, modify, and distribute plastimatch according to a BSD-style license.
Please see LICENSE.TXT for details.
Plastimatch 1.5 June 11, 2011 FDK(1)