I am very sorry I can't provide raw data. As it is company's confidential information. But thanks for your reply. Will try to use MS Access. :)
On Jul 27, 10:12 pm, XLS S <xlst...@gmail.com> wrote: > Dear Praneet, > > Use Ms Access,..............is it possible to provide the data? > > please provide the raw data > > On Wed, Jul 27, 2011 at 10:33 PM, Praneeth Akinapalli <praneeth...@gmail.com > > > > > > > > > > > wrote: > > Hi Experts, > > > I have a .log file (TXT doc) with 80,000 rows. I only need 20 rows of > > data based on a single column from that log file. I am currently using > > 2003 excel. Can anyone please give me logic on how to read that > > particular data from log file. > > > Actually I tried importing the log file and then use lookup function > > for searching data. But since 2003 excel can support only 65535 rows, > > because of this i was unable to load the log file completely. I have > > some other macro's developed by my seniors which can do this > > independent of no. of rows in log file. > > > So please help me out in doing this. > > > For example i have following data in .log file..: > > > name salary > > abc 100 > > def 200 > > fhh 300 > > and so on upto 80,000 rows.... > > > Now I need to know salary of abc and def only from the above data.... > > Kindly help me in doing this. > > Thanks in advance.... > > > -- > > > ---------------------------------------------------------------------------------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/discussexcel > > -- > ......................... -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel