Are you willing to limit yourself to a specific number of "excel digits"?
Thanks, -- Raul On Mon, Oct 21, 2013 at 3:35 AM, June Kim (김창준) <[email protected]> wrote: > A different, but more procedural approach is: > > efn2=.'ABCDEFGHIJKLMNOPQRSTUVWXYZ'{~[:}.((<.@%&26 , 26&|) @ <:@{. , > }.)^:(0~: {.)^:_ > > , and I don't like it much. :( > > > > On Mon, Oct 21, 2013 at 10:52 AM, June Kim (김창준) <[email protected]> wrote: > >> Hi >> >> A SW dev company posted its hiring post on its site and there is a coding >> program for the applicants. You can choose any language you want. >> >> The problem is: >> >> Write a code that converts an order number to the excel column name. The >> number starts from 1. >> >> e.g. 1->A, 2->B, 26->Z, 27->AA, ... >> >> Having no intention for applying, I thought this was a simple but >> interesting and authentic problem. Here is my solution (I included the >> inverse function as well for the fun): >> >> f=.26&#. >> efn=.'ABCDEFGHIJKLMNOPQRSTUVWXYZ' {~ }.@(1&, -&.f 1 #~ #)@(f inv) >> nfe=.[:f ' ABCDEFGHIJKLMNOPQRSTUVWXYZ'&i. >> >> efn 65535 >> CRXO >> nfe 'CRXO' >> 65535 >> >> Could you come up with simpler and more elegant solution? I'd like to see >> your solutions. >> >> June >> > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
