I have a list of items and settings with dates in a single Excel cell like so:
Item A (1993) Setting A, Item B (1994) Setting B, Item C (1995), Item D (1992) Setting D,...
I wish to parse the cell and take each setting that is located after a date and before a comma and place it in its own cell like so:
I’m used to other programming languages, so I know how to do this there, but I’m trying to learn R and after reading the documentation, I did not see how I could do this within one or more steps. Hopefully some of you know what I’m looking for. Thanks in advance!