I have a file (LRECL=80, RECFM=FB) with some data as shown below:
----+----1----+----2----+----3
BOLTEN 20101204
TANGRA 20110217
MANTRI 20090927
BOLTEN 20101204
TANGRA 20110217
MANTRI 20090927
Expected Output:
BOLTEN 2010-12-04
TANGRA 2011-02-17
MANTRI 2009-09-27
TANGRA 2011-02-17
MANTRI 2009-09-27
I would like to know how to convert the date appearing in CCYYMMDD format to CCYY-MM-DD format (with hyphens in between values). Please help.
Thanks.