Peter
Do you really think that response is in any way constructive at all? From: ColdGen Internet Solutions [mailto:coldgen.internet.soluti...@gmail.com] Sent: Thursday, 17 May 2012 10:16 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] CF & Excel Spread Data Analysis <cfscript> newva="doh"; </cfscript> <http://www.coldgen.com/images/coldgen_standard.png> Peter Tilbrook Web Administrator, The Club Group Pty. Ltd. Managing Director, ColdGen Internet Solutions Professional Adobe ColdFusion Application Development President, ACT and Region ColdFusion Users Group PO Box 2247 Queanbeyan, NSW, 2620 AUSTRALIA Tel: +61-2-6104-9981 Mob: +61-2-0457-449-016 Email Address: peter.tilbr...@coldgen.com WWW: http://www.coldgen.com/ WWW2: http://www.clubgroup.com.au/ Twitter: @ColdGen ABN: 80 826 226 128 On 17 May 2012 22:10, Dale Fraser <d...@fraser.id.au> wrote: Just loop through each cell systematically until you find the field. Regards Dale Fraser http://dale.fraser.id.au http://cfmldocs.com http://learncf.com http://flexcf.com From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Claude Raiola Sent: Thursday, 17 May 2012 10:00 PM To: cfaussie@googlegroups.com Subject: [cfaussie] CF & Excel Spread Data Analysis 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: i...@samaris.net <mailto:i...@trackingcentral.om.au> Website: www.SAMARIS.net <http://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 cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com <mailto:cfaussie%2bunsubscr...@googlegroups.com> . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.