kor Posted August 2, 2012 Share Posted August 2, 2012 (edited) sample code I'm wondering how to check if every single cell in an array is not null. #include <Array.au3> Local $counter, $aSample[5] = ["one", "two", "three", "", "five"] _ArrayDisplay($aSample) For $i = 0 To UBound($aSample) - 1 If $aSample[$i] = "" Then $counter += 1 Next If $counter = UBound($aSample) Then ConsoleWrite("all cells have a value") Else ConsoleWrite("one or more cells do not have a value") EndIf Edited August 2, 2012 by kor Link to comment Share on other sites More sharing options...
water Posted August 2, 2012 Share Posted August 2, 2012 What in your example code does not work? My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Malkey Posted August 2, 2012 Share Posted August 2, 2012 sample code I'm wondering how to check if every single cell in an array is not null. #include <Array.au3> Local $counter, $aSample[5] = ["one", "two", "three", "", "five"] _ArrayDisplay($aSample) For $i = 0 To UBound($aSample) - 1 If $aSample[$i] = "" Then $counter += 1 Next If $counter = UBound($aSample) Then ConsoleWrite("all cells have a value") Else ConsoleWrite("one or more cells do not have a value") EndIf You are counting the empty elements of the array. So if none are emply, ($counter = 0), then "all cells have a value". Should be:- If $counter = 0 Then Link to comment Share on other sites More sharing options...
kor Posted August 2, 2012 Author Share Posted August 2, 2012 Should be:- If $counter = 0 Then that works. Thanks. Am I even going about things the right way? Is there a better/easier way to see if all values in an array are not null? Link to comment Share on other sites More sharing options...
water Posted August 2, 2012 Share Posted August 2, 2012 Is there a better/easier way to see if all values in an array are not null?Not that I know of. You have to loop through the whole array. My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
jdelaney Posted August 2, 2012 Share Posted August 2, 2012 (edited) _ArrayFindAll seems to work #include <Array.au3> dim $Array[5]=["1","","",3,4] $test = _ArrayFindAll ( $Array, "" ) ConsoleWrite ( UBound($test) & @CRLF ) Although this is looking for blank, not null Edited August 2, 2012 by jdelaney IEbyXPATH-Grab IE DOM objects by XPATH IEscriptRecord-Makings of an IE script recorder ExcelFromXML-Create Excel docs without excel installed GetAllWindowControls-Output all control data on a given window. Link to comment Share on other sites More sharing options...
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