Terbuka

Parse Data from Excel Column and Create 2 New Columns

Projek ini akan tamat dalam 4 hari lagi dan harga bida purata bernilai $139 USD.

Dapatkan sebut harga percuma untuk projek seperti ini
Bajet Projek
$30 - $250 USD
Jumlah Bida
74
Penerangan Projek

We have a spreadsheet approximately 20K Rows. Attached is the list of what needs to be parsed and added to the Columns Manufacturer and Model. I did the First few so you see what i want.

We need someone to Parse the Description and create a MFG and Part number column from the Title.

Titles look like this

FuturePlus Systems Hub Interface Analysis System Probe FS2225

I would expect the MFG to be as FuturePlus Systems and the Model is FS2225

Electroglas Wafer Prober 1031 w/ Olympus Microscope Head

MFG: Electroglas Part Number 1031

I-TECH Model IFC-4016-04E, Fibre Channel Analysis System, Finisar FCM-8519-2-T-4

MFG: I-TECH Model: IFC-4016-04E

Marathon Electric TQA56A34F7A 115/230V 1/3 HP 3450 RPM 1 Phase Motor 151-015-12

MFG: Marathon Electric Model TQA56A34F7A

Kemahiran Diperlukan

Mencari untuk memperoleh sedikit wang?

  • Tetapkan bajet anda dan tempoh masa
  • Rangkakan cadangan anda
  • Dibayar untuk kerja anda

Upah Freelancer yang juga membida projek ini

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online