does anyone know how to trim the "Invoice #" from ...
# generala
Al
05/09/2019, 7:27 PMdoes anyone know how to trim the "Invoice #" from Invoice #INV23002? I tried LTRIM({payingtransaction.appliedtotransaction},'Invoice #') but it's end results is NV23002 😞
b
battk
05/09/2019, 7:29 PMim confused
battk
05/09/2019, 7:29 PMyou asked this before
battk
05/09/2019, 7:29 PMbattk
05/09/2019, 7:29 PMand evidently got a working answer, what happened
a
Al
05/09/2019, 7:29 PMHi batt
Al
05/09/2019, 7:29 PMI just found out that it slashes some characters if the number exceed a certain limit
g
Gregory Jones
05/09/2019, 7:30 PMreplace({payingtransaction.appliedtotransaction},'Invoice #','')
❤️ 2
a
Al
05/09/2019, 7:36 PM@Gregory Jones looking good so far! thank you
g
Gregory Jones
05/09/2019, 7:37 PMExcellent!
3 Views