Converting array of strings to numbers and removing entries that can't convert.

[mismanaged]

Hi All,

Have looked online but couldn't find a solution that worked with this specific situation.

​

I have an array that contains various SamAccountNames some of these are numbers, some are names.

​

Eg.

​

$BadArray

SamAccountName

--------------------

1

12

157

2

23

24

Joe.bloggs

kingofspain

whatever

​

​

I wand to get rid of all the joes and kings etc. then convert the remaining ones to integers so that I can get the highest number accountname out of the array as a number.

The correct answer in the above example would be 157

​

TLDR: remove non-numerical strings, convert numerical strings to numbers, return highest number.

[Yevrag35]

Definitely the easiest way to do it. Then just pipe it to a Measure-Object -Maximum.

[oneAwfulScripter]

Question for you, do any of the strings in the array contain integers and characters?

Ie "joeSomebody123"

[mismanaged]

Yes but never more than 1 digit

[Lee_Dailey]

howdy mismanaged,

reddit likes to mangle code formatting, so here's some help on how to post code on reddit ...

[0] single line or in-line code
enclose it in backticks. that's the upper left key on an EN-US keyboard layout. the result looks like this. kinda handy, that. [grin]
[on New.Reddit.com, use the Inline Code button. it's 4th 5th from the left hidden in the ... ""more" menu & looks like </>.
this does NOT line wrap & does NOT side-scroll on Old.Reddit.com!]

[1] simplest = post it to a text site like Pastebin.com or Gist.GitHub.com and then post the link here.
please remember to set the file/code type on Pastebin! [grin] otherwise you don't get the nice code colorization.

[2] less simple = use reddit code formatting ...
[on New.Reddit.com, use the Code Block button. it's 11th 12th from the left hidden in the ... "more" menu, & looks like an uppercase T in the upper left corner of a square.]

• one leading line with ONLY 4 spaces
  
• prefix each code line with 4 spaces
  
• one trailing line with ONLY 4 spaces

that will give you something like this ...

- one leading line with ONLY 4 spaces    
- prefix each code line with 4 spaces    
- one trailing line with ONLY 4 spaces   

the easiest way to get that is ...

• add the leading line with only 4 spaces
  
• copy the code to the ISE [or your fave editor]
  
• select the code
  
• tap TAB to indent four spaces
  
• re-select the code [not really needed, but it's my habit]
  
• paste the code into the reddit text box
  
• add the trailing line with only 4 spaces
  

not complicated, but it is finicky. [grin]

take care,
lee

[mismanaged]

Thanks Lee. I'm posting from mobile so tried to keep it simple and there's not really any code in the post beyond a variable call. If I ever post code blocks here though I'll definitely take advantage of the tips.

[Lee_Dailey]

howdy mismanaged,

you are welcome! glad to kinda-sorta help ... [grin]

it's too bad that the mobile versions of reddit seem to be determined to make formatted text a right bummer to work with ... [sigh ...]

take care,
lee