Substring / Parsing Help

[#1]

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?

[Nicole-Smith]

Subfield(Antibiotic,' ', 1) as Taxonomy

[MayilVahanan]

Hi

Try like this

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

[iktrayanov · Accepted solution]

Try

Subfield(Antibiotic,’ ‘,1) as Taxonomy