Happy New Year!...hope you had a great Christmas.
I have been puzzling over a data ‘cleaning’ issue and wondered if you might be able to suggest a solution. In summary, some of my feeds supply age information in the format:
3-4 years,5-6 years,9-10 years,4-5 years,11-12 years,7-8 years
I would like to convert the data into individual values, so for example 3-4 years would become 3 years, 4 years.
I realise I could do this with a whole bunch of search and replace filters, one for each variation but I wondered if you might be able to suggest a neater and more efficient way of doing this change?
Thanks in advance.