Hi,
I am requiring to output a 2 digit country code based on a country.
Array would be something like
$array += [[[[Austria],[AU]],[[Brazil],[BZ]]]]
So i would expect it to be something like
if ($array -match 'Brazil'){ it returns BZ}
What would be the best way of going about that?
Thanks for help
Just a FYI: The two-letter country code for Austria is "AT", not "AU" -- Australia is "AU". ;-)
Don't use an array, use a hash instead:
$hash = @{Austria='AU'; Brazil='BZ'}
$CountryNames = 'Austria','Brazil','Canada'
$CountryNames |
ForEach-Object{
$CC = $hash[$_]
Write-Host "Country name '$_' has the code '$CC'" # doesn't report an error, just an empty country code
}
# -- or
$CountryNames |
ForEach-Object{
if($hash.ContainsKey($_)){
$CC = $hash[$_]
Write-Host "Country name '$_' has the code '$CC'"
}
Else{
Write-Host "Country name '$_' is not in lookup table"
}
}
If you'd rather use what data are present in the Windows O/S instead of building/maintaining your own translation table, give this a try. The $hash variable at the end is what you want:
$AllCultures = [System.Globalization.CultureInfo]::GetCultures([System.Globalization.CultureTypes]::SpecificCultures) # !AllCultures
$AllCultures |
ForEach-Object{
$dn = $_.DisplayName.Split("(|)");
$RegionInfo = New-Object System.Globalization.RegionInfo $PsItem.name;
[pscustomobject]@{
Name = $RegionInfo.Name;
EnglishName = $RegionInfo.EnglishName;
TwoLetterISORegionName = $RegionInfo.TwoLetterISORegionName;
GeoId = $RegionInfo.GeoId;
ISOCurrencySymbol = $RegionInfo.ISOCurrencySymbol;
CurrencySymbol = $RegionInfo.CurrencySymbol;
IsMetric = $RegionInfo.IsMetric;
LCID = $PsItem.LCID;
Lang = $dn[0].Trim();
Country = $dn[1].Trim();
}
} |
# get list of unique country names and ISO codes in Windows
Select-Object -Unique -prop TwoLetterISORegionName,EnglishName |
Sort-Object TwoLetterISORegionName |
ForEach-Object{
$hash[$_.EnglishName] = $_.TwoLetterISORegionName
}
All the information in the PSCustomObject isn't necessary. It doesn't hurt to know it's there, though.
The code was shamelessly purloined (and slightly modified) from here: powershell-get-list-of-two-letter-country-iso-3166-code-alpha-2-currency-language-and-more
Thanks Rich, its to go into a function so will have a think of the best way to do it..
$Delivery += "DELIVERY",$A[3],"",( Get-Random -Minimum 10000000000000000000 -Maximum 20000000000000000000 ).ToString('00000000000000000000'),"",$example[1].'Shipping Address Name',$example[1].'Shipping Address Line 1',$example[1].'Shipping Address Line 2',$example[1].'Shipping Address Suburb', $example[1].'Shipping Address City',$example[1].'Shipping Address State',$example[1].'Shipping Address Zip Code', Shipping Address Country 2 Letter ISO Code,"","",EM,$example[1].'Billing Address Email',$example[1].'TE,Billing Address Phone Number',"","","","","","","","","","","","","","","","","",""
Okay . . . I'm not following. You're loading an array with values, but the quoting in the code is incorrect. If you unwind it there are missing quotation marks around "Shipping Address Country 2 Letter ISO Code".
$Delivery += "DELIVERY",
$A[3],
"",
( Get-Random -Minimum 10000000000000000000 -Maximum 20000000000000000000 ).ToString('00000000000000000000'),
"",
$example[1].'Shipping Address Name',
$example[1].'Shipping Address Line 1',
$example[1].'Shipping Address Line 2',
$example[1].'Shipping Address Suburb',
$example[1].'Shipping Address City',
$example[1].'Shipping Address State',
$example[1].'Shipping Address Zip Code',
Shipping Address Country 2 Letter ISO Code,
"",
etc.
What's has this to do with the code samples I posted?????
getting error
Cannot convert value "World" to type "System.Int32". Error: "Input string was not in a correct format."
At D:\Powershell\EDI.ps1:31 char:22
+ ... $hash[$.EnglishName] = $.TwoLetterISORegionName
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidArgument: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvalidCastFromStringToInteger
Cannot convert value "Caribbean" to type "System.Int32". Error: "Input string was not in a correct format."
At D:\Powershell\EDI.ps1:31 char:22
+ ... $hash[$.EnglishName] = $.TwoLetterISORegionName
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidArgument: (:) [], RuntimeException
+ FullyQualifiedErrorId : InvalidCastFromStringToInteger
Again, I'm lost.
The code (assuming you're using the example that loads the has from systems localization data) "$hash[$<undebar>.EnglishName] = $<underbar>.TwoLetterISORegionName" doesn't involve casting anything to an integer value.
Are you sure that you don't have a missing quotation mark somewhere??? Using an IDE that does checking as you're writing the code (such as VS Code, or Visual Studio) can help you there.
10 people are following this question.
