topic Re: Substring / Parsing Help in QlikView

Substring / Parsing Help

Fri, 17 Jan 2014 19:16:52 GMT

I have several antibiotic drug names in one column. Each drug name varies in length, but all have a space between the drug name, dosage concentration, dosage unit of measure, etc…

I want to parse everything from the first character (from the left) to the first space and store in a separate field.

Given: Imipenem-Cilastatin 500 mg IV solution

Desired output: Imipenem-Cilastatin

I got close using the Subfield function, but not quite what I need

Subfield(Antibiotic,’ ‘) as Taxonomy

Any suggestions?

Re: Substring / Parsing Help

Nicole-Smith — Fri, 17 Jan 2014 19:19:28 GMT

Subfield(Antibiotic,' ', 1) as Taxonomy

Re: Substring / Parsing Help

MayilVahanan — Fri, 17 Jan 2014 19:20:48 GMT

Try like this

Subfield(Trim(Antibiotic),' ', 1) As Taxonomy

Re: Substring / Parsing Help

iktrayanov — Fri, 17 Jan 2014 19:22:37 GMT

Try

Subfield(Antibiotic,’ ‘,1) as Taxonomy