AnsweredAssumed Answered

Extracting a client code from the description column of csv Bank download

Question asked by Raymond on Jan 11, 2016
Latest reply on Jan 13, 2016 by siplus

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

Outcomes