AnsweredAssumed Answered

Creating a Function to return database table names that contain a text phrase

Question asked by jgill@occu-med.com on Apr 23, 2015
Latest reply on Apr 24, 2015 by beverly

So I'm pretty new to writing recursive functions and I want to create a variable in a script that contains a list of tables in my solution that contain a specific text phrase.  I can use PatternCount and the Get ( TableNames ) function to see that there are 6 tables in my solution that match my search criteria but from there I get stuck.

 

The calculation below

PatternCount ( Get ( TableNames ) ; "myFile" ) ; "myTextPhrase" )

Returns a value of '6'.

 

How would I write a calculation to return the values of the tables that match the text phrase?

Outcomes