topic Re: Need help for scripting.. in Operating System - HP-UX

Need help for scripting..

Sailesh_1 — Wed, 19 Nov 2003 15:26:53 GMT

Hi,

I would need to add a trailer record into a file generated by a script. The trailer record format should be "TRAILERDDMMYYYYNNNNNN"
where DD=current date, MM=current Month, YYYY=current year and NNNNNN=no of records in the file (excluding the trailor record).

For example, for a file created on November 17, 2003 with 645 records, the trailor should read as TRAILER17112003000645

Now, As you see in the example, the number of records could be any thing from 1 to 999999.

What should I do to create the trailor record in the proper format to fill all the 6 record fields. i.e, if the number of record is 589, then it should read as 000589

Appreciate your help!

Thanks,
Sailesh

Re: Need help for scripting..

Jannik — Wed, 19 Nov 2003 15:39:17 GMT

seqid=`date -u +%d%m%Y`
filename=TRAILER$seqid
I don't know what you meen with records. Could you please clarify!

Re: Need help for scripting..

Steven E. Protter — Wed, 19 Nov 2003 15:43:53 GMT

You may find the following date converstion script useful in your scriptng.

http://www.hpux.ws/merijn/caljd.sh

A. Clay Stephenson Wrote it.

SEP

Re: Need help for scripting..

John Poff — Wed, 19 Nov 2003 15:50:34 GMT

Hi,

Something like this might work. I wrote a little shell script named trail.sh. Just pass it the filename to generate the trailer record for as a parameter. The 'somefile' I used has ten lines in it:

>cat trail.sh
#!/bin/sh

# trail.sh

MYFILE=$1
typeset -Z6 LINES
MYLINES=$(wc -l $MYFILE | awk '{print $1}')
MYDATE=$(date '+%d%m%Y')

echo "TRAILER${MYDATE}${MYLINES}"

>./trail.sh somefile
TRAILER19112003000010

The trick to formatting your record count is to use the 'typeset' command. The -Z6 option tells typeset that the MYLINES variable will be six numeric characters, zero filled. You can read up on typeset in the sh-posix man page.

Have fun!

JP

Re: Need help for scripting..

Sailesh_1 — Wed, 19 Nov 2003 15:50:42 GMT

Thanks for the reply.
Records are something like the number of entries in the file. simply

$ cat file_name |wc -l

There are 6 feilds allotted for the records.
and I need to fill all the six fields.even if the number is 589, the trailor should looks like TRAILOR`date`000589. My question is how do I add those zeros in it?

i.e, if the record is 589, then i need to add 3 zeros before 589. and if the record is 1589. then i need to add 2 zeros before 1589 to fill the vacant.

Thanks,
Sailesh

Re: Need help for scripting..

Mark Greene_1 — Wed, 19 Nov 2003 15:53:46 GMT

once you have the record count, you can format it with awk:

RECORD_COUNT= `echo $RECORDS| awk ' { printf "%06d", $1 }'`

where $RECORDS is the unformatted count, and RECORD_COUNT would be the formatted number. So if $RECORDS = 589, $RECORD_COUNT would be 000589.

mark

Re: Need help for scripting..

john korterman — Wed, 19 Nov 2003 16:01:57 GMT

Hi,
the easiest way is to make use of the korn shell's capacities, e.g. try this example:

#!/usr/bin/sh
typeset -Z6 NUMBER
NUMBER=$(wc -l ./infile|awk '{print $1}')
echo $NUMBER

for further information, man ksh and look for typeset.

regards,
John K.

Re: Need help for scripting..

Sailesh_1 — Wed, 19 Nov 2003 16:11:33 GMT

Thank you Mark and all others who replied.
That works perfect!!

Thank you all once again.

Sailesh