Ordering batch number Post: 302843459

Sponsored Content

Top Forums Shell Programming and Scripting Ordering batch number Post 302843459 by capitanui on Tuesday 13th of August 2013 11:00:04 AM

08-13-2013

Registered User

This is what i came with. If i correctly understood your question.

You have a file like :
PROCESS1 DATE=130813 TIME=130503 BATCHNO=0000000014
PROCESS1 DATE=130813 TIME=130503 BATCHNO=0000000009
PROCESS1 DATE=130813 TIME=130503 BATCHNO=0000000017

And you need to order it by the BATCHNO as in :
PROCESS1 DATE=130813 TIME=130503 BATCHNO=0000000009
PROCESS1 DATE=130813 TIME=130503 BATCHNO=0000000014
PROCESS1 DATE=130813 TIME=130503 BATCHNO=0000000017

Hope this will help you. Feel free to modify the script to put the file in another path.

Code:

#!/bin/bash
#Date :
#Author
#Purpose : Sort batch file
#Usage : ./sortbatch.sh <batchfile>

BATCHFILE=$1
ORDEREDBATCH=`pwd`/ordered_`date +%F_%H:%M`_$BATCHFILE

#Verify if a file was given
if [ $# -lt 1 ]; then
        echo "Usage : ./sortbatch.sh <batchfile>"
        exit 1
fi

#Verify if the file exists
if [ ! -e $BATCHFILE ]; then
        echo "File does not exist"
        exit 1
fi

#Read batch numbers
BATCHNRS=`awk '{print $4}' $BATCHFILE | sort | uniq`

#Copy to another file the lines in order of the batch number
for i in $BATCHNRS; do
        awk -v batch="$i" '{if ($4 == batch ) print $0}' $BATCHFILE >> $ORDEREDBATCH
done

#End

capitanui

View Public Profile for capitanui

Find all posts by capitanui

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Append value(batch number) to start of records

Hi all, I am new to unix shell scripting and I am trying to append batch number that comes in Trailer record to the detailed record. TR|20080312|22881 |000000005|20080319|2202 LN|20080312|077777722220 |0000100000017|ABS LN|20080312|000799439326 |0000709943937|AA TR|20080313|22897 ...

2. Shell Programming and Scripting

proper ordering of o/p values

Hi, Below is my script which creates a file: #!/bin/sh if then echo "Enter bill period " echo "Syntax: sh cpd.sh G08" exit fi sqlplus uname/pwd@dbname <<EOF set WRAP off set FEEDBACK off set PAGESIZE 0 set VERIFY off

3. Homework & Coursework Questions

word ordering problem HELP please (linux)

Hi guys I need you ,please help me i have to do this for tomorow and i don't understand how to do Q1 : Order the words of RADIO.txt by frequency Q2 : Order the words of RADIO.txt in alphab�tique order Q3 : Order the words of RADIO.txt par ordre "rhymique" (exemple, put togeder words which are...

4. Shell Programming and Scripting

ordering a data file

With an input file like this: How can I get an output like this? (In the quoted examples, the "_" sign represents an empty space) Note that there are some minus signs and no spaces, in the example above the first character of the first line is an empty space, so each number spans 10...

5. Shell Programming and Scripting

Re-ordering data

input Predictions for job: 1299399580 ********************************************** gg18_qqq10_100017878_100017978_- ============================================================================== zzz Factor: XXX, ttt: crsmsgw, Cutoff: 0.6429 seqe Position fff Coordinate K-mer Score ...

6. Shell Programming and Scripting

Re ordering lines - Awk

Is it possible to re-order certain rows as columns (of large files). Few lines from the file for reference. input Splicing Factor: Tra2beta, Motif: aaguguu, Cutoff: 0.5000 Sequence Position Genomic Coordinate K-mer Score 97 chr1:67052604 uacuguu 0.571 147...

7. Shell Programming and Scripting

Executing a batch of files within a shell script with option to refire the individual files in batch

Hello everyone. I am new to shell scripting and i am required to create a shell script, the purpose of which i will explain below. I am on a solaris server btw. Before delving into the requirements, i will give youse an overview of what is currently in place and its purpose. ...

8. Shell Programming and Scripting

ordering

file1 1 SNP2 3 1 SNP3 3 1 SNP5 4 2 SNP1 4 2 SNP4 4 file2 SNP1 1 1 1 SNP5 5 5 5 SNP4 4 4 4 SNP2 2 2 2 SNP3 1 1 1 desired output

9. Shell Programming and Scripting

Random ordering

1 2 4 5 3 I would like to use a script so that i can randomly rearrange these numbers such as 3 5 2 4 1 Thanks!

10. Shell Programming and Scripting

Start process on X number of files and then wait for the next batch

Thanks for RudiC for his extraordinary help on organizing files in a batch of 10 using below code. FL=($(ls)); for ((i=0;i<=${#FL};i++)); do for j in ${FL:$i:10}; do $batch ${j} ${j}.txt done; echo "Pausing for next iteration"; echo...

LEARN ABOUT DEBIAN

ecaccess-queue-list

ECACCESS-QUEUE-LIST(1p) 				User Contributed Perl Documentation				   ECACCESS-QUEUE-LIST(1p)

NAME

       ecaccess-queue-list - List available queues

SYNOPSIS

       ecaccess-queue-list -version|-help|-manual

       ecaccess-queue-list [-debug] [queue-name]

DESCRIPTION

       Two different types of queues are in use with ECaccess:

       1 - The ECaccess batch queues, which correspond to one system at ECMWF with its specific batch environment, e.g. ecgate will be the
       ECaccess queue, which will redirect jobs to ecgate at ECMWF, running LoadLeveler. This ECaccess queue will be given as argument when
       submitting a batch job.

       2 - The batch queues (or classes) on the systems at ECMWF will be given in the batch job with #@ class = for LoadLeveler.

       The names of the ECaccess queues and associated batch queues at ECMWF can be seen with this command. When an ECaccess queue-name is
       specified then the details for this queue are displayed (including the list of classes).

       The first ECaccess batch queue in the list is the default queue when submitting a batch job with the ecaccess-job-submit command.

ARGUMENTS

       queue-name (optional)
	       The name of the ECaccess queue to retrieve the details.

OPTIONS

       -version
	       Display version number and exits.

       -help   Print a brief help message and exits.

       -manual Prints the manual page and exits.

       -debug  Display the SOAP messages exchanged.

EXAMPLES

       ecaccess-queue-list

       List all the ECaccess batch queues (or systems supporting job submission at ECMWF).

       ecaccess-queue-list ecgate

       List all the batch queues (or classes) on the ECMWF system ecgate.

SEE ALSO

       ecaccess.

perl v5.14.2							    2012-04-16						   ECACCESS-QUEUE-LIST(1p)