Hi All,
I am new to this forum, could any one help me out in resolving the below issue.
Input of the flat file contains several lines of text for example find below:
5022090,2,4,7154,88,,,,,4/1/2011 0:00,Z,L,2
5022090,3,1,6648,88,,,,,4/1/2011 0:00,Z,,1
5022090,4,1,6648,88,,,,,4/1/2011 0:00,Z,,1
output:
5022090,2,4,7154,88,,,,,01-Apr-2011,Z,L,2
5022090,3,1,6648,88,,,,,01-Apr-2011,Z,,1
5022090,4,1,6648,88,,,,,01-Apr-2011,Z,,1
I am using a client server using putty.
Information:
This is for one particular flat file while in other flat files the date field may contain at some other column the column of the date field is not common to all the flat files.