"t-sql" tool for csv files?

Posted by adolf garlic on Programmers See other posts from Programmers or by adolf garlic
Published on 2012-03-19T13:30:44Z Indexed on 2012/03/19 18:13 UTC
Read the original article Hit count: 264

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.

© Programmers or respective owner

Related posts about applications

Related posts about file-handling