Forum Discussion
Chris1300
Helper II
Helper IIHow to parse SQL query command with Search?
Hello, I have a table in PowerBI, one of the columns is the [SQL_query_command] for auditing purposes. I would like to parse that column to extract the tables names. I think I can do this using t...
Have you considered using "FROM" as the string split identifier?
I was able to do this in power query and use the built in functions for split and extract functions. It involved multiple steps but i think i got it close enuf for it to be similar.
It would be nice for a feature to exist in powerbi to use some kind of RegEx as a parser maybe in the future. Thanks!
Chris1300Helper II
Helper III was able to do this in power query and use the built in functions for split and extract functions. It involved multiple steps but i think i got it close enuf for it to be similar.
It would be nice for a feature to exist in powerbi to use some kind of RegEx as a parser maybe in the future. Thanks!
lbendlin
Super User
Super Useryou can run a regex parser in a Python script inside Power Query.