Well. That sounds reasonable. The company that's hiring is actually developing spreadsheet apps. MS Excel limits the number of columns and that limit seems ok. Moreover, I am willing to learn from various solutions. :)
On Mon, Oct 21, 2013 at 4:56 PM, Raul Miller <[email protected]> wrote: > 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 > ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
