if i open the file in excel to do some edit the data goes wild and i cant open it.
now when the file is opened in QEDCVIEW the entries are shown as :
1
DATE: day/month/year TIME: xx:xx:xx
A/C: xxxxxxxxxxx
PAN: xxxxxxxxxxxxx
TXN: WITHDRAWAL SEQ: 1234
STAN: 567890
AMOUNT: PKR 500.00
CAS1[0]: CAS2[1]:
STATUS: OK
2
DATE: day/month/year TIME: xx:xx:xx
A/C: xxxxxxxxxxx
PAN: xxxxxxxxxxxxx
TXN: WITHDRAWAL SEQ: 1234
STAN: 567890
STATUS: ACCOUNT IS BLOCKED
now i want such a way to get extract only the transaction with
STATUS: OK
moreover i want this transaction to be given in excel or any other software as below
SEQ stan Amount
1234 567890 500
and leave the rest data like data, time, A/C, PAN, TXN
i would be delighted if i get the query resolved.