Brand-search database

This project is about creating a brand-search database (around 60.000 records) encompassing several motorcycle application-lists, on the basis of the guidelines herebelow reported. You are kindly asked to: • unify the whole file in BOLT; • duplicate the line when you come across “/” (slash) in column E (models) and to write each model per line. [i.e. 821 MONSTER/DARK = 821 MONSTER 821 DARK] • when coming across an alphanumerical model in column E (models), separate by 1 shift alpha part from numerical one [i.e. 748R = 748 R] • when coming across “extended model name / 1 letter only” in column E (models), duplicate the line by keeping extended model name in the first line and by reporting extended model name followed by the 1-letter code in the second line. [i.e. 1299 PANIGALE/S/R = 1299 PANIGALE 1299 PANIGALE S 1299 PANIGALE R ] • duplicate the line when you come across “/” (slash) in column D (CC) and to write each displacement per line. [i.e. 796/800 796 MONSTER = 796 796 MONSTER 800 796 MONSTER ] • duplicate the line when you come across “/” (slash) both in column D (CC) and in column E (models) by associating per line the first displacement with the first model (and so on and so forth). [i.e. 916/996 MS4/MS4R = 916 MS4 996 MS4R] For any further information or any enquiry, you can contact us on +0039.3711722064 Mon - Fri, 8:00 - 12:30 a.m. 2:00 - 5:30 p.m. (Italian hour)