I’m using OCR to scrape a scan billing but because of poor quality the decimal point is being read as 1. I’m trying to clean up the data extracted but I am having trouble.
This is the sample extracted value: 5,000100 which should be 5,000.00. I want to check if the third to the last digits is 1. and if it is 1, replace it with dot. I do not want to use contains because the data is dynamic.
Thanks in advance