3 Replies Latest reply on Apr 24, 2015 4:56 AM by beverly

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


      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?