How to parse data from a string, specifically how do I find the index of the first character that's a number?

I'm sure there are more elegant ways, but you can use the following fragment to return a list of indices for every possible numeric value:

fn!wherecontains(
  {"0","1","2","3","4","5","6","7","8","9"},
  fn!char(fn!code("Advil 20 MG/ML Oral Suspension"))
)

If the returned array is empty, then your string contains no numerics, otherwise the first item in the array is the index of the first number.

Hi, You can try below code as well.

a!localVariables(
  local!string:"Advil 20 MG/ML Oral Suspension",
  find(regexfirstmatch("[0-9]",local!string),local!string)
  
)

Neater...but if the string contains no numbers it throws an error:

a!localVariables(
  local!string:"Advil XX MG/ML Oral Suspension",
  find(regexfirstmatch("[0-9]",local!string),local!string)

)

...results in:

Yes, In that case null check can be applied,

a!localVariables(
  local!string: "Advil xx MG/ML Oral Suspension",
  if(
    a!isNullOrEmpty(regexfirstmatch("[0-9]", local!string)),
    "",
    find(
      regexfirstmatch("[0-9]", local!string),
      local!string
    )
  )
)

I got 7 as result?

try this for string
 

a!localVariables(
  local!string:"Advil XX MG/ML Oral Suspension",
  stripwith(tostring(regexallmatches("[0-9]",local!string)), "; ")
)

a!localVariables(
  local!string:"Advil XX MG/ML 20 Oral Suspension",
  tointeger(tostring(regexallmatches("[0-9]",local!string)))
)

Thanks! This is the one I went with. Works great, I appreciate the help!

Unknown said:

I got 7 as result?

Seems correct to me (?)

hahahaha made my day.
but the target was to get the number itself, if I got it right?

Unknown said:

get the number itself

Oh - I was thinking of the OP's question which was, "What I'm wondering is how do I get the index of the first character that's a number?", which is what the above is.