Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2008
    Posts
    13

    Unanswered: Search in all fields DBF Application Universal search inside a DBF

    Search in all fields DBF Application
    Universal search inside a DBF

    What application can I use for searching in all fields of a DBF database looking for a chain.

    Thanks
    Excuse my language. I'm from Canary Islands

  2. #2
    Join Date
    Aug 2002
    Posts
    233
    Quote Originally Posted by Esgrimidor
    Search in all fields DBF Application
    Universal search inside a DBF

    What application can I use for searching in all fields of a DBF database looking for a chain.

    Thanks
    Excuse my language. I'm from Canary Islands
    I think, it depends on the program language You use, but I think, there is no direct command to do this.

    I have two ideas to solve Your problem:

    - open the dbf file in Excel and start a search for a string value
    - open the file as binary, and simple search the readed text value
    Tibor Antal
    Budapest
    Hungary

  3. #3
    Join Date
    Dec 2008
    Posts
    13
    I try and comment

    I understand the excel part, but what is the second option ?

    What application can I use to open the database as a binary file ?

  4. #4
    Join Date
    Dec 2008
    Posts
    13
    I think don't go in the memo fields.

    At least with Excel

  5. #5
    Join Date
    Aug 2002
    Posts
    233
    Do You want to program it, or You wish to do it manually?

    If manually, then it's very simple, go the the directory, where the file is, and use the dos "Edit" command.

    This will start the dos editor, simply use OPEN and CHECK the "open as binary" option. After this, You shell see the file as binary, and You can search for any text with the "search" option
    Tibor Antal
    Budapest
    Hungary

  6. #6
    Join Date
    Aug 2002
    Posts
    233
    Quote Originally Posted by Esgrimidor
    I think don't go in the memo fields.

    At least with Excel
    That's correct, because the memo fields are exists in a different file - to check the string there simply use the same methods on the memo file.
    Tibor Antal
    Budapest
    Hungary

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •