trimming unwanted symbols in Invoice Number field.

January 13, 2022 07:42
1

Hi,

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.

Community