We have a CSV file that has a single column with information related to a drug medication.
The single column has a strength for the medication; we want to extract the strength and the name into two separate columns.
For example, a few of the columns are:
Zanaflex 2mg Tablet
Zanaflex 4mg Tablet
Zantac 25mg/mL Inj 2mL Amp
Zanidip 10mg Tablet
Zepholin SR 100mg Capsule
After processing, it should look like
Zanaflex Tablet - NEXT COLUMN: 2mg
Zanaflex Tablet - NEXT COLUMN: 4mg
Zantac Inj Amp - NEXT COLUMN: 25mg/mL 2mL
Zanidip Tablet - NEXT COLUMN: 10mg
Zepholin SR Capsule - NEXT COLUMN: 100mg