Hi, I need help with the following. I need to extract a reference from bank statements. Is it possible to get the reference from the snippet below. I get the below example from a statement. I then need to extract only the reference number form each row.
The reference number is in the format: 000000/XR/00000
Eg the first line the reference number is: 200504/XR/13436
ADT CASH DEPO00031110 200504/XR/13436
FNB APP PAYMENT FROM 200505/XR/13587
INT-BANKING PMT FRM 200505/XR/13554
FNB APP PAYMENT FROM 292505/PTY/53261
FNB OB PMT 200505/XR/13541
INT-BANKING PMT FRM 200505/XR/13537
FNB APP PAYMENT FROM 200503/PTY/53144
FNB APP PAYMENT FROM 200430/XR/8810
SAVERITE 200504/XR/13268