One bug though: I'm not able to specify 29 as a parameter to ]BOXING. Regards, Elias
On 16 April 2016 at 23:55, Elias Mårtenson <loke...@gmail.com> wrote: > Very nice! It's so much better, that I have to create an example showing > just how neat it is. > > Here's the result from selecting from a simple table using 8⎕CR: > > * 8⎕CR 'select * from foo' SQL∆Select[db] ⍬* > ┌→─────────────────────────────┐ > ↓ 1 ┌→──┐ ┌→──────┐ 832│ > │ │foo│ │Value:1│ │ > │ └───┘ └───────┘ │ > │ 2 ┌→────┐ ┌→──────┐ 146│ > │ │hello│ │Value:2│ │ > │ └─────┘ └───────┘ │ > │ 3 ┌→───┐ ┌→──────┐ 885│ > │ │test│ │Value:3│ │ > │ └────┘ └───────┘ │ > │ 4 ┌→─────────┐ ┌→──────┐ 192│ > │ │some value│ │Value:4│ │ > │ └──────────┘ └───────┘ │ > │ 5 ┌→──┐ ┌→──────┐ 182│ > │ │foo│ │Value:5│ │ > │ └───┘ └───────┘ │ > │ 6 ┌→────┐ ┌→──────┐ 965│ > │ │hello│ │Value:6│ │ > │ └─────┘ └───────┘ │ > │ 7 ┌→───┐ ┌→──────┐ 309│ > │ │test│ │Value:7│ │ > │ └────┘ └───────┘ │ > │ 8 ┌→─────────┐ ┌→──────┐ 69│ > │ │some value│ │Value:8│ │ > │ └──────────┘ └───────┘ │ > │ 9 ┌→──┐ ┌→──────┐ 774│ > │ │foo│ │Value:9│ │ > │ └───┘ └───────┘ │ > │10 ┌→────┐ ┌→───────┐ 469│ > │ │hello│ │Value:10│ │ > │ └─────┘ └────────┘ │ > └∊─────────────────────────────┘ > > And here's the same query with 27⎕CR: > > * 29⎕CR 'select * from foo' SQL∆Select[db] ⍬* > ┏→━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓ > ↓ 1 "foo" "Value:1" 832┃ > ┃ 2 "hello" "Value:2" 146┃ > ┃ 3 "test" "Value:3" 885┃ > ┃ 4 "some value" "Value:4" 192┃ > ┃ 5 "foo" "Value:5" 182┃ > ┃ 6 "hello" "Value:6" 965┃ > ┃ 7 "test" "Value:7" 309┃ > ┃ 8 "some value" "Value:8" 69┃ > ┃ 9 "foo" "Value:9" 774┃ > ┃10 "hello" "Value:10" 469┃ > ┗∊━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┛ > > Thanks again for this. This is invaluable, especially when working with > mixed data. > > Regards, > Elias > > On 16 April 2016 at 23:25, Juergen Sauermann < > juergen.sauerm...@t-online.de> wrote: > >> Hi Elias, Blake, >> >> I have added *29 ⎕CR* in *SVN 720*. >> >> It uses e.g. *'a'* for character scalars, *"hello"* for character >> strings, >> and a double-line frame around character arrays with higher ranks. >> >> >> * 29 ⎕CR 2 3⍴ 1 2.2 'a' "hello" (2 2 3⍴'ABCD')* >> ┏→━━━━━━━━━━━━━━━━━━┓ >> ↓ 1 2.2 'a'┃ >> ┃ ┃ >> ┃ ┃ >> ┃"hello" ╔═══╗ 1┃ >> ┃ ║ABC║ ┃ >> ┃ ║DAB║ ┃ >> ┃ ║ ║ ┃ >> ┃ ║CDA║ ┃ >> ┃ ║BCD║ ┃ >> ┃ ╚═══╝ ┃ >> ┗∊━━━━━━━━━━━━━━━━━━┛ >> >> Hope you like it. >> >> /// Jürgen >> >> >> >> On 04/14/2016 02:48 AM, Blake McBride wrote: >> >> Putting quotes around strings is important so you can see leading and >> trailing blanks. >> >> On Wed, Apr 13, 2016 at 1:07 PM, Juergen Sauermann < >> juergen.sauerm...@t-online.de> wrote: >> >>> Hi, >>> >>> I can look into this. However, how shall we handle character arrays with >>> rank > 1? >>> Quotes on every line or one quote at the beginning and one at the end >>> (for example)? >>> >>> If the problem is distinguishing numbers and characters then we could >>> also use a different >>> frame type (like bold or double-line for characters). That would also be >>> closer to the "normal" >>> display of APL values (the quotes are input-only). >>> >>> /// Jürgen >>> >>> >>> On 04/13/2016 02:38 PM, Elias Mårtenson wrote: >>> >>> I agree, and specifically I'd suggest using double quotes for an >>> encapsulated array of characters, while using single quotes to indicate the >>> difference between characters and numbers inside an array. >>> >>> This would be analogous with the GNU APL extension where double quotes >>> ensures arrays even for single characters. >>> >>> I'm on mobile now so I can't really make any good examples. But I'm >>> hoping you'll understand what I mean. >>> >>> Regards, >>> Elias >>> On 13 Apr 2016 8:26 p.m., "Blake McBride" <blake1...@gmail.com> wrote: >>> >>>> Off the cuff, it seems like putting quotes around strings is a really >>>> good idea. How else would you tell the difference between 123 and "123"? >>>> >>>> Blake >>>> >>>> On Wed, Apr 13, 2016 at 2:34 AM, Elias Mårtenson <loke...@gmail.com> >>>> wrote: >>>> >>>>> Given the following expression: >>>>> >>>>> * 8⎕CR 2 2⍴10 'foo' 20 'bar'* >>>>> ┌→───────┐ >>>>> ↓10 ┌→──┐│ >>>>> │ │foo││ >>>>> │ └───┘│ >>>>> │20 ┌→──┐│ >>>>> │ │bar││ >>>>> │ └───┘│ >>>>> └∊───────┘ >>>>> >>>>> The combination of strings and numbers in the array isn't very pretty. >>>>> >>>>> I'd like to suggest that it renders as following instead: >>>>> >>>>> ┌→───────┐ >>>>> ↓ ┌→──┐│ >>>>> │10 │foo││ >>>>> │ └───┘│ >>>>> │ ┌→──┐│ >>>>> │20 │bar││ >>>>> │ └───┘│ >>>>> └∊───────┘ >>>>> >>>>> I would also like to see another ⎕CR mode that would render it like >>>>> below, as this would make displaying arrays with lots of strings (in my >>>>> case, database table content) much easier to read: >>>>> >>>>> ┌→───────┐ >>>>> ↓10 "foo"│ >>>>> │20 "bar"│ >>>>> └∊───────┘ >>>>> >>>>> Jürgen, what's your opinion on this? >>>>> >>>>> Regards, >>>>> Elias >>>>> >>>> >>>> >>> >> >> >
