RE: [MI-L] Extracting Table information.

Tue, 10 Oct 2006 04:56:25 -0700

Title: Extracting Table information.

Joe Nunn wrote:
> Problem is if it ends in .wor it will not be searched as a text file so temporarily

> rename your workspace files with .txt at the end with a handy program

> A.F.5 rename your files. 

> I guess there is a simpler way out there though….

There are ways to search for content within WOR files – eg, Google Desktop, as previously suggested; or setting the registry flag "FilterFilesWithUnknownExtensions"=dword:00000001 (the attachments here may be renamed from TXT files to REG and will change the registry with this flag either ON or OFF – this affects Indexing Service only), and using the Windows search dog (“Search Companion”).

 

Matthew

I thought there was a MBX that did something like this.

But a suitable solution for you depends on how many WOR files you have, and what you want to “extract” – or is it just to list all occurrences of Open Table statements?

My thoughts:

  1. Search: just use Windows Explorer in Windows XP, OR install and use a desktop search tool of your choice (I use Microsoft’s Windows Desktop Search v3 Beta2 – but Google DTS or Copernic DTS or earlier versions of Microsoft’s Desktop Search like MSN DTS are OK) and configure so that .WOR is searched and indexed. The ‘filter’ that’s used will default to text – at least, with Windows DTS where a text iFilter is used. All of these search tools will locate the ?filenames (Open Table statements) that you want, as text within the .WOR file.
  2. Making a list: deriving a usable list of the .WOR files that have the particular Tables you’re interested in is a further problem, which could require some coding. I think that the proof-of-concept user interface for the Windows Desktop Search – called PHLAT (Prototype for Helpful Lookup and Tagging, and created by Microsoft Research) – might do the job without coding though.
  3. Change: If necessary for those .WOR files located by the search, you can open each for a search/replace with a suitable text editor. I use the free TextPad which can open multiple files, and has good facilities. Again, a VB6 / _vbscript_ / VB.NET application to do this could be coded – but why not do it the ad hoc way (text editor or grep)?

Another approach would be to write a routine – even with MapBasic – to do the search. But only if you have a small number of .WOR files.

The advantage of the interactive desktop search tools is that they’re very much more efficient, unless you’re a moderately competent coder and call the functionality of Windows’ inbuilt Indexing Service (which Windows Explorer makes use of, by the way).

But it’s not really very hard to code a specific application which uses the Indexing Service, and produces such a list (a VB6 / _vbscript_ / VB.NET application; someone’s probably done it).

 

IL Thomas
GeoSciSoft  - Perth, Australia

 

PHLAT - http://research.microsoft.com/adapt/phlat/default.aspx

(doesn’t work with Windows DTS v3 though)

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ContentIndex]
"FilterFilesWithUnknownExtensions"=dword:00000001

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\ContentIndex]
"FilterFilesWithUnknownExtensions"=dword:00000000

_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l

Reply via email to