Thank you gentlemen.
Dan Ell I used your suggestion and add an additional S(). Thanks.
This returns 14 which is the number of multi-values in attribute 18 that
have an actual value.
LIST RMIM *A0 CONV 'A;S(S(18 # ""))'
PAGE
1
18:44:17 19 DEC 2014
RMIM.......... *A0...........
293569 14
018
]]]]244718]248862]250436]256863]263303]323613]387756]402361]407766]407908]415466]415691]C127599]]]123456]]]]]
On Friday, December 19, 2014 4:37:10 PM UTC-5, DanE wrote:
>
> You can do it using the CONV jQL extension
>
>
>
> LIST MYFILE *A0 CONV ‘A;S( 42 # “” )’
>
>
>
> In other words, just put the correlative from 8 as the CONV with single
> quotes around it.
>
>
>
> Dan Ell
>
> *From:* [email protected] <javascript:> [mailto:
> [email protected] <javascript:>] *On Behalf Of *Daniel Klein
> *Sent:* Friday, December 19, 2014 3:43 PM
> *To:* [email protected] <javascript:>
> *Subject:* Re: jBase on Linux - SELECT
>
>
>
> How can you do this without creating a DICT item, unless you intend to do
> it with a BASIC program?
>
>
>
> Dan
>
>
>
> On Fri, Dec 19, 2014 at 3:16 PM, Daniel Klein <[email protected]
> <javascript:>> wrote:
>
> Assuming you are looking for the A-type (10-line) dictionary format
> and the data is in attribute 42 :
>
>
>
> ID: ITEMS.ORDERD
>
> 0001 A
>
> 0002 0
>
> 0003
>
> 0004
>
> 0005
>
> 0006
>
> 0007 MD0,
>
> 0008 A;S( 42 # "" )
>
> 0009 R
>
> 0010 10
>
>
>
> Dan
>
>
>
> On Fri, Dec 19, 2014 at 1:52 PM, wsw <[email protected] <javascript:>>
> wrote:
>
> Without using an I-TYPE or creating a DICT item is there a way to count
> the number of items in a particular field that actually have a value.
> Example;
>
> 1]2]3]]]]]10]11]25
>
> I would like the list to display like
>
> MYFILE.......... ITEMS.ORDERED
>
> 293569 6
>
>
> 1 Records Listed
>
> Thanks in advance,
>
> WW
>
> --
> --
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>
> To post, send email to [email protected] <javascript:>
> To unsubscribe, send email to [email protected] <javascript:>
> For more options, visit this group at
> http://groups.google.com/group/jBASE?hl=en
>
> ---
> You received this message because you are subscribed to the Google Groups
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected] <javascript:>.
> For more options, visit https://groups.google.com/d/optout.
>
>
>
>
>
> --
> --
> IMPORTANT: T24/Globus posts are no longer accepted on this forum.
>
> To post, send email to [email protected] <javascript:>
> To unsubscribe, send email to [email protected] <javascript:>
> For more options, visit this group at
> http://groups.google.com/group/jBASE?hl=en
>
> ---
> You received this message because you are subscribed to the Google Groups
> "jBASE" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected] <javascript:>.
> For more options, visit https://groups.google.com/d/optout.
>
--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
---
You received this message because you are subscribed to the Google Groups
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
