Dear all,
i have the following cell matrix
A = { [1] 'SLO' ' ' '' '' [1] 'SLO' ' ' '' '' [1] 'SLO' ' ' '' '' [1] 'SLO' 'M 2009' 'SLO' 'MA' [1] 'SLO' 'A 2009' 'SLO' 'MA' [1] 'SLO' 'M 2009' 'SLO' 'MA' [1] 'SLO' 'J 2009' 'SLO' 'MA' [1] 'SLO' 'J 2009' 'SLO' 'MA' [1] 'SLO' 'A 2009' 'SLO' 'MA' [1] 'SLO' 'S 2009' 'SLO' 'MA' [1] 'SLO' 'O 2009' 'SLO' 'MA' [1] 'SLO' 'N 2009' 'SLO' 'MA' [1] 'SLO' 'D 2009' 'SLO' 'MA' [1] 'SLO' 'J 2010' 'SLO' 'MA' [1] 'SLO' 'F 2010' 'SLO' 'MA' [1] 'SLO' 'M 2010' 'SLO' 'MA' [1] 'SLO' 'A 2010' 'SLO' 'MA' [1] 'SLO' 'M 2010' 'SLO' 'MA' [1] 'SLO' 'J 2010' 'SLO' 'MA' [1] 'SLO' 'J 2010' 'SLO' 'MA' [1] 'SLO' 'A 2010' 'SLO' 'MA' [1] 'SLO' 'S 2010' 'SLO' 'MA' [1] 'SLO' 'O 2010' 'SLO' 'MA' [1] 'SLO' 'N 2010' 'SLO' 'MA' [1] 'SLO' 'D 2010' 'SLO' 'MA' [1] 'SLO' 'J 2011' 'SLO' 'MA' [1] 'SLO' 'F 2011' 'SLO' 'MA' [1] 'SLO' 'M 2011' 'SLO' 'MA' [1] 'SLO' 'A 2011' 'SLO' 'MA' [1] 'SLO' 'M 2011' 'SLO' 'MA' [1] 'SLO' 'J 2011' 'SLO' 'MA' [1] 'SLO' 'J 2011' 'SLO' 'MA' [1] 'SLO' 'A 2011' 'SLO' 'MA' [2] 'KKK' ' ' ' ' '' [2] 'SLO' ' ' ' ' '' [2] 'SLO' ' ' '' '' [2] 'SLO' 'M 2009' 'SLO' 'MA' [2] 'SLO' 'A 2009' 'SLO' 'MA' [2] 'SLO' 'M 2009' 'SLO' 'MA' [2] 'SLO' 'J 2009' 'SLO' 'MA' [2] 'SLO' 'J 2009' 'SLO' 'MA' [2] 'SLO' 'A 2009' 'SLO' 'MA' [2] 'SLO' 'S 2009' 'SLO' 'MA' [2] 'SLO' 'O 2009' 'SLO' 'MA' [2] 'SLO' 'N 2009' 'SLO' 'MA' [2] 'SLO' 'D 2009' 'SLO' 'MA' [2] 'SLO' 'J 2010' 'SLO' 'MA' [2] 'SLO' 'F 2010' 'SLO' 'MA' [2] 'SLO' 'M 2010' 'SLO' 'MA' [2] 'SLO' 'A 2010' 'SLO' 'MA' [2] 'SLO' 'M 2010' 'SLO' 'MA' [2] 'SLO' 'J 2010' 'SLO' 'MA' [2] 'SLO' 'J 2010' 'SLO' 'MA' [2] 'SLO' 'A 2010' 'SLO' 'MA' [2] 'SLO' 'S 2010' 'SLO' 'MA' [2] 'SLO' 'O 2010' 'SLO' 'MA' [2] 'SLO' 'N 2010' 'SLO' 'MA' [2] 'SLO' 'D 2010' 'SLO' 'MA' [2] 'SLO' 'J 2011' 'SLO' 'MA' [2] 'SLO' 'F 2011' 'SLO' 'MA' [2] 'SLO' 'M 2011' 'SLO' 'MA' [2] 'SLO' 'A 2011' 'SLO' 'MA' [2] 'SLO' 'M 2011' 'SLO' 'MA' [2] 'SLO' 'J 2011' 'SLO' 'MA' [2] 'SLO' 'J 2011' 'SLO' 'MA' [2] 'SLO' 'A 2011' 'SLO' 'MA' [3] 'MMM' ' ' '' '' [3] 'SLO' ' ' '' '' [3] 'SLO' ' ' '' '' [3] 'SLO' 'M 2009' 'SLO' 'MA' [3] 'SLO' 'A 2009' 'SLO' 'MA' [3] 'SLO' 'M 2009' 'SLO' 'MA' [3] 'SLO' 'J 2009' 'SLO' 'MA' [3] 'SLO' 'J 2009' 'SLO' 'MA' [3] 'SLO' 'A 2009' 'SLO' 'MA' [3] 'SLO' 'S 2009' 'SLO' 'MA' [3] 'SLO' 'O 2009' 'SLO' 'MA' [3] 'SLO' 'N 2009' 'SLO' 'MA' [3] 'SLO' 'D 2009' 'SLO' 'MA' [3] 'SLO' 'J 2010' 'SLO' 'MA' [3] 'SLO' 'F 2010' 'SLO' 'MA' [3] 'RRR' 'M 2010' 'SLO' 'MA' [3] 'RRR' 'A 2010' 'SLO' 'MA' [3] 'SLO' 'M 2010' 'SLO' 'MA' [3] 'SLO' 'J 2010' 'SLO' 'MA' [3] 'SLO' 'J 2010' 'SLO' 'MA' [3] 'SLO' 'A 2010' 'SLO' 'MA' [3] 'SLO' 'S 2010' 'SLO' 'MA' [3] 'SLO' 'O 2010' 'SLO' 'MA' [3] 'SLO' 'N 2010' 'SLO' 'MA' [3] 'SLO' 'D 2010' 'SLO' 'MA' [3] 'SLO' 'J 2011' 'SLO' 'MA' [3] 'SLO' 'F 2011' 'SLO' 'MA' [3] 'SLO' 'M 2011' 'SLO' 'MA' [3] 'SLO' 'A 2011' 'SLO' 'MA' [3] 'SLO' 'M 2011' 'SLO' 'MA' [3] 'SLO' 'J 2011' 'SLO' 'MA' [3] 'SLO' 'J 2011' 'SLO' 'll' [3] 'SLO' 'A 2011' 'SLO' 'll' }
My goal is to obtain this one
A = {
[1] 'SLO' ' ' '' '' [1] 'SLO' ' ' '' '' [1] 'SLO' ' ' '' '' [1] 'SLO' '3/2009' 'SLO' 'MA' [1] 'SLO' '4/2009' 'SLO' 'MA' [1] 'SLO' '5/2009' 'SLO' 'MA' [1] 'SLO' '6/2009' 'SLO' 'MA' [1] 'SLO' '7/2009' 'SLO' 'MA' [1] 'SLO' '8/2009' 'SLO' 'MA' [1] 'SLO' '9/2009' 'SLO' 'MA' [1] 'SLO' '10/2009' 'SLO' 'MA' [1] 'SLO' '11/2009' 'SLO' 'MA' [1] 'SLO' '12/2009' 'SLO' 'MA' [1] 'SLO' '1/20010' 'SLO' 'MA' [1] 'SLO' '2/2010' 'SLO' 'MA' [1] 'SLO' '3/2010' 'SLO' 'MA' [1] 'SLO' '4/2010' 'SLO' 'MA' [1] 'SLO' '5/2010' 'SLO' 'MA' [1] 'SLO' '6/2010' 'SLO' 'MA' [1] 'SLO' '7/2010' 'SLO' 'MA' [1] 'SLO' '8/2010' 'SLO' 'MA' [1] 'SLO' '9/2010' 'SLO' 'MA' [1] 'SLO' '10/2010' 'SLO' 'MA' [1] 'SLO' '11/2010' 'SLO' 'MA' [1] 'SLO' '12/2010' 'SLO' 'MA' [1] 'SLO' '1/2011' 'SLO' 'MA' [1] 'SLO' '2/2011' 'SLO' 'MA' [1] 'SLO' '3/2011' 'SLO' 'MA' [1] 'SLO' '4/2011' 'SLO' 'MA' [1] 'SLO' '5/2011' 'SLO' 'MA' [1] 'SLO' '6/2011' 'SLO' 'MA' [1] 'SLO' '7/2011' 'SLO' 'MA' [1] 'SLO' '8/2011' 'SLO' 'MA' } and so forth for the rest of the individuals
where as you can see in the third column I have replace for example the month 'M 2009' with '3/2009'.
In my case i have 30000 individuals
Is there any code for achieving this?
Thanks
Best Answer