Ok this should be really easy (I think!) but can't get it to work! All I want to be able to do is have one column with data like the stuff below and the next colum to contain the 5 numbers (ie 42055 or 45433) that occur after the last "/" (not always the 3rd).
Anyone got any ideas?
Sample data:
October ABC/Standard Input 100x200/Random/42055
October ABC/Standard Input 100x200/Random/42055 tag 2
December AAA/Fixed Input 100x300/Fixed/45433
Many thanks,
Seth
Anyone got any ideas?
Sample data:
October ABC/Standard Input 100x200/Random/42055
October ABC/Standard Input 100x200/Random/42055 tag 2
December AAA/Fixed Input 100x300/Fixed/45433
Many thanks,
Seth