Splitting attributes & Getting specific records

Hi

Trying to break an attribute down into 2 pieces: main and remainder

e.g. Fruit | 2KG | £2.00

so want to break off fruit from the rest and have the remainder in another attribute.

Also working on a 50k dataset and want to get 1k specific id numbers i have in mind

thanks for help.  1st time user