CSV column split - repost

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

Datenverarbeitung PHP Softwarearchitektur

Projekt-ID: #4259003

Über das Projekt