07-14-2009
ok ..But why you missed the "aF0" matched value from inputfile2 in output.
Last edited by panyam; 07-15-2009 at 02:12 AM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am a new learner of join command. Some result really make me confused.
Please kindly help me.
input:
file1:
LEO oracle engineer 210375
P.Jones Office Runner ID897
L.Clip Personl Chief ID982
S.Round UNIX admin ID6
file2:
Dept2C ID897 6 years
Dept5Z ID982 1 year
Dept3S ID6 2... (1 Reply)
Discussion started by: summer_cherry
1 Replies
2. Programming
example sql:
select a.a1,b.b1,c.c1,d.d1,e.e1
from a
left outer join b on a.x=b.x
left outer join c on b.y=c.y
left outer join d on d.z=a.z
inner join a.t=e.t
I know how single outer or inner join works in sql.
But I don't really understand when there are multiple of them.
can... (0 Replies)
Discussion started by: robbiezr
0 Replies
3. UNIX for Dummies Questions & Answers
Hello,
My apologies if this has been posted elsewhere, I have had a look at several threads but I am still confused how to use these functions. I have two files, each with 5 columns:
File A: (tab-delimited)
PDB CHAIN Start End Fragment
1avq A 171 176 awyfan
1avq A 172 177 wyfany
1c7k A 2 7... (3 Replies)
Discussion started by: InfoSeeker
3 Replies
4. Shell Programming and Scripting
Hi all,
I am tryin to join two files, duplicating the alues from the first one as many times as the second.
File one :
11 211
File two:
a
b
c
Result:
11 211 a
11 211 b
11 211 c
Any advise will be apreciate.
Thanks (3 Replies)
Discussion started by: valigula
3 Replies
5. Shell Programming and Scripting
Hi,
Please help me to convert the input file to a new one.
input file:
--------
1231231231 3 A
4561223343 0 D
1231231231 1 A
1231231231 2 A
1231231231 4 D
7654343444 2 A
4561223343 1 D
4561223343 2 D
the output should be:
--------------------
1231231231 3#1#2 A
4561223343 0 D... (3 Replies)
Discussion started by: vsachan
3 Replies
6. UNIX for Dummies Questions & Answers
file1:
Toronto:12439755:1076359:July 1, 1867:6
Quebec City:7560592:1542056:July 1, 1867:5
Halifax:938134:55284:July 1, 1867:4
Fredericton:751400:72908:July 1, 1867:3
Winnipeg:1170300:647797:July 15, 1870:7
Victoria:4168123:944735:July 20, 1871:10
Charlottetown:137900:5660:July 1, 1873:2... (2 Replies)
Discussion started by: mindfreak
2 Replies
7. Shell Programming and Scripting
- I have two files (File 1 and File 2) and the contents of the files are mentioned below.
- I am trying to compare the values of Column1 of File1 with Column1 of File2. If a match is found, print the corresponding value from Column2 of File1 in Column5 of File2.
- I tried to modify and use... (10 Replies)
Discussion started by: Santoshbn
10 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have 20 tab delimited text files that have a common column (column 1). The files are named GSM1.txt through GSM20.txt. Each file has 3 columns (2 other columns in addition to the first common column).
I want to write a script to join the files by the first common column so that in the... (5 Replies)
Discussion started by: evelibertine
5 Replies
9. UNIX for Dummies Questions & Answers
Hi, I'm a beginner in awk script. I've been trying to figure how to concatenate two string in input file using awk after the value is calculated.
I'm trying to get this format
Apple 5.2(10) Orange 4.4(8)
Watermelon 3.10(30) Berries 10.2(20)
The input file with the format
fruit... (2 Replies)
Discussion started by: KCApple
2 Replies
10. Shell Programming and Scripting
Hello,
This post is already here but want to do this with another way
Merge multiples files with multiples duplicates keys by filling "NULL" the void columns for anothers joinning files
file1.csv:
1|abc
1|def
2|ghi
2|jkl
3|mno
3|pqr
file2.csv:
1|123|jojo
1|NULL|bibi... (2 Replies)
Discussion started by: yjacknewton
2 Replies
LEARN ABOUT DEBIAN
dctable
DCTABLE(1) DICOM PS3 - Make tables of attribute values DCTABLE(1)
NAME
dctable - ACR/NEMA DICOM PS3 ... DICOM PS3 - Make tables of attribute values
SYNOPSIS
dctable " inputfile1 [ inputfile2 ... ]" [ -ignorereaderrors ] [ -v|verbose ] [ -r|recurse ] [ -describe ] [ -nofilename ] [ -noembed-
dedquotes ] [ -key|k elementname|(0xgggg,0xeeee) ] ... [ -input-nometa ] [ -input-ts uid ] [ -input-default ] [ -input-byte-
order|-input-endian big|little ] [ -input-vr implicit|explicit ]
DESCRIPTION
dctable reads the named dicom input files and creates a tab delimited table of the values of the selected attributes, with each value
enclosed in double quotes.
Binary attributes are written in hexadecimal with a preceding "0x". Numeric string attributes are written in decimal.
The first column always contains the filenames.
A header is a added only if the -describe option is specified.
If a specified attribute is not present in a file, then it the corresponding entry in the table will be empty (i.e. two consecutive quotes"
but this is not reported as an error.
OPTIONS
The table of attribute values go to standard output, and the verbose output and errors go to standard error.
The basic input switches are described in dcintro(1). Options specific to this program are:
-describe
Add a first line of output that is a header describing the attributes in each column.
-nofilename
Do not include the filename in the table.
-noembeddedquotes
Remove embedded quotes (") from within displayed values to allow them to be parsed consistenty later; also has the side effect of
displaying numeric binary values as decimal rather than hexadecimal.
-k|key elementname|(0xgggg,0xeeee)
Add a key to the list of attributes to be extracted. The attribute may also be specified as a hexadecimal pair of the form
(0xgggg,0xeeee), which also allows private attributes to be fetched.
-r|recurse
If any attribute is not found in the top level dataset, recurse through sequence attribute items until the first instance is found.
This is a depth-first traversal, i.e., all children of the first item of a sequence are searched before the sibling items.
-ignorereaderrors
Attempt to extract key values even if errors encountered whilst parsing DICOM file.
ENVIRONMENT
EXAMPLES
% dctable -k Rows -k Columns
-describe test.dc3
"Filename" "Rows" "Columns"
"test.dc3" "0x0100" "0x0100"
FILES
SEE ALSO
dcintro(1),dckey(1)
AUTHOR
Copyright (C) 2012. David A. Clunie. All rights reserved.
BUGS
Attempts to extract sequences or OB,OW attributes may fail nastily.
The order in which the attributes are extracted and written is not the same order as they are specified on the command line, and should not
be depended on.
DICOM PS3 28 March 2012 DCTABLE(1)