Sponsored Content
Full Discussion: Join values
Top Forums Shell Programming and Scripting Join values Post 302333931 by panyam on Tuesday 14th of July 2009 10:28:20 AM
Old 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

join (pls help on join command)

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

sql,multiple join,outer join issue

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

Join 2 files with multiple columns: awk/grep/join?

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

Join two files values duplciating first file

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

join rows based on the column values

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

how to join two files using "Join" command with one common field in this problem?

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

Compare values in two files. For matching rows print corresponding values from File 1 in File2.

- 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

How to use the the join command to join multiple files by a common column

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

awk - How to join the string with values

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

Join, merge, fill NULL the void columns of multiples files like sql "LEFT JOIN" by using awk

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
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)
All times are GMT -4. The time now is 06:04 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy