I have to find in a file every line between 2 positions. In fact, the line juste after "PARSING IN CURSOR" and juste before "END OF STMT".
I have 2 solutions :
1/ I delete all the lines that is not between my 2 "expressions", include thes 2 lines.
2/ I fetch the line between this 2 "expressions" and save it in a new file. This is the best solution, i guess !
Exemple:
Original:
APPNAME mod='FXMEXPLR' mh=3136364418 act='' ah=4029777240
=====================
PARSING IN CURSOR #29 len=64 dep=0 uid=10247 oct=3 lid=10247 tim=1105006329960485 hv=1880456616 ad='14c13620'
SELECT SCE_VPD.SCE_CONTEXT('multicompany','company') FROM DUAL
END OF STMT
EXEC #29:c=0,e=86,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=2,tim=1105006329843848
=====================
PARSING IN CURSOR #22 len=41 dep=1 uid=10249 oct=3 lid=10249 tim=1105006329978565 hv=1006647865 ad='12852700'
SELECT SYS_CONTEXT(:B2,:B1) FROM SYS.DUAL
END OF STMT
EXEC #22:c=0,e=104,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=2,tim=1105006329978559
FETCH #22:c=0,e=97,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=2,tim=1105006329978753
FETCH #29:c=0,e=18284,p=0,cr=6,cu=0,mis=0,r=1,dep=0,og=2,tim=1105006329978869
RPC CALL:SCE.PL_FUNC.GET_TOKEN;
RPC EXEC:c=0,e=9060
RPC CALL:SCE.PL_FUNC.GET_TOKEN;
RPC EXEC:c=0,e=71
=====================
What i Want to have:
SELECT SCE_VPD.SCE_CONTEXT('multicompany','company') FROM DUAL
=====================
SELECT SYS_CONTEXT(:B2,:B1) FROM SYS.DUAL
I'm not familiar with the macro, and what i done did not give a result.
Can someone help me
THKX,
=========================
Greating from Marseille, France[b]
