So I have an Excel which has a column (in this case named 'TestNumber') which contains values in the form of "B" + 7 random digits, e.g. B1234567, B2345678...
I want to get the values which contain only the 7 digits i.e. I need Regex for this.
The Regex I wrote up for the case (tested it and it works) is the following: (?<=B|b)\d{7}|\d{7}
The problem is it doesn't work in an Execute SQL statement, this doesn't generate any values in my QueryResult:
Bear in mind I managed to solve this by using a For each loop and parsing each value using the same Regex and adding the result into a list, but the problem with this is that it slows down my process significantly.
Is there any way to use Regex in SQL in Power Automate Desktop and if yes - what is the correct syntax for my problem?
