StringSplit returns empty aray

[Ostap]

Hi, 

I need to parse a text file extracted from active directory, and string looks like this: 

CN=Firstname0\, Lastname0 (UserID0),OU=_Marked for deletion,DC=Fabrikam,DC=COM^CN=Firstname1\, Lastname0 (UserID0),OU=Users,OU=EUR,DC=Fabrikam,DC=COM^CN=Firstname2\, Lastname2 (UserID3),OU=Users,OU=EUR,DC=Fabrikam,DC=COM

Code is very basic

$String0 = "CN=Firstname0\, Lastname0 (UserID0),OU=_Marked for deletion,DC=Fabrikam,DC=COM^CN=Firstname1\, Lastname0 (UserID0),OU=Users,OU=EUR,DC=Fabrikam,DC=COM^CN=Firstname2\, Lastname2 (UserID3),OU=Users,OU=EUR,DC=Fabrikam,DC=COM"
MsgBox (0, "$String0", $String0 ) ; returns msgbox with above string
$Members = StringSplit ( $String0, "^" )
MsgBox (0, "$Members", $Members ) ; returns empty

StringSplit returns empty array no matter what delimiters I try. What I am doing wrong? 

[Floops]

StringSplit returns an array which can't be displayed using a MsgBox. Use _ArrayDisplay instead.

[water]

In case of an error each AutoIt function either sets the return value or macro @error to a value denoting the kind of problem.
It is good practice to check this values after each function call.

[JLogan3o13]

@Ostap welcome to the forum. As mentioned above, the problem is a combination of trying to use the wrong tool for the job (a MsgBox to display an array) and a lack of error checking. I would suggest in addition that you spend some time reading the help file page for the particular function you plan to use. The examples provided (in this case 3) will show you the proper way to utilize the command to retrieve the results you're after.

[water]

I do not know which tool you run to extract the data from AD, but AutoIt provides the AD UDF to directly access AD and retrieve the needed information for further processing.
For download please check my signature.

[Skysnake]

; show result, this is quick and dirty
ConsoleWrite("result is not array " & $aResult &@CRLF) ; will write result to the console if it is NOT an array
IF _IsArray($aResult) Then _ArrayDisplay($aResult) ; will display a popup with array IF IS array

 

[water]

_IsArray doesn't work for StringSplit as this function always returns an array.
If the delimiter isn't found then @error is set to 1 and the full string is returned in $aArray[0] or $aArray[1] (depending on the $STR_NOCOUNT flag.

[rootx]

#include <MsgBoxConstants.au3>
#include <StringConstants.au3>
#include <Array.au3>

$String0 = ("CN=Firstname0\, Lastname0 (UserID0),OU=_Marked for deletion,DC=Fabrikam,DC=COM" _
         & "^CN=Firstname1\,Lastname0 (UserID0),OU=Users,OU=EUR,DC=Fabrikam,DC=COM" _
         & "^CN=Firstname2\, Lastname2 (UserID3),OU=Users,OU=EUR,DC=Fabrikam,DC=COM")
$Members = StringSplit ( $String0, "^",2)

Dim $Arr[0]

For $x = 0 to UBound($Members)-1
    ConsoleWrite($Members[$x]&@CRLF)
    _ArrayAdd($Arr,$Members[$x])
Next

_ArrayDisplay($Arr)

 

[JLogan3o13]

@rootx

So, you create an array with StringSplit, then cycle through that array to create a second array, then display the second array (which is exactly the same as the $Members array originally returned). Rube Goldberg much?

[rootx]

!!!

#include <MsgBoxConstants.au3>
#include <StringConstants.au3>
#include <Array.au3>

$String0 = ("CN=Firstname0\, Lastname0 (UserID0),OU=_Marked for deletion,DC=Fabrikam,DC=COM" _
         & "^CN=Firstname1\,Lastname0 (UserID0),OU=Users,OU=EUR,DC=Fabrikam,DC=COM" _
         & "^CN=Firstname2\, Lastname2 (UserID3),OU=Users,OU=EUR,DC=Fabrikam,DC=COM")
$Members = StringSplit ( $String0, "^",2)

_ArrayDisplay($Members)

For $x = 0 to UBound($Members)-1
    ConsoleWrite($Members[$x]&@CRLF)
Next

 

[JLogan3o13]

Just the same @rootx, both _ArrayDisplay and ConsoleWrite are for debugging purposes only. Why double the script's work by using both?

[rootx]

to show Ostap something useful to understand.. 4 ex debugging.

[iamtheky]

you can always put some debug in your debug

#include <Array.au3>

$String0 = ("CN=Firstname0\, Lastname0 (UserID0),OU=_Marked for deletion,DC=Fabrikam,DC=COM" _
         & "^CN=Firstname1\,Lastname0 (UserID0),OU=Users,OU=EUR,DC=Fabrikam,DC=COM" _
         & "^CN=Firstname2\, Lastname2 (UserID3),OU=Users,OU=EUR,DC=Fabrikam,DC=COM")

$members = StringSplit ( $String0, "^",2)
_ArrayDisplay($members , "Array+Console" , "" , 0 , 0 , 0 , 0 , 0 , consolewrite(_ArrayToString($members , @CR)))