reading from file

[gembo]

Here it is in 2009

I got some trouble to save it in 2009. Not sure If it will be opening.

[zenthoef]

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.

[gembo]

thanks a lot. I really learn things here. Thank you.

[zenthoef]

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.

[jcarmody]

I was thinking like this:

[gembo]

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.

[gembo]

Sorry, I know where the problem is.  Never mind

[gembo]

Thanks guys, the solution given by Jim is also excellent. Thanks a lot.

[gembo]

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

...

[gembo]

solved. Thanks