Forum Discussion
Search a List of Table names in SQL
Hi, I have multiple SQL's generally each one having 100+ lines of SQL code , Swcond I have a list of tables stored in Excel column wise Task -- I want to search if any of these table name...
Afraid that's not exactly Excel task. Before the formal logic is to be defined how to extract table name from SELECT, JOIN, etc. With it we may parse SQL statement with Excel or any other tool.
Actually i was trying to separate the table names from the query maybe by using macros and then once that is separated we can easily make a vlookup or something
That doesn't matter what to use. Macros, poor formulas, Power Query, whatever. Without the formal logic for parsing non of them works.