Sponsored Content
Top Forums Shell Programming and Scripting how to add the number of row and count number of rows Post 302437356 by juelillo on Wednesday 14th of July 2010 07:15:17 PM
Old 07-14-2010
how to add the number of row and count number of rows

Hi experts a have a very large file and I need to add two columns: the first one numbering the incidence of records and the another with the total count

The input file:
Code:
 21 2341 A 
 21 2341 A 
 21 2341 A
 21 2341 C
 21 2341 C
 21 2341 C
 21 2341 C
 21 4567 A 
 21 4567 A 
 21 4567 C
 21 4567 C
 23 4567 A 
 23 4567 A 
 23 4567 A 
 23 4567 A 
 23 4567 C
 23 4567 C
 23 4567 C

desired output file:

Code:
 21 2341 A 1 3
 21 2341 A 2 3
 21 2341 A 3 3
 21 2341 C 1 4
 21 2341 C 2 4
 21 2341 C 3 4
 21 2341 C 4 4
 21 4567 A 1 2
 21 4567 A 2 2
 21 4567 C 1 2
 21 4567 C 2 2
 23 4567 A 1 4
 23 4567 A 2 4
 23 4567 A 3 4
 23 4567 A 4 4
 23 4567 C 1 3
 23 4567 C 2 3
 23 4567 C 3 3



thanks in advance

Last edited by radoulov; 07-15-2010 at 09:45 AM.. Reason: Code tags, please!
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

row count but only number part

hi i am pretty new to unix .i am ETL guy I need a unix script to take row count of a file and write it to another file the problem with wc-l is it include filename also wc -l abc.dat will give me like 1000 abc.dat i just want 1000 to be written can u just take 2 min to write a simple... (1 Reply)
Discussion started by: er_zeeshan05
1 Replies

2. Shell Programming and Scripting

count number of nonempty columns in row

Hi, Suppose i have a inputfile in csv format. How to use awk to count 'the number of nonempty columns in each row' minus one, and add the value as a new column in the end For cosmetic reason, it's even better to include a descriptive label for the last column in the first row. for... (2 Replies)
Discussion started by: grossgermany
2 Replies

3. UNIX for Dummies Questions & Answers

how to count number of rows and sum of column using awk

Hi All, I have the following input which i want to process using AWK. Rows,NC,amount 1,1202,0.192387 2,1201,0.111111 3,1201,0.123456 i want the following output count of rows = 3 ,sum of amount = 0.426954 Many thanks (2 Replies)
Discussion started by: pistachio
2 Replies

4. UNIX for Dummies Questions & Answers

count number of rows based on other column values

Could anybody help with this? I have input below ..... david,39 david,39 emelie,40 clarissa,22 bob,42 bob,42 tim,32 bob,39 david,38 emelie,47 what i want to do is count how many names there are with different ages, so output would be like this .... david,2 emelie,2 clarissa,1... (3 Replies)
Discussion started by: itsme999
3 Replies

5. Shell Programming and Scripting

Count the number or row with same value in a column

This is the source file, we called it errorlist.out 196 server_a server_unix_2 CD 196 server_b server_win_1 CD 196 server_c server_win_2 CD 196 server_bd server_unix_2 CD 196 server_d server_unix_2 CD 196 server_es server_win_1 CD 196 ... (14 Replies)
Discussion started by: sQew
14 Replies

6. Shell Programming and Scripting

Extract and count number of Duplicate rows

Hi All, I need to extract duplicate rows from a file and write these bad records into another file. And need to have a count of these bad records. i have a command awk ' {s++} END { for(i in s) { if(s>1) { print i } } }' ${TMP_DUPE_RECS}>>${TMP_BAD_DATA_DUPE_RECS}... (5 Replies)
Discussion started by: Arun Mishra
5 Replies

7. Shell Programming and Scripting

Awk/sed script for transposing any number of rows with header row

Greetings! I have been trying to find out a way to take a CSV file with a large number of rows, and a very large number of columns (in the thousands) and convert the rows to a single column of data, where the first row is a header representing the attribute name and the subsequent series of... (3 Replies)
Discussion started by: tntelle
3 Replies

8. UNIX for Dummies Questions & Answers

Script to count number of rows

Hi, I need a solaris shell script to read multiple files and count number of unique name rows(strings) from those files. The input and output should be like this Input: file 1 abc cde abc ... (9 Replies)
Discussion started by: ssk250
9 Replies

9. UNIX for Dummies Questions & Answers

I want count of number of records to be printed on each row.

we want the count of number of records to be printed on each row. For Ex: if there are 5 records on one unique id , the count "5'' should be printed on each record in other column. Please help for this. I am using unix & Cygwin. Below are sample records: KCZ0650473... (2 Replies)
Discussion started by: ElijaRajesh
2 Replies

10. Shell Programming and Scripting

Reseting row count every given number of rows

I have a file with 48 rows. I am counting 6 rows and adding 6 to that number and repeating the operation, and then output the value in column 1. For the second column, I would like to get sort of a binary output (1s and 2s) every 3rd row. This is what I have: awk '{print ++src +... (1 Reply)
Discussion started by: Xterra
1 Replies
gdcmscu(1)							       GDCM								gdcmscu(1)

NAME
gdcmscu - Tool to execute a DICOM Query/Retrieve operation SYNOPSIS
gdcmscu [OPTION]...[OPERATION]...HOSTNAME...[PORT]... Execute a DICOM Q/R operation to HOSTNAME, using port PORT (104 when not specified) DESCRIPTION
The gdcmscu command line program is the tool to execute DICOM Query/Retrieve operation. It supports: o C-ECHO (SCU) o C-FIND (SCU) o C-STORE (SCU) o C-MOVE (SCU/SCP) C-MOVE operation are executed using two different ports (one for the SCU and one for the SCP). PARAMETERS
options options -H --hostname Hostname. -p --port Port number. --aetitle Set calling AE Title. --call Set called AE Title. mode options --echo C-ECHO (default when none). --store C-STORE. --find C-FIND. --move C-MOVE. C-STORE options -i --input DICOM filename -r --recursive recursively process (sub-)directories --store-query Store constructed query in file C-FIND/C-MOVE options --patientroot C-FIND Patient Root Model. --studyroot C-FIND Study Root Model. --patient C-FIND Query on Patient Info (cannot be used with --studyroot). --study C-FIND Query on Study Info. --series C-FIND Query on Series Info. --image C-FIND Query on Image Info. --key 0123,4567=VALUE for specifying search criteria (wildcard allowed) With --key, leave blank (ie, --key 10,10="") to retrieve values C-MOVE options -o --output DICOM filename / directory --port-scp Port for incoming associations --key 0123,4567=VALUE for specifying search criteria (wildcard not allowed) Note that C-MOVE supports the same queries as C-FIND, but no wildcards are allowed general options -h --help print this help text and exit -v --version print version information and exit -V --verbose verbose mode (warning+error). -W --warning warning mode, print warning information -E --error error mode, print error information -D --debug debug mode, print debug information --queryhelp print query help environment variable GDCM_ROOT_UID Root UID C-ECHO usage gdcmscu is a great tool to test if a DICOM server is up. For example to send a C-ECHO to server dicom.example.com using port 104, use: $ gdcmscu dicom.example.com or if you prefer being explicit: $ gdcmscu --echo dicom.example.com 104 Using basic security your DICOM server might require that you set the appropriate called AE-TITLE $ gdcmscu --echo dicom.example.com 11112 --call SERVSCP If you want to specifiy your own AE-TITLE (default is GDCMSCU), simply use: $ gdcmscu --echo dicom.example.com 11112 --call SERVSCP --aetitle MYSCU For example you could test on the DICOM server provided by DICOMObject team: $ gdcmscu www.dicomserver.co.uk 11112 C-STORE usage C-STORE is the operation that allow sending a DICOM file to a remote DICOM server. For instance to send a file called myfile.dcm $ gdcmscu --store dicom.example.com 104 myfile.dcm or if you prefer being explicit: $ gdcmscu --store dicom.example.com 104 -i myfile.dcm You can even send multiple files using the same association: $ gdcmscu --store dicom.example.com 104 myfile1.dcm myfile2.dcm myfile3.dcm ... C-FIND usage gdcmscu also allow querying a DICOM server. This is the C-FIND operation, for example to find all DICOM Instance where PatientsName match a particular pattern, usage is simply: $ gdcmscu --find --patient dicom.example.com 11112 --patientroot --key 10,10,"A*" We also support a DCMTK compatible convention: $ gdcmscu --find --patient dicom.example.com 11112 --patientroot --key 10,10="A*" When an attribute is set without a value it will be part of the output result: $ gdcmscu --find --patient dicom.example.com 11112 --call MI2B2 --patientroot -k 10,10="A*" -k 10,20 C-MOVE usage C-MOVE is the operation to retrieve a DICOM instance from a remote DICOM server. Most of the time, it is a subsequent operation after a C- FIND query. To retrieve a DICOM instance where PatientID is ABCD1234, simply execute: $ gdcmscu --move --patient --aetitle ACME1 --call ACME_STORE dicom.example.com 5678 --patientroot -k 10,20="ABCD1234" --port-scp 1234 WARNING For this operation to work you need information from the DICOM server you are communicating with. Only the DICOM server you are sending a C-MOVE query will be reponsible for sending back incoming associations (the actual C-STORE SCP). Therefore you need to make sure that you mapping of (AE-TITLE,PortNumber) is properly set on the DICOM server side as well as the port for incoming association (--port- scp). gdcmscu does not currently support external C-STORE association (C-STORE request sent to an external SCP application). patientroot notes The flag --patientroot is just simply a wrapper around the syntax --key 8,52=PATIENT For instance one would write using DCMTK syntax: findscu --patient dicom.example.com 11112 --key 8,52=PATIENT --key 10,10="F*" This would become using GDCM syntax: $ gdcmscu --find --patient dicom.example.com 11112 --patientroot --key 10,10="F*" Debugging This is sometime difficult to investigate why a connection to a remote DICOM server cannot be done. Some recommendations follows: Always try to do a simple C-ECHO at first. If you cannot get the C-ECHO to work none of the other operations will work Before trying to a C-MOVE operation, make sure you can execute the C-FIND equivalent query first. When doing a C-MOVE operation you really need to communicate with the PACS admin as the C-MOVE operation is different from the other lower level operation such as HTTP/GET. When doing a C-MOVE, the server will communicate back using another chanel (could be different port) using it's internal database to map an AE-TITLE back to the destination IP. Indeed the C-MOVE operation by design does not always use your incoming IP adress to send back the resulting dataset. Instead it uses a mapping of AE-TITLE to IP adress to send back any results. So pay particular attention to the spelling of your AE-TITLE and your incoming port (which may be different from the port to connect to the server). Port Warning Watch out that port ranging [1-1024] are reserved for admin and not easily accessible unless granted special priviliges. Therefore the default 104 DICOM port might be accessible to all your users. C-STORE Warnings When constructing a C-STORE operation, gdcmscu will always use the Media Storage as found in the file to be sent. For encapsulated DICOM file (eg. RLE Lossless) the receiving SCP server might not support this compression and will legitemely refuse the C-STORE operation. In this case users have to manually convert to a non-compressed form this particular file: $ gdcmconv --raw compressed.dcm non_compressed.dcm C-MOVE Warnings At the moment gdcmscu only supports non-compressed transfer syntax. It will always request DataSet using Implicit VR Little Endian Transfer Syntax during a C-MOVE operation. C-FIND IMAGE level (Composite Object Instance) One should pay attention that gdcmscu --find and findscu are not completely equivalent. Using gdcmscu --find, all Unique Keys will be added automatically. One can therefore execute something like this: $ gdcmscu --find --patientroot --image --key 8,18=1.2.3.4.5.6 dicom.example.com 11112 instead of the more explicit form $ gdcmscu --find --patientroot --image --key 8,18=1.2.3.4.5.6 dicom.example.com 11112 --key 10,20 --key 20,d --key 20,e This would also be equivalent to: $ findscu --patient --key 8,52=IMAGE --key 8,18=1.2.3.4.5.6 dicom.example.com 11112 --key 10,20 --key 20,d --key 20,e Storing the Query It is also possible to store the query: gdcmscu --find --patient --patientroot dicom.example.com 11112 --key 10,20="*" --key 10,10 --store-query query.dcm One can then check the DataSet values send for the query: $ gdcmdump query.dcm # Dicom-File-Format # Dicom-Meta-Information-Header # Used TransferSyntax: # Dicom-Data-Set # Used TransferSyntax: 1.2.840.10008.1.2 (0008,0005) ?? (CS) [ISO_IR 192] # 10,1-n Specific Character Set (0008,0052) ?? (CS) [PATIENT ] # 8,1 Query/Retrieve Level (0010,0010) ?? (PN) (no value) # 0,1 Patient's Name (0010,0020) ?? (LO) [* ] # 2,1 Patient ID The Specific Character Set was set to 'ISO_IR 192' as the locale encoding of the system was found automatically by gdcmscu to be UTF-8. This means that the following command line will properly setup the Query with the appropriate Charset to be executed correctly: $ gdcmscu --find --patient --patientroot dicom.example.com 11112 --key 10,10="*Jerome*" the query is always executed on the server side (SCP), some implementations does not support string matching with different Character Set. SEE ALSO
gdcmconv(1) COPYRIGHT
Copyright Insight Software Consortium Version 2.2.0 Tue Feb 5 2013 gdcmscu(1)
All times are GMT -4. The time now is 03:00 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy