G
Guest
I HAVE FOUR FIELDS FIELD1,FIELD2,FIELD3,FIELD4 AS SHOWN BELOW
FIELD1 FIELD2 FIELD3 FIELD4
PRG 000000 003000 003000
PRO 002600 000030
PSA 002700 000030
PRO 002730 000030
PSA 002800 000100
PRO 002830 000030
PRO 002900 000030
PRC 003000 000030
PRG 003000 010000 003000
PRO 003900 000030
PRO 004000 000030
PRO 004030 000030
PRO 004100 000030
PRO 004130 000015
1.IF FIELD1 IS "PRG" FIELD3 IS FIELD2 OF NEXT ROW AND FIELD4 IS
FIELD3-FIELD2,IF FIELD1 IS NOT OF THAT TYPE THEN FIELD3 IS FIELD2+FIELD4
2.FOR THE NEXT RECORD AFTER PTYP IN FIELD1,FIELD2 IS FIELD3 OF PREVIOUS ROW
AND FIELD3 IS FIELD2+FIELD4
3.IF AGAIN THE FILED1 IS PTYP SAME STEP 1 & 2 AS TO BE REPEATED
THE RESULT SHUD BE AS SHOWN BELOW
FIELD1 FIELD2 FIELD3 FIELD4
PRG 000000 002600 002600
PRO 002600 002630 000030
PSA 002630 002700 000030
PRO 002700 002730 000030
PSA 002730 002830 000100
PRO 002830 002900 000030
PRO 002900 002930 000030
PRC 002930 003000 000030
PRG 003000 003900 000900
PRO 003900 003930 000030
PRO 003930 004000 000030
PRO 004000 004030 000030
PRO 004030 004100 000030
PRO 004100 004115 000015
PRO 004115 004145 000030
ANY HELP WOULD BE KINDLY APPRECIATED AS I AM NOT STRONG IN PROGRAMMING
FIELD1 FIELD2 FIELD3 FIELD4
PRG 000000 003000 003000
PRO 002600 000030
PSA 002700 000030
PRO 002730 000030
PSA 002800 000100
PRO 002830 000030
PRO 002900 000030
PRC 003000 000030
PRG 003000 010000 003000
PRO 003900 000030
PRO 004000 000030
PRO 004030 000030
PRO 004100 000030
PRO 004130 000015
1.IF FIELD1 IS "PRG" FIELD3 IS FIELD2 OF NEXT ROW AND FIELD4 IS
FIELD3-FIELD2,IF FIELD1 IS NOT OF THAT TYPE THEN FIELD3 IS FIELD2+FIELD4
2.FOR THE NEXT RECORD AFTER PTYP IN FIELD1,FIELD2 IS FIELD3 OF PREVIOUS ROW
AND FIELD3 IS FIELD2+FIELD4
3.IF AGAIN THE FILED1 IS PTYP SAME STEP 1 & 2 AS TO BE REPEATED
THE RESULT SHUD BE AS SHOWN BELOW
FIELD1 FIELD2 FIELD3 FIELD4
PRG 000000 002600 002600
PRO 002600 002630 000030
PSA 002630 002700 000030
PRO 002700 002730 000030
PSA 002730 002830 000100
PRO 002830 002900 000030
PRO 002900 002930 000030
PRC 002930 003000 000030
PRG 003000 003900 000900
PRO 003900 003930 000030
PRO 003930 004000 000030
PRO 004000 004030 000030
PRO 004030 004100 000030
PRO 004100 004115 000015
PRO 004115 004145 000030
ANY HELP WOULD BE KINDLY APPRECIATED AS I AM NOT STRONG IN PROGRAMMING