RE: [cfaussie] CF Excel Spread Data Analysis
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. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] CF Excel Spread Data Analysis
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.
Re: [cfaussie] CF Excel Spread Data Analysis
rule #1 : don't feed the trolls! rule #2 : see #1. 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 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 Website: 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. 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. -- 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.