Forum Discussion
How to parse SQL query command with Search?
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!
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!
you can run a regex parser in a Python script inside Power Query.