kor Posted August 2, 2012 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
water Posted August 2, 2012 Posted August 2, 2012 What in your example code does not work? 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
Malkey Posted August 2, 2012 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
kor Posted August 2, 2012 Author 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?
water Posted August 2, 2012 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 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
jdelaney Posted August 2, 2012 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.
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