Hi All, Thanks for any help in advance. I have a dataset that is like this: Key Width 123 99,99 456 99 789 87,99,142 What I wish I had was the following: Key NewWidth Number 123 99 1 123 99 2 456 99 1 789 87 1 789 99 2 789 142 3 I have searched a few of the messages and gotten some things to work but they require the NewWidth to always be the same # of characters...which it can be 2 or 3 characters. So far I have attempted using substr(), scan(), countc()...nothing has clicked. Again, thanks for any pointers!!!
... View more