I have a comment field which contains customer code for example:
Comment: Customer
Reg: 1 Inv:I00075 Cus:IS00002 Br:ID IS00002
Customer Code is IS00002
Customer always starts with IS and has 7 char. Customer Code is not always at the same position.
I need to extract the customer code from comment field and display separately in a new column.
Some of the data will not have the Customer Code under the comment field, in this case the Customer Column needs to be blank.
Thanks