Valnurat

How do I delete empty cells in a 2D array.

41 posts in this topic

#1 ·  Posted

I have a

Global $aResult[0][2]

For $i = 0 to UBound($aNames) -1
    Local $aUserInfo = _AD_GetObjectsInOU($aNames[$i],"","","displayName,distinguishedName")
    _ArrayDisplay($aUserInfo)
    _ArrayConcatenate($aResult, $aUserInfo, 1)
    _ArrayDisplay($aResult, 'AD ' & UBound($aResult))
Next

I do receive empty info that's added to my array.

How can I delete empty records?


Yours sincerely

Kenneth.

Share this post


Link to post
Share on other sites



#2 ·  Posted

Loop through the array from the end to the start und use _ArrayDelete to get rid of empty cells. 


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#3 ·  Posted

Valnurat,

Just for grins...

#include <array.au3>

Local $aArray = [[1, 2, 3], ['', '', ''], [4, 5, 6], [7, 8, 9, 0], ['', '', 'a', 'b'], [''], ['last row first cell']]

_ArrayDisplay($aArray)

For $i = UBound($aArray) - 1 To 0 Step -1
    For $j = 0 To UBound($aArray, 2) - 1
        If $aArray[$i][$j] <> '' Then ExitLoop
    Next
    If $j - 1 = UBound($aArray, 2) - 1 And $aArray[$i][$j - 1] = '' Then _ArrayDelete($aArray, $i)
Next

_ArrayDisplay($aArray)

kylomas


Forum Rules         Procedure for posting code

"I like pigs.  Dogs look up to us.  Cats look down on us.  Pigs treat us as equals."

- Sir Winston Churchill

Share this post


Link to post
Share on other sites

#4 ·  Posted

Exactly what I suggested above ;) 


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#5 ·  Posted

@water - Yes, just #@$%# around...nice sunny day here in central US...


Forum Rules         Procedure for posting code

"I like pigs.  Dogs look up to us.  Cats look down on us.  Pigs treat us as equals."

- Sir Winston Churchill

Share this post


Link to post
Share on other sites

#6 ·  Posted

:) 


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#7 ·  Posted (edited)

#include <array.au3>

Local $aArray = [[1, 2, 3], ['', '', ''], [4, 5, 6], [7, 8, 9, 0], ['', '', 'a', 'b'], [''], ['last row first cell']]

msgbox(0 , '' , stringstripWS(StringRegExpReplace(_ArrayToString($aArray) , "\|\|+" , " ") , 4))

yall don't #@$$$%# around nearly enough

Edited by iamtheky
2 people like this

,-. .--. ________ .-. .-. ,---. ,-. .-. .-. .-.
|(| / /\ \ |\ /| |__ __||| | | || .-' | |/ / \ \_/ )/
(_) / /__\ \ |(\ / | )| | | `-' | | `-. | | / __ \ (_)
| | | __ | (_)\/ | (_) | | .-. | | .-' | | \ |__| ) (
| | | | |)| | \ / | | | | | |)| | `--. | |) \ | |
`-' |_| (_) | |\/| | `-' /( (_)/( __.' |((_)-' /(_|
'-' '-' (__) (__) (_) (__)

Share this post


Link to post
Share on other sites

#8 ·  Posted

10 hours ago, iamtheky said:
#include <array.au3>

Local $aArray = [[1, 2, 3], ['', '', ''], [4, 5, 6], [7, 8, 9, 0], ['', '', 'a', 'b'], [''], ['last row first cell']]

msgbox(0 , '' , stringstripWS(StringRegExpReplace(_ArrayToString($aArray) , "\|\|+" , " ") , 4))

yall don't #@$$$%# around nearly enough

How do I use this? How do I put this back to an array?


Yours sincerely

Kenneth.

Share this post


Link to post
Share on other sites

#9 ·  Posted (edited)

EDIT: just answering the last question without regard to whether or not the output should be a 1D or 2D array.  If you liked the output that @iamtheky created and just want it in an array then this should work it assigns the string to a variable that splits the string back into an array using carriage returns with line feeds as the delimiter. 

#include <array.au3>

Local $aArray = [[1, 2, 3], ['', '', ''], [4, 5, 6], [7, 8, 9, 0], ['', '', 'a', 'b'], [''], ['last row first cell']]
$newArray=StringSplit(stringstripWS(StringRegExpReplace(_ArrayToString($aArray) , "\|\|+" , " ") , 4),@CRLF)
_ArrayDisplay($newArray)

 

Edited by Jfish
1 person likes this

Build your own poker game with AutoIt: pokerlogic.au3 | Learn To Program Using FREE Tools with AutoIt

Share this post


Link to post
Share on other sites

#10 ·  Posted

Ok, but this just end up in 1D array. It has to be in a 2D array.


Yours sincerely

Kenneth.

Share this post


Link to post
Share on other sites

#11 ·  Posted (edited)

I don't understand this request. Are you trying to delete empty rows in a 2D array? Deleting empty cells is impossible without also deleting rows or columns.

Edited by czardas

Share this post


Link to post
Share on other sites

#12 ·  Posted

also, why don't you check for empty records before the  _ArrayConcatenate() ?


small minds discuss people average minds discuss events great minds discuss ideas.... and use AutoIt....

Share this post


Link to post
Share on other sites

#13 ·  Posted

46 minutes ago, Chimp said:

also, why don't you check for empty records before the  _ArrayConcatenate() ?

That would be cheating.  Too easy. :)

1 person likes this

Share this post


Link to post
Share on other sites

#14 ·  Posted

17 hours ago, czardas said:

I don't understand this request. Are you trying to delete empty rows in a 2D array? Deleting empty cells is impossible without also deleting rows or columns.

My mistake. I will ofcourse delete rows. Just my bad words of choice.

 

17 hours ago, Chimp said:

also, why don't you check for empty records before the  _ArrayConcatenate() ?

And if I want to do that. How should I do that? Is there a UDF for this?


Yours sincerely

Kenneth.

Share this post


Link to post
Share on other sites

#15 ·  Posted

Do not use _ArrayConcatenate but loop through $aUserInfo and only write non blank rows to $aResult.


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#16 ·  Posted

Ok. I will do that.

Thank you for all your answers.


Yours sincerely

Kenneth.

Share this post


Link to post
Share on other sites

#17 ·  Posted

On 22/3/2017 at 8:12 AM, Valnurat said:

.... And if I want to do that. How should I do that? Is there a UDF for this? ....

I don't know what exactly is returned by the _AD_GetObjectsInOU() function , (emmm... sorry @water :)) , expecially when there is not data returned, anyway if you have only to scan all records to see if are all empty then something like this should do (not tested):

Global $aResult[0][2]
Local $aUserInfo

For $i = 0 To UBound($aNames) - 1
    $aUserInfo = _AD_GetObjectsInOU($aNames[$i], "", "", "displayName,distinguishedName")
    If _IsNotEmpty($aUserInfo) Then ; there is data in the record?
        ; _ArrayDisplay($aUserInfo)
        _ArrayConcatenate($aResult, $aUserInfo, 1)
    EndIf
Next

_ArrayDisplay($aResult, 'AD ' & UBound($aResult))

Func _IsNotEmpty(ByRef $aData)
    ; returns True if record contains data otherwise returns False
    Local $iSum = 0
    For $x = 1 To UBound($aData) - 1
        $iSum += $aData[$x] <> "" ; count not empty fields
    Next
    Return $iSum > 0 ; returns true if record is not empty
EndFunc   ;==>_IsNotEmpty

 


small minds discuss people average minds discuss events great minds discuss ideas.... and use AutoIt....

Share this post


Link to post
Share on other sites

#18 ·  Posted

Or you could modify the LDAP query so it only returns records where displayname<>""

2 people like this

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

#19 ·  Posted

Here is the _AD_GetObjectsInOU with the proper LDAP query that should get you what you need.  As mentioned by water.  This query only finds user accounts, and not computer accounts. 

$aUserInfo = _AD_GetObjectsInOU($aNames[$i], "(&(objectCategory=Person)(objectclass=user)(displayName=*))", "", "displayName,distinguishedName")

Here is some info on using LDAP Queries.  

 

Adam

 

1 person likes this

Share this post


Link to post
Share on other sites

#20 ·  Posted

Ok. I will try a different approach.

$aUserInfo = _AD_GetObjectsInOU("OU=company,DC=ad,DC=company,DC=org", "(&(objectCategory=Person)(objectclass=user)(sAMAccountName=" & $aNames[$i] & "*))", "", "displayName,distinguishedName")

But the result of this ends up with users that I'm not interested in. I would like to avoid where "TransferZone" is exists in distinguishedName.

Is it possble to add an extra filter?


Yours sincerely

Kenneth.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Similar Content

    • X_xkijux_x
      By X_xkijux_x
      Ok so im using this program. clarify for school. I would like to have a program that takes every word i type in microsoft word and searches on it in claryfi. is this possible. I would like to have the program not stopping me from typing more after that word. Like when i type a word it auto search it on clarify without making me stop typing and if i want to change i can do that and if im fine that word i can just keep typing and it will search after the next word. 
    • Miliardsto
      By Miliardsto
      Is this possible to make program works like in diagram? There is so much encryption methods and UDFs are they give security? If the $Address will be crypted with some encryption algorithm could be possible to get the value of $Address in easy way? Of course We know its easy too look into autoit code and get value of variable and so We dont want to anyone see $Address value - there are functions Could func1.au3, func2.au3.. be for example func1.php or other type of file? As we know .php files are unnable to see. For example func1 would be read by FileRead() and then Execute() Is this generally possible to do?
      Will it give secure?
      What do you think about? Maybe there is something wrong in this concept or missed.

    • JaredStroeb
      By JaredStroeb
      I need to open an application and send it keys in Session 0.  I have exe's working locally, I can see the application open in session 0 through interactive services, but my send commands do not go to the application.  The following article running-autoit-session-0, directs me to use ControlSend() however my application has no controls that can be identified by AutoIt v3 Window Info.  Get All Windows Controls also returned nothing for the application's handle.  
      What are my options?  
      Can this be done with AutoIt?
      Is there a different "relatively simple" library/tool to use? (I am familiar with C# if there is a viable library there )

       
    • nassausky
      By nassausky
      Hey all,
      Has anyone created any queries for youtube? I was thinking it might be something like this but can't quite figure it out:
      $oIE = _IECreateEmbedded() _IENavigate($oIE,"https://www.youtube.com") Local $oForms = _IETagNameGetCollection($oIE, "form") Local $sTxt = "" For $oForm In $oForms If $oForm.id = "masthead-search" Then $oInputs = _IETagNameGetCollection($oIE, "input") For $oInput In $oInputs If $oInput.id = "masthead-search-term" Then _IEFormElementSetValue($oInput, "cards") _IEFormSubmit($oForm) EndIf Next EndIf Next  
    • Skysnake
      By Skysnake
      Scite comes up occasional, almost incidentally, in some support topics.  I have not found a "Scite" topic in the forums, so this is where I will start.  I have recently been using Scite intensively, specifically with a large project and I have certain issues.  I know that Scite is not an AutoIt product, but it is so closely integrated to the core release that it makes sense to raise issues and request support here.  If this is not the right please refer me to the right forum.
      Thx
       
      Skysnake