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

Question

So I've got an API integration that returns data in a single string field and I'd like to extract sections of the data to put into separate CDT fields. So the string that's returned will look something like this: "Advil 20 MG/ML Oral Suspension". I'd like to retrieve the data before the number, then everything after including the number. I've posted what I have so far below. What I'm wondering is how do I get the index of the first character that's a number? If I get that, then I can figure out the rest. Thanks! 
 
 a!forEach(
 items: rule!NLH_GetPrescriptionDrugs(searchTerm: ri!search).result.body.drugGroup.conceptGroup.conceptProperties,
 expression: a!forEach(
 items: fv!item,
 expression: 'type!{urn:com:appian:types:NLH}NLH_Prescription'(
 rxcui: fv!item.rxcui,
 medication: fv!item.synonym
 )
 )
)

GopalK · Accepted Answer

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
 )
 )
)

GopalK · Answer

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)
 
)

Richard Michaelis · Answer

try this for string a!localVariables(
 local!string:"Advil XX MG/ML Oral Suspension",
 stripwith(tostring(regexallmatches("[0-9]",local!string)), "; ")
) This one if you want to archive an integer output: a!localVariables(
 local!string:"Advil XX MG/ML 20 Oral Suspension",
 tointeger(tostring(regexallmatches("[0-9]",local!string)))
)

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

Top Replies