I am trying to extract a client code from the description column of a csv file downloaded from my bank. The description will be entered by the clients and unfortunately will not always be consistent in its position and sometimes the client code will be missing.
The purpose of identifying the client code is to help with matching the bank payments with a invoices in a FM db.
The maximum length of the description is 60 characters.
Samples 2 descriptions
INTERNET TRANSFER LUNDI BLA001 104347 Client name
ref R1H002 rick design Co
BLA001 = Client code always 3 alpha & 3 numbersExtracting a client code