IDC picking up 'S' in invoice number as '$'

The OCR system is picking up the ‘S’ character in invoice numbers as ‘$’. Unfortunately we often get paper invoices that don’t have the most legible information. The Document Form Definition allows for formulas; would this be the best way forward? I’m not sure what the available functions are, but I imagine I could do a string replacement?

You could do a string replacement, yes. That sounds like it would work.

2 Likes

I would do a check first to see if the left(1,string) value is either 5 or S and replace with $.

2 Likes