Hi,
I have several 1000 electricity bills that have been scanned from the original printed document into PDF I am using OCR software to convert each bill via a batch process into individual excel spreadsheets as I am wanting to capture the reference number of each bill, which is different on each bill and then be able to import the reference number into an sql table The problem is that given the OCR is reading scanned documents often the reference number appears on different cell / rows on each spreadsheet so I cannot consistently reference the same sell across multiple spreadsheets to source the value I am seeking from each spreadsheet spreadsheet 1 example cell d45 contains the title "reference number" and d46 contains the actual number spreadsheet 2 example cell f120 contains the title "reference number" and f121 contains the actual number I am wondering if there is some way once I have created the Datasource to the spreadsheet to be able to search the word "reference number" in each spreadsheet to determine then cell which contains the title "reference number" to then know that the value on the same row one column across will contain the actual reference value.and then read the value of that cell in CF to record into the database Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: <mailto:[email protected]> [email protected] Website: <http://www.samaris.net/> www.SAMARIS.net Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
