Unanswered

Using Regex in Execute SQL statement and Excel as database

(0) Share

Report

Posted on by Satyanarayana

I have 2 columns name like product name & description in excel

My Frist question is if first character in "product name" starts with Special char, need to update it as Fail using Regex
Second one is when "description" contains Chinese characters or ??? or &nbsb; like these need to update it as Fail using Regex in Execute sql query

am trying like [product name] like ^[&$#@]

Please update me on this, thanks in advance

Categories:

Power Automate Desktop

All responses (3)

Answers (0)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Regex is not supported in SQL queries. You need to use proper SQL syntax to do this. For example, to cover the sample you shared, the clause should be

WHERE [product name] LIKE '&%' OR [product name] LIKE '$%' OR [product name] LIKE '#%' OR [product name] LIKE '@%'

You need to handle each possible case separately. And then, when using the LIKE operator, the % symbol is a wildcard.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
Satyanarayana 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply.. is CASE statement supports SQL query!!
Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

I do not understand the question. Can you please rephrase it? Also maybe provide an example?