Trying to count records in a field CUST. These records will be separated by a comma and sometimes the field will be blank.
i.e.
CUST REF
80908766, 723767676, 787987987
23432434, 342343432
I want to show that there is 3 entries in that field for the first record and 2 entries in that field for the second record.
Any suggestions?
i.e.
CUST REF
80908766, 723767676, 787987987
23432434, 342343432
I want to show that there is 3 entries in that field for the first record and 2 entries in that field for the second record.
Any suggestions?