Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

Is there a tool that allows to query files based on the following criteria, and change them?

  • creation date
  • filenames (e.g. filetypeA_YYYYMMDD_data2.blah)
  • file content

For the example, the workflow could be the following one:

  • Get all files created between date x and date y, where the filename contains z and the file itself contains value x under column zzz.
  • Update it to be a different value/another column.
share|improve this question

closed as off-topic by gnat, MichaelT, Bart van Ingen Schenau, GlenH7, amon Jan 25 at 9:24

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions asking us to recommend a tool, library or favorite off-site resource are off-topic for Programmers as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it." – gnat, MichaelT, Bart van Ingen Schenau, GlenH7, amon
If this question can be reworded to fit the rules in the help center, please edit the question.

add comment

1 Answer

Your best bet would be to use something like SSIS to pull them into SQL Server. Or even to import the files into access.

There are a number of ways to query the filesystem but those won't understand the data structures within the CSV to query them. Updating that is an even more difficult trick -- the file might look like a database table but that doesn't mean it can "think" like one.

If you wanted to be crazy, you could try the ODBC text driver and see how far it gets ya.

share|improve this answer
    
+1 For being crazy to use the ODBC text driver. –  Core.B Mar 19 '12 at 20:28
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.