I am searching for a paymentId on some invoices. It has a tendency to find the last digit as a character K.
I would like to replace the K with the number 1. What is the best way to do this?
I think I should add a region field and then add code in the pre-search field, which asks for the found value from
the previous character string field and then I could do something like replace(charracterstring.fieldvalue, "K","1").
Could anyone correct me ? :-)