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?