Splitting attributes & Getting specific records
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