You can try this awk script. It looks for fields looking like dates, splits them into month, day and year and recombines them using a proper format.
Very old versions of awk, like /usr/bin/awk on Solaris do not understand sprintf. You should be on the safe side with GNU-awk or nawk though.
Hello hergp,
Thank you for nice code. I think you could change (match ($field, ".*/.*/.*")) to (match($field,/[0-9]+\/[0-9]+\/[0-9]+/)), which will get only digits(for matching dates only).
Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
How to insert leading zeros into a left-justisfied zip code?
e.g. Zip code is written as 60320 which is left-justified to make it be read as 0060320.
We have to move it to right-justifiable then insert 2 leading zeros into it... ;) (1 Reply)
Hi All,
I am working with a fixed width file Forrmat.
C1 Number (10,3)
C2 Number (10,3)
e.g.
c1= 0000000100.000
c2= 0000000020.000
0000000100.0000000000020.000
I have to perform c1 - c2 . i.e. I want answer to be 0000000080.000. but I am loosing the leading zeros( only getting... (3 Replies)
Hi
I have a file in which I have 5 columns which are delimited by “|” as shown
ABC|12|YAK|METRIC|000000019.5
XYZ|10|ABX|META|000000002.5
Now my requirement is to take the last column trim the leading zero's for that column values and write back to the same file in the same... (7 Replies)
Hi all,
I have file with numeric values. I need to pad each value with leading zeros such that total lenght of each value is 16.
Example:
cat tmp.txt
502455
50255
5026
5027
5028
Output
0000000000502455
0000000000050255
0000000000005026
0000000000005027
0000000000005028
Any... (12 Replies)
Hi
i need help in adding leading zero to filenames
e.g file name in my folder are
1_234sd.txt
23_234sd.txt
the output i need is
001_234sd.txt
023_234sd.txt
can i do this shell scripting
please help (2 Replies)
Hello Gurus,
Quick question. I have a file with the following records:
A~000000000000518000~SLP ~99991231~20090701~88.50~USD~CS~
A~000000000000518000~SLP ~99991231~20090701~102.00~USD~CS~
A~000000000000772000~SLP ~99991231~20100701~118.08~USD~CS~
I wold like to do the following:
1. Add... (1 Reply)
Hi,
i have a variable which conatins values like 00001,0003,00067,00459.
I want to use the values one by one and in the same form as they are like 00001,0003,00067,00459.
Also can anyone tell me how to increment those numbers by 1,keeping the format as same like 00002,0004,00068,00460.... (5 Replies)
I have a list of numbers extracted and need to delete the leading zeros from them, but when i do so, the command I am using also deletes numbers that end in Zero as well. eg 10, 20, 30, etc
this is part of a larger script and the only way I can think of is to try and detect the 10,20 30 etc in... (19 Replies)
Hi All,
I am using a informatica job to create a csv file and a unix script the mail the generated file.Everything is working fine but I am not seeing leading zeros in the csv file sent in the mail.These zeros were present when the .csv file was generated by informatica procees.
Is there any... (11 Replies)
Discussion started by: karthik adiga
11 Replies
LEARN ABOUT HPUX
tztab
tztab(4) Kernel Interfaces Manual tztab(4)NAME
tztab - time zone adjustment table for date and ctime()
DESCRIPTION
The file describes the differences between Coordinated Universal Time (UTC) and local time. Several local areas can be represented simul-
taneously with historical detail.
The file consists of one or more time zone adjustment entries. The first line of the entry contains a unique string that may match the
value of the string in the user's environment. The format is where is the time zone name or abbreviation, diff is the difference in hours
from UTC, and is the name or abbreviation of the "Daylight Savings" time zone. Fractional values of diff are expressed in minutes preceded
by a colon. Each such string will start with an alphabetic character.
The second and subsequent lines of each entry details the time zone adjustments for that time zone. The lines contain seven fields each.
The first six fields specify the first minute in which the time zone adjustment, specified in the seventh field, applies. The fields are
separated by spaces or tabs. The first six are integer patterns that specify the minute (0-59), hour (0-23), day of the month (1-31),
month of the year (1-12), year (1970-2038), and day of the week (0-6, with 0=Sunday). The minute, hour, and month of the year must contain
a number in the (respective) range indicated above. The day of the month, year, and day of the week can contain a number as above or two
numbers separated by a minus (indicating an inclusive range). Either the day of the month or the day of the week field must be a range,
the other must be simple number.
The seventh field is a string that describes the time zone adjustment in its simplest form: where is an alphabetic string giving the time
zone name or abbreviation, and diff is the difference in hours from UTC. must match either the field or the field in the first line of the
time zone adjustment entry. Any fractional diff is shown in minutes.
Comments begin with a in the first column, and include all characters up to a newline. Comments are ignored.
EXTERNAL INFLUENCES
International Code Set Support
Single-byte character code sets are supported.
EXAMPLES
The time zone adjustment table for the Eastern Time Zone in the United States is:
Normally (as indicated in the first line) Eastern Standard Time is five hours earlier than UTC. During Daylight Savings time, it changes
to a 4 hour difference. The first time Daylight Savings Time took effect (second line) was on January 6, 1974 at 3:00 a.m., EDT. Note
that the minute before was 1:59 a.m., EST. The change back to standard time took effect (sixth line) on the last Sunday in November of the
same year. At that point, the time went from 1:59 a.m., EDT to 1:00 a.m., EST. The transition to Daylight Savings Time since then has
gone from the last Sunday in February (third line) to the last Sunday in April (fourth line) to the first Sunday in April (fifth line).
The return to standard time for the same period has remained at the last Sunday in October (seventh line).
AUTHOR
was developed by HP.
FILES SEE ALSO date(1), ctime(3C), environ(5).
tztab(4)