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 DEBIAN
html::formfu::deflator::compounddatetime
HTML::FormFu::Deflator::CompoundDateTime(3pm) User Contributed Perl Documentation HTML::FormFu::Deflator::CompoundDateTime(3pm)NAME
HTML::FormFu::Deflator::CompoundDateTime - CompoundDateTime deflator
SYNOPSIS ---
element:
- type: Multi
name: date
elements:
- name: day
- name: month
- name: year
deflator:
- type: CompoundDateTime
# set the default
$form->get_field('date')->default( $datetime );
DESCRIPTION
For use with a HTML::FormFu::Element::Multi group of fields.
Sets the default values of several fields from a single DateTime value.
By default, expects the field names to be any of the following:
year
month
day
hour
minute
second
nanosecond
time_zone
METHODS
field_order
Arguments: @order
If your field names don't follow the convention listed above, you must provide an arrayref containing the above names, in the order they
correspond with your own fields.
---
element:
- type: Multi
name: date
elements:
- name: m
- name: d
- name: y
deflator:
- type: CompoundDateTime
field_order:
- month
- day
- year
AUTHOR
Carl Franks
LICENSE
This library is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-01-23 HTML::FormFu::Deflator::CompoundDateTime(3pm)