04-20-2011 02:00 PM
Here it is in 2009
I got some trouble to save it in 2009. Not sure If it will be opening.
04-20-2011 02:32 PM
You're really close.The reason your Array indicator is not giving you the results you want is because the loop is only running as many times as Array 2 is large (you should be using Array 2 to feed the 2nd for loop). To get the letters that aren't there you'd have to make the alphabet into an array and autoindex that, and search for the letters you already have, and remove them from that array. Then you can concatenate each letter with the error code for the rest of the alphabet. Finally, for each item generated by the first set of code you can concatenate this result to that and you'll have what you need.
I did this real quick. See if this makes sense to you.
04-20-2011 02:47 PM
thanks a lot. I really learn things here. Thank you.
04-20-2011 02:50 PM
Glad you could learn a few things. If there is anything you don't understand after giving it some thought, be sure to let me know and I'll fill you in.
04-20-2011 03:05 PM
04-20-2011 03:11 PM
Sorry, one last issue: I put rest of input, It seems not to work, could you please take a look. I also added a small module just to save the result in excell. But this not causing the problem.
04-20-2011 03:16 PM
Sorry, I know where the problem is. Never mind
04-20-2011 03:23 PM
Thanks guys, the solution given by Jim is also excellent. Thanks a lot.
04-20-2011 06:10 PM
Sorry, looks like I forgot a requirement. Please take a look at what I did but cannot get it right yet.
the requirement is that the face number (the # after Face) has to appear also in front of a all of them.
for example the ouput of spot1 should look like this:
100 a 112
100 b 131
100 c 143
100 d 160
100 e 147
100 f 218
100 g 274
100 h 350
100 i 128
.
.
.
and spot 2 like this
101 e 102
101 i 699
...
04-21-2011 09:39 AM
solved. Thanks