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

Taidot: tietojenkäsittely, PHP, tietojärjestelmäarkkitehtuuri

Näytä lisää: split, medication, Column, capsule, split file, inj, repost tablet, php split file, php split csv, separate columns, processing csv, csv extract data, csv data processing, extract data csv file, extract data csv php, php extract csv, php extract data csv, processing csv file, processing csv data, ml, extract data csv file, extract data csv, extract csv data, extract csv, csv processing

Tietoa työnantajasta:
( 24 arvostelua ) United States

Projektin tunnus: #4259003

1 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_23% %project_currencyDetails_sign_sub_24% tähän työhön


can do it as quickly as possible. m well aware of Excel, formula and required VBA. thakns

$100 USD 1 päivässä
(48 arvostelua)