String search

[Valnurat]

How can I go though a one dimention array that contains "|" as separator?

 

Like this:
Blue | Red | Green

Blue | Yellow

Blue | Black | Orange | Brown

But the separator is not constant. It could be zero or it could 4, 5, 6 maybe 7

I need to add this in excel sheet like a treeview

Blue

     Red

          Green

     Yellow

     Black

          Orange

               Brown

 

[water]

If you add _ArrayDisplay after line 

ReDim $aTreeView[$iIndexTV + 1][3]

in function _AD_GetOUTreeView you will see that in the first column you have a number of trailing spaces before the character "#".

Grab this array and write it to Excel (untested):

Global $aExcelData[$aTreeView[0][0] - 1][99]
For $i = 1 to $aTreeView[0][0]
    $iPos = StringInStr($aTreeView[$i][0], "#")
    $aExcelData[$i - 1][$iPos - 1] = $aTreeView[$i][0]
Next
_Excel_RangeWrite($oWorkbook, Default, $aExcelData)

 

[TheSaint]

Is it already an array or just a string with delimeters?

If just a string, then create an array by using StringSplit.

With an array, you can then loop through it's parts.

Global $a, $array, $string, $value

$string = "Blue | Black | Orange | Brown"
$array = StringSplit($string, " | ", 1)
For $a = 1 To $array[0]
    $value = $array[$a]
    MsgBox(0, "Value", $value)
Next
Exit

 

[ViciousXUSMC]

Start with splitting it (You may also want to strip whitspace)

$sData = "Blue | Black | Orange | Brown"
$aData = StringSplit($sData, "|")

Then use Waters Exel UDF to feed that array to excel. 

[water]

TheSaint, ViciousXUSMC,

It's not that easy. He needs a treeview like structure. A posted a solution above.
And - as soon as I find some spare time - will add an Excel export function to the _AD_GetOUTreeView example script.

[Valnurat]

There is no space in the line and the scoure I got from using:

 

$aGroupMember = _AD_RecursiveGetGroupMembers($aGroup[$i])

[TheSaint]

TheSaint, ViciousXUSMC,

It's not that easy. He needs a treeview like structure. A posted a solution above.
And - as soon as I find some spare time - will add an Excel export function to the _AD_GetOUTreeView example script.

We all posted so close together, that I never saw your post.

My reply was just to get him started, and get more info and some code.

[water]

There is no space in the line and the scoure I got from using:

$aGroupMember = _AD_RecursiveGetGroupMembers($aGroup[$i])

Sorry, my post was a bit misleading. I mean you could grab array $aTreeView in function _AD_GetOUTreeView.
But if you could wait 1 or 2 days I'm sure I can come up with a function to let you export the treeview returned by _AD_GetOUTreeView to Excel.

[Valnurat]

Ok. I can wait.