Mackiez
1 discussion post
Good morning,
I would like to search inside TXT / XLS files using wildcards. So for instance, I am looking for all files that contain the word "Capital" as well as the wordk "Amount". Search Results should return any instance where for example there is Capital "Transfer" Amount, or Capital "Delinquency" Amount etc.
This would be pretty much similar to the LIKE function in SQL Server / Oracle where you would state:
******
SELECT *
FROM Table
WHERE ColumnA LIKE 'Capital%Amount'
******
Kind regards,
Jun 10, 2016 (modified Jun 10, 2016)
•
#1
You should be able to do this by entering the following into the Query box:
capital +amount
Hope that helps!