Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Finding a word in CSV files

I have a large number of CSV files containing production records and want to
find those containing a specific Lot No

Using Windows to seach for "A word or phrase in the file" does not appear to
work on CSV files - any suggestions

Thanks

Dennis
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 53
Default Finding a word in CSV files

Other than what you are doing, you can open CSV files in Excel or even
Notepad and then search for production records.

A complete search for all the files would require some third party tool, if
any.

--

Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"DennisT" wrote:

I have a large number of CSV files containing production records and want to
find those containing a specific Lot No

Using Windows to seach for "A word or phrase in the file" does not appear to
work on CSV files - any suggestions

Thanks

Dennis

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Finding a word in CSV files

Use Agent Ransack (GUI freeware from the authors site)

Or FIND at the command prompt.

DennisT wrote:

I have a large number of CSV files containing production records and want to
find those containing a specific Lot No

Using Windows to seach for "A word or phrase in the file" does not appear to
work on CSV files - any suggestions

Thanks

Dennis


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Finding a word in CSV files

Thanks ~ Agent Ransack worked a treat

Dennis

"Bob I" wrote:

Use Agent Ransack (GUI freeware from the authors site)

Or FIND at the command prompt.

DennisT wrote:

I have a large number of CSV files containing production records and want to
find those containing a specific Lot No

Using Windows to seach for "A word or phrase in the file" does not appear to
work on CSV files - any suggestions

Thanks

Dennis



  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Finding a word in CSV files

You're welcome, have a great day!

DennisT wrote:

Thanks ~ Agent Ransack worked a treat

Dennis

"Bob I" wrote:


Use Agent Ransack (GUI freeware from the authors site)

Or FIND at the command prompt.

DennisT wrote:


I have a large number of CSV files containing production records and want to
find those containing a specific Lot No

Using Windows to seach for "A word or phrase in the file" does not appear to
work on CSV files - any suggestions

Thanks

Dennis






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
finding excel files Novice in B-ton New Users to Excel 2 October 14th 08 07:42 PM
Finding Excel files Tommy H Excel Discussion (Misc queries) 0 August 29th 06 02:53 PM
I want to attach word files or PDF files to an excel database Dianne Munro Excel Discussion (Misc queries) 1 March 23rd 06 12:11 AM
Finding All but Last Word Steve Madden Excel Worksheet Functions 9 January 24th 06 08:57 AM
changing word files to excel files charlie'smom Excel Discussion (Misc queries) 2 August 12th 05 02:28 PM


All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"