I'm working on an invoice project, where I want to trim the symbol ":" and the spaces from the invoice number field.
Since I have the following in the invoice:
Invoice Number : 1010101010.
and the detected field result as (": 1010101010" or "i 1010101010").
So, I want to trim the unwanted symbol (:)+ any spaces in that field but at the same time I can't limit this field to be only accepting numbers since I have another invoices that start with letters. So how can I implement this ?
Thanks in advance.