SergeiK Posted August 7, 2017 Posted August 7, 2017 Hello Everyone, Is it possible to get shorter multiple condition expressions avoiding operator OR? for instance If @OSVersion In (Win_10, Win_7, Win8) Then. I got used to it in t-sql. Thank you.
water Posted August 7, 2017 Posted August 7, 2017 Please have a look at Switch or Select in the help file. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
mikell Posted August 7, 2017 Posted August 7, 2017 If StringRegExp(@OSVersion, '(?i)Win_(10|7|8)') Then ... SergeiK 1
SergeiK Posted August 8, 2017 Author Posted August 8, 2017 19 hours ago, mikell said: If StringRegExp(@OSVersion, '(?i)Win_(10|7|8)') Then ... Regular Expressions are very cool! Thanks a lot. But I thought it can be more easier. It will do anyway!
mikell Posted August 8, 2017 Posted August 8, 2017 Well, I'm pretty surprised that iamtheky didn't suggest If StringInStr("Win_10,Win_7,Win8", @OSVersion) Then ... which means the same but avoids regex
Gianni Posted August 8, 2017 Posted August 8, 2017 #include <SQLite.au3> Local $aResult, $iRows, $iColumns, $iRval _SQLite_Startup() _SQLite_Open() ; Open a :memory: database If _IN(@OSVersion, "WIN_10,WIN_7,WIN_8") Then MsgBox(0, '', "Yes") _SQLite_Close() _SQLite_Shutdown() Func _IN($1, $2) ; returns True or False $2 = StringReplace($2, ",", "','") ; Query $iRval = _SQLite_GetTable(-1, "SELECT '" & $1 & "' IN ('" & $2 & "') ;", $aResult, $iRows, $iColumns) Return $aResult[2] <> 0 EndFunc ;==>_IN Chimp small minds discuss people average minds discuss events great minds discuss ideas.... and use AutoIt....
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now