CODEWITHSUNDEEP
powershellvariables
Mike
Mike

Reputation: 164

Powershell confusion about Variable

I am confused regarding variables.

I have code, where I have the following line:

$search = $Name.SelectedItem.Split('-')[$($Name.SelectedItem.Split('-').Count-1)]+'*'

This line does nothing else, as split up a selected item (I am working with a Dropdownbox) and transfers it to $search.

The funny thing is, it does exactly that, what I want it to do.

When I type $search, the result can be for example:

Rue de Rivoli*

When I continue in the code and use $search through several arrays, for some reason, it does not function, because it does not find anything in a foreach loop. I have no error message and even the Rue de Rivoli* existing in one of the arrays, it does not find anything.

When I replace the above code and give directly the name to the variable $search, as seen below

$search = 'Rue de Rivoli*'

my search in the array works.

What am I missing here? I am doing something wrong, but I do not know what it is, can someone help me please to understand?

Thank you very much,

Mike

As requested, here more of the code. It is a lot to deal with, that is why I shorten it.

Clear-Host
$search = $CreateNewUserFormDropDownBoxLocation.SelectedItem.Split('-')[$($CreateNewUserFormDropDownBoxLocation.SelectedItem.Split('-').Count-1)]+'*'
#$search = 'Rue de Rivoli*'

$AllLocations = (get-variable -Include USPennsylvaniaAve, USSixthStreet, USRodeoDrive, USOneMicrosoftWay,`
                    USNorthTantauAvenue, USMarketStreet, USMainStreet, USEmilyDrive,`
                    USCalle8, USBroadway, US18thStreetNW, UKOxfordStreet, UKDowningStreet,`
                    UKBondStreet, FRRuedeRivoli, FRChampsElysees, CHBahnhofstrasse,`
                    CA17thAvenue) | ? {$_.value -is [array]}

Foreach ($Array in $AllLocations)
{
    if ($array.value -like $search)
    {break}
}
$result = "`$$($array.name)"
$result

This is about to become a function and does nothing else, as from the selecteditem, it takes it apart and add's the * behind it, so I can search for a name with a wildcard.

I have several arrays and therefore I included only the necessary ones. Next step is to loop through the arrays and as soon as it found the item, it stops and gives the result to result. This is my test code and it runs and does what I want, besides the line after Clear-Host. The code is correctly resolved and added to $search but does not work. Below that code of line, I have my cheat line, where I add directly the correct result to the variable and it works fine.

Upvotes: 1

Views: 65

Answers (1)

Theo
Theo

Reputation: 61253

As commented, this should solve the problem.

(I'm adding this as answer too, so the OP can accept it. Otherwise this question will remain seemingly unsolved)

When hardcoding the search string $search = 'Rue de Rivoli*' works, but using a Split() to get the search string does not, then usually the string you obtain using the split is surrounded by whitespace characters. If you leave these in, the string will appear to look just fine, but when using as comparison it won't work.

If for instance the complete $CreateNewUserFormDropDownBoxLocation.SelectedItem string is:

"François Exemple - Rue de Rivoli"

Then, using $CreateNewUserFormDropDownBoxLocation.SelectedItem.Split("-")[-1] will return:

" Rue de Rivoli"

Note the space in front.

By simply performing a Trim() you will get rid of that space.

The line therefore should be:

$search = ($CreateNewUserFormDropDownBoxLocation.SelectedItem.Split('-')[-1]).Trim() + '*'

Upvotes: 1

Related Questions