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 ) ) )
Discussion posts and replies are publicly visible
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))) )