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:[email protected]] > Sent: Thursday, 17 May 2012 10:16 PM > To: [email protected] > 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: [email protected] > 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 <[email protected]> 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: [email protected] [mailto:[email protected]] On Behalf > Of Claude Raiola > Sent: Thursday, 17 May 2012 10:00 PM > To: [email protected] > 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: [email protected] > 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 [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. > -- > 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. > > -- > 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. > > -- > 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. -- 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.
