document Function - FindRowInFile

FindRowInFile

This function return the files that contains a word in a specific row and column.

example 1:

select * from FindRowInFile('path',null,'ToFind',2,'','|',3,'')

example 2:

select * from FindRowInFile('path','file.txt','ToFind',2,'','|',3,'')

example 3:

select * from FindRowInFile('path',null,'ToFind',2,'20170101','|',3,'')

parameters:

@path:
it's the directoty

@file:
if i want to get all files that contains that word i setted null, else i can set the file name to check only it.

@find:
it's the word to find.

@pos:
it's the column in the text where to find.

@date:
i can define the date of last modify of files or leave it "null".

@delimitator:
the delimitator of columns in text.

@row:
the row where find the word.

@filter
the extension to filter files, else blank ('') or null.