Relevancy Question

(imported topic written by SystemAdmin)

Is there a way to test a string to see if its a number? I am returning a series of strings and I only want to act on the ones that are numeric.

Thanks in Advance

(imported comment written by jessewk)

Q: exists “1” as integer
A: true

Q: exists “a” as integer
A: false

Q: it whose (exists it as integer) of (“a” ; “b” ; “1” ; “2”; “3”)
A: 1
A: 2
A: 3

(imported comment written by SystemAdmin)

Thanks Jesse. I actually found that Friday night but for some reason I was taking the first 1 of the string and then seeing of it was an integer. I have a tendency to overcomplicate things. This is the relevancy I ended up with.

(((value whose (identifier of it as integer = 1015) of it)as string & " - " & (value whose (identifier of it as integer = 1023) of it)as string) & " - " & ((value whose (identifier of it as integer = 3001) of key “root” of it)as string)) of keys whose (exists name of it as integer) of key “LM/W3SVC” of metabase

I still have issues with "it"s and “Whose… it” statements from time to time. Can you take a look and let me know if there are any glaring issues?

Thanks

Lewis

(imported comment written by jessewk)

Lewis,

That looks solid to me.

-Jesse