Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
Hi,
which containes record indicator starting from 9th position as
DH start of header
DD detail line
DC end of header
DH line has date starting from 41th position as dd/mm/yy
i want output asa data after some date say 05/08/08
output should look like
Code: |
MARKSGM,DH,8GB232128892000-1-BER1080801,10/08/08
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-0657-02689784-07917,6403599999,,53.44,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132097-07550,6403511999,,94.67,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132110-07550,6403511999,,94.67,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132134-07550,6403511999,,94.67,,8,,
MARKSGM,DC,8GB232128892000-1-BER1080801,001,22173.10
MARKSGM,DH,8GB232128892000-1-BER1080801,01/09/08
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-0657-02689784-07917,6403599999,,53.44,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132097-07550,6403511999,,94.67,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132110-07550,6403511999,,94.67,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132134-07550,6403511999,,94.67,,8,,
MARKSGM,DC,8GB232128892000-1-BER1080801,001,22173.10
|
Input
Code: |
12345678901234567890123456789012345678901234567890
MARKSGM,DH,8GB232128892000-1-BER1080801,01/08/08
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-0657-02689784-07917,6403599999,,53.44,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132097-07550,6403511999,,94.67,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132110-07550,6403511999,,94.67,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132134-07550,6403511999,,94.67,,8,,
MARKSGM,DC,8GB232128892000-1-BER1080801,001,22173.10
MARKSGM,DH,8GB232128892000-1-BER1080801,02/08/08
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-0657-02689784-07917,6403599999,,53.44,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132097-07550,6403511999,,94.67,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132110-07550,6403511999,,94.67,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132134-07550,6403511999,,94.67,,8,,
MARKSGM,DC,8GB232128892000-1-BER1080801,001,22173.10
MARKSGM,DH,8GB232128892000-1-BER1080801,10/08/08
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-0657-02689784-07917,6403599999,,53.44,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132097-07550,6403511999,,94.67,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132110-07550,6403511999,,94.67,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132134-07550,6403511999,,94.67,,8,,
MARKSGM,DC,8GB232128892000-1-BER1080801,001,22173.10
MARKSGM,DH,8GB232128892000-1-BER1080801,01/09/08
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-0657-02689784-07917,6403599999,,53.44,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132097-07550,6403511999,,94.67,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132110-07550,6403511999,,94.67,,8,,
MARKSGM,DD,8GB232128892000-1-BER1080801,T02-2011-04132134-07550,6403511999,,94.67,,8,,
MARKSGM,DC,8GB232128892000-1-BER1080801,001,22173.10 |
Let me know if anything more is needed |
|