Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Replace Date in a fixed length file
Top Forums Shell Programming and Scripting Replace Date in a fixed length file Post 302633571 by fpmurphy on Wednesday 2nd of May 2012 07:36:32 AM
Old 05-02-2012
Since OP originally asked for ksh solution ....
Code:
#!/bin/ksh93

month=$(printf "%(%m)T" "now")
thisyear=$(printf "%(%y)T" "now")
lastyear=$(printf "%(%y)T" "last year")

while read x
do
    if [[ "${x:6:2}" == "  " ]]
    then
        if [[ ${x:8:2} -ge $month ]]
        then
            echo "${x:0:6}${thisyear}${x:8}"
        else
            echo "${x:0:6}${lastyear}${x:8}"
        fi
    else
        echo $x
    fi
done < infile

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a fixed length output from a variable length input

Is there a command that sets a variable length? I have a input of a variable length field but my output for that field needs to be set to 32 char. Is there such a command? I am on a sun box running ksh Thanks (2 Replies)
Discussion started by: r1500
2 Replies

2. Shell Programming and Scripting

Manipulating a fixed length file w/o PERL

Greetings, I need to take a fixed length file, similar to the following: <input file> 1233 e 612 i 43378 f 03 x 22 17 e 9899 a 323e a6 z7 read in the character in position 6, and if that character = e, delete that line from the file. <output file> 43378 f 03 x 22 17 e 9899 ... (4 Replies)
Discussion started by: dabear
4 Replies

3. Shell Programming and Scripting

sed replace with fixed length

$ cat template s.noName $ sed "s/s.no/1/" template > out $ sed "s/s.no/100/" template >>out $ cat out 1Name 100Name 1 Name 100Name (7 Replies)
Discussion started by: McLan
7 Replies

4. UNIX for Dummies Questions & Answers

What the command to find out the record length of a fixed length file?

I want to find out the record length of a fixed length file? I forgot the command. Any body know? (9 Replies)
Discussion started by: tranq01
9 Replies

5. UNIX for Dummies Questions & Answers

Convert a tab delimited/variable length file to fixed length file

Hi, all. I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file: 10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783 19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657 And this is the expected... (2 Replies)
Discussion started by: Everton_Silveir
2 Replies

6. Shell Programming and Scripting

search and replace fixed length record file

Hi I need to be search a file of fixed length records and when I hit a particular record that match a search string, substitute a known position field In the example file below FHEAD000000000120090806143011 THEAD0000000002Y0000000012 P00000000000000001234 TTAIL0000000003... (0 Replies)
Discussion started by: nedkelly007
0 Replies

7. Shell Programming and Scripting

Search and replace particular characters in fixed length-file

Masters, I have fixed length input file like FHEAD0000000001XXXX20090901 0000009000Y1000XXX2 THEAD000000000220090901 ITM0000109393813 430143504352N22SP 000000000000RN000000010000EA P0000000000000014390020090901 TTAIL0000000003000000 FTAIL00000000040000000002 Note... (4 Replies)
Discussion started by: bittoo
4 Replies

8. Shell Programming and Scripting

Remove characters from fixed length file

Hello I've question on the requirement I am working on. We are getting a fixed length file with "33" characters long. We are processing that file loading into DB. Now some times we are getting a file with "35" characters long. In this case I have to remove two characters (in 22,23... (14 Replies)
Discussion started by: manasvi24
14 Replies

9. UNIX for Dummies Questions & Answers

Length of a fixed width file

I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers. awk '{print length;exit}' <File_name> The above code gives me length 50. wc -L <File_name> The above code gives me length 53. Please clarify on... (2 Replies)
Discussion started by: Amrutha24
2 Replies

10. Shell Programming and Scripting

Replace and Increment a value in the fixed length file

Hi Everyone, I need to increment a value in the fixed length file. The file has almost a million rows. Is there any easy way to accomplish this. Ex input file ASDSD ADSD 00000 X AAASD ADSD 00000 X SDDDD ADSD 00000 X Ouput ASDSD ADSD 00001 X AAASD ADSD 00002 X SDDDD ADSD 00003 X ... (7 Replies)
Discussion started by: saratha14
7 Replies

LEARN ABOUT LINUX

shcomp

SHCOMP(1)						    User Environment Utilities							 SHCOMP(1)

NAME

       shcomp - compile a ksh93 shell script

SYNOPSIS

       shcomp [ options ] [infile] [outfile]]

ORIGIN OF THIS MAN PAGE

       This man page was written by Christophe Martin <Schplurtz@free.fr> for the Debian GNU/Linux system. It is based on "shcomp --man" output.

DESCRIPTION

       Unless  -D  is  specified,  shcomp takes a shell script, infile, and creates a binary format file, outfile, that ksh93 can read and execute
       with the same effect as the original script.

       Since aliases are processed as the script is read, alias definitions whose value requires variable expansion will not work correctly.

       If -D is specified, all double quoted strings that are preceded by $ are output. These are the messages	that  need  to	be  translated	to
       locale specific versions for internationalization.

       If  outfile is omitted, then the results will be written to standard output.  If infile is also omitted, the shell script will be read from
       standard input.

OPTIONS

       -D, --dictionary
	      Generate a list of strings that need to be placed in a message catalog for internationalization.

       -n, --noexec
	      Displays warning messages for obsolete or non-conforming constructs.

       -v, --verbose
	      Displays input from infile onto standard error as it reads it.

       --man  Displays this man page on standard error and exits.

       --help Shows a short help message and exits.

EXIT STATUS

       0      Successful completion.

       >0     An error occurred.

DEBIAN WARNING

       On a Debian GNU/Linux system, more than one package may provide ksh. the output of shcomp can only be used by ksh93.  Any other ksh will be
       unable to run the compiled script.

EXAMPLE

       ( echo '#! /bin/ksh93' ; shcomp myscript ) > myscript.bin &&
       chmod 755 myscript.bin
       ./myscript.bin

SEE ALSO

       ksh(1)

IMPLEMENTATION

       version	       shcomp (AT&T Labs Research) 2003-03-02
       author	       David Korn <dgk@research.att.com>
       copyright       Copyright (c) 1982-2005 AT&T Corp.
       license	       http://www.opensource.org/licenses/cpl1.0.txt

KSH93								  Fri Jun 3 2005							 SHCOMP(1)
All times are GMT -4. The time now is 05:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy