RE: [RBASE-L] - RE: LISTOF question 10.0.4.10913 F I X E D !

2018-11-15 Thread Claudine Robbins 
Absolutely!  And thanks to the issue in the first place, I have Mike’s 
wonderful form and all the help I need from this list to boot!

Feeling very thankful.

Claudine

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Albert Berry
Sent: Thursday, November 15, 2018 4:02 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - RE: LISTOF question 10.0.4.10913 F I X E D !

Aren’t they just great? The slightest problem, no matter how insignificant, is 
fixed as if the whole program was failing.
Albert


On Nov 15, 2018, at 11:36 AM, Claudine Robbins 
mailto:crobb...@iexgroup.com>> wrote:

This issue is fixed in the next update.  Thank you R:DCC and staff at RBTI!

Claudine

From: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> 
[mailto:rbase-l@googlegroups.com] On Behalf Of Claudine Robbins
Sent: Friday, October 26, 2018 3:08 PM
To: rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com>
Subject: [RBASE-L] - LISTOF question 10.0.4.10913

Hello all,

My experience with LISTOF is that it automatically puts quotes around fields 
that contain commas but I’m running into a situation where it does not.

One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the space 
plus INC. as a separate value.

However, it correctly returns 3 for the ITEMCNT variable.

What am I overlooking?

R>sho v vValueList
YELLOW JACKET CONSTRUCTION,
INC.,YELLOW JACKET
OILFIELD,YELLOWHOUSE
MACHINERY CO.


--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - RE: LISTOF question 10.0.4.10913 F I X E D !

2018-11-15 Thread Albert Berry 
Aren’t they just great? The slightest problem, no matter how insignificant, is 
fixed as if the whole program was failing. 
Albert

> On Nov 15, 2018, at 11:36 AM, Claudine Robbins  wrote:
> 
> This issue is fixed in the next update.  Thank you R:DCC and staff at RBTI!
>  
> Claudine
>  
> From: rbase-l@googlegroups.com  
> [mailto:rbase-l@googlegroups.com ] On Behalf 
> Of Claudine Robbins
> Sent: Friday, October 26, 2018 3:08 PM
> To: rbase-l@googlegroups.com 
> Subject: [RBASE-L] - LISTOF question 10.0.4.10913
>  
> Hello all,
>  
> My experience with LISTOF is that it automatically puts quotes around fields 
> that contain commas but I’m running into a situation where it does not.
>  
> One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the 
> space plus INC. as a separate value. 
>  
> However, it correctly returns 3 for the ITEMCNT variable.
>  
> What am I overlooking?
>  
> R>sho v vValueList
> YELLOW JACKET CONSTRUCTION, 
> INC.,YELLOW JACKET 
> OILFIELD,YELLOWHOUSE 
> MACHINERY CO.
>  
> 
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php 
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+unsubscr...@googlegroups.com 
> .
> For more options, visit https://groups.google.com/d/optout 
> .
> 
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php 
> 
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+unsubscr...@googlegroups.com 
> .
> For more options, visit https://groups.google.com/d/optout 
> .

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Re: LISTOF question 10.0.4.10913

2018-10-27 Thread Michael Byerley 

We aim to please

On Saturday, October 27, 2018 at 6:10:41 PM UTC-4, crobbins wrote:
>
> Love it!  Works as advertised.  Thanks Mike!
>
>  
>
> *From:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *Michael Byerley
> *Sent:* Saturday, October 27, 2018 2:37 PM
> *To:* RBASE-L
> *Subject:* Re: [RBASE-L] - Re: LISTOF question 10.0.4.10913
>
>  
>
>
>   OK.  
>
>  
>
>   Here's  a workaround then.  In this Zipfile is an Rbase Form with a 
> UserDefinedListBox that behaves like a Choose.  You will have to change the 
> table, Expression values, and Where clause to suit your needs.  There's a 
> brief remark in the onAfter start EEP.
>
>  
>
>   guaranteed to work..  :)
>
>  
>
> http://www.byerley.net/zipwork/frmCho.zip
>
>  
>
>
>
>
> On Saturday, October 27, 2018 at 12:16:37 PM UTC-4, crobbins wrote:
>
> Thanks Mike, that works fine for the LISTOF command.  
>
>  
>
> However; the name picked in the subsequent CHOOSE command using the 
> vValueList now contains the company name *without the comma* (YELLOW 
> JACKET CONSTRUCTION INC.) so EDI USI COMPANIES WHERE COMPANY_NAME = 
> .VCHOOSE command fails the field match.  
>
>  
>
> I need for YELLOW JACKET CONSTRUCTION, INC. and other names containing 
> commas to be within quotes, like an AS CSV unload, i.e.:
>
>  
>
> SET NULL -0-
>
> OUTPUT test.csv
>
> UNLOAD DATA FOR i_companies USING company_name AS CSV WHERE company_name 
> CONTAINS 'YELLOW'
>
> OUTPUT SCREEN
>
> SET NULL ' '
>
> RBEDIT test.csv
>
> RETURN
>
>  
>
> 'YELLOW JACKET CONSTRUCTION, INC.'
>
> YELLOW JACKET OILFIELD
>
> YELLOWHOUSE MACHINERY CO.
>
>  
>
> Claudine
>
>  
>
> *From:* rba...@googlegroups.com [mailto:rba...@googlegroups.com] *On 
> Behalf Of *Michael Byerley
> *Sent:* Saturday, October 27, 2018 8:57 AM
> *To:* RBASE-L
> *Subject:* [RBASE-L] - Re: LISTOF question 10.0.4.10913
>
>  
>
>  
>
>  
>
> It doesn't.
>
>  
>
> Try this instead:
>
>  
>
>   (listof((srpl(ColumnWithEmbeddedComma,',','',0
>
>  
>
>
>
> On Friday, October 26, 2018 at 4:07:52 PM UTC-4, crobbins wrote:
>
> Hello all,
>
>  
>
> My experience with LISTOF is that it automatically puts quotes around 
> fields that contain commas but I’m running into a situation where it does 
> not.
>
>  
>
> One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the 
> space plus INC. as a separate value.  
>
>  
>
> However, it correctly returns 3 for the ITEMCNT variable.
>
>  
>
> What am I overlooking?
>
>  
>
> R>sho v vValueList
>
> YELLOW JACKET CONSTRUCTION, 
>
> INC.,YELLOW JACKET 
>
> OILFIELD,YELLOWHOUSE 
>
> MACHINERY CO.
>
>  
>
> [image: cid:image002.png@01D46D3C.007A56F0]
>
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+u...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+u...@googlegroups.com .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - Re: LISTOF question 10.0.4.10913

2018-10-27 Thread Claudine Robbins 
Love it!  Works as advertised.  Thanks Mike!

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Michael Byerley
Sent: Saturday, October 27, 2018 2:37 PM
To: RBASE-L
Subject: Re: [RBASE-L] - Re: LISTOF question 10.0.4.10913


  OK.

  Here's  a workaround then.  In this Zipfile is an Rbase Form with a 
UserDefinedListBox that behaves like a Choose.  You will have to change the 
table, Expression values, and Where clause to suit your needs.  There's a brief 
remark in the onAfter start EEP.

  guaranteed to work..  :)

http://www.byerley.net/zipwork/frmCho.zip




On Saturday, October 27, 2018 at 12:16:37 PM UTC-4, crobbins wrote:
Thanks Mike, that works fine for the LISTOF command.

However; the name picked in the subsequent CHOOSE command using the vValueList 
now contains the company name without the comma (YELLOW JACKET CONSTRUCTION 
INC.) so EDI USI COMPANIES WHERE COMPANY_NAME = .VCHOOSE command fails the 
field match.

I need for YELLOW JACKET CONSTRUCTION, INC. and other names containing commas 
to be within quotes, like an AS CSV unload, i.e.:

SET NULL -0-
OUTPUT test.csv
UNLOAD DATA FOR i_companies USING company_name AS CSV WHERE company_name 
CONTAINS 'YELLOW'
OUTPUT SCREEN
SET NULL ' '
RBEDIT test.csv
RETURN

'YELLOW JACKET CONSTRUCTION, INC.'
YELLOW JACKET OILFIELD
YELLOWHOUSE MACHINERY CO.

Claudine

From: rba...@googlegroups.com 
[mailto:rba...@googlegroups.com] On Behalf Of Michael Byerley
Sent: Saturday, October 27, 2018 8:57 AM
To: RBASE-L
Subject: [RBASE-L] - Re: LISTOF question 10.0.4.10913



It doesn't.

Try this instead:

  (listof((srpl(ColumnWithEmbeddedComma,',','',0



On Friday, October 26, 2018 at 4:07:52 PM UTC-4, crobbins wrote:
Hello all,

My experience with LISTOF is that it automatically puts quotes around fields 
that contain commas but I’m running into a situation where it does not.

One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the space 
plus INC. as a separate value.

However, it correctly returns 3 for the ITEMCNT variable.

What am I overlooking?

R>sho v vValueList
YELLOW JACKET CONSTRUCTION,
INC.,YELLOW JACKET
OILFIELD,YELLOWHOUSE
MACHINERY CO.

[cid:image002.png@01D46D3C.007A56F0]
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+u...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com<mailto:rbase-l+unsubscr...@googlegroups.com>.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [RBASE-L] - Re: LISTOF question 10.0.4.10913

2018-10-27 Thread Michael Byerley 

  OK.  
 
  Here's  a workaround then.  In this Zipfile is an Rbase Form with a 
UserDefinedListBox that behaves like a Choose.  You will have to change the 
table, Expression values, and Where clause to suit your needs.  There's a 
brief remark in the onAfter start EEP.

  guaranteed to work..  :)

http://www.byerley.net/zipwork/frmCho.zip




On Saturday, October 27, 2018 at 12:16:37 PM UTC-4, crobbins wrote:
>
> Thanks Mike, that works fine for the LISTOF command.  
>
>  
>
> However; the name picked in the subsequent CHOOSE command using the 
> vValueList now contains the company name *without the comma* (YELLOW 
> JACKET CONSTRUCTION INC.) so EDI USI COMPANIES WHERE COMPANY_NAME = 
> .VCHOOSE command fails the field match.  
>
>  
>
> I need for YELLOW JACKET CONSTRUCTION, INC. and other names containing 
> commas to be within quotes, like an AS CSV unload, i.e.:
>
>  
>
> SET NULL -0-
>
> OUTPUT test.csv
>
> UNLOAD DATA FOR i_companies USING company_name AS CSV WHERE company_name 
> CONTAINS 'YELLOW'
>
> OUTPUT SCREEN
>
> SET NULL ' '
>
> RBEDIT test.csv
>
> RETURN
>
>  
>
> 'YELLOW JACKET CONSTRUCTION, INC.'
>
> YELLOW JACKET OILFIELD
>
> YELLOWHOUSE MACHINERY CO.
>
>  
>
> Claudine
>
>  
>
> *From:* rba...@googlegroups.com  [mailto:
> rba...@googlegroups.com ] *On Behalf Of *Michael Byerley
> *Sent:* Saturday, October 27, 2018 8:57 AM
> *To:* RBASE-L
> *Subject:* [RBASE-L] - Re: LISTOF question 10.0.4.10913
>
>  
>
>  
>
>  
>
> It doesn't.
>
>  
>
> Try this instead:
>
>  
>
>   (listof((srpl(ColumnWithEmbeddedComma,',','',0
>
>  
>
>
>
> On Friday, October 26, 2018 at 4:07:52 PM UTC-4, crobbins wrote:
>
> Hello all,
>
>  
>
> My experience with LISTOF is that it automatically puts quotes around 
> fields that contain commas but I’m running into a situation where it does 
> not.
>
>  
>
> One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the 
> space plus INC. as a separate value.  
>
>  
>
> However, it correctly returns 3 for the ITEMCNT variable.
>
>  
>
> What am I overlooking?
>
>  
>
> R>sho v vValueList
>
> YELLOW JACKET CONSTRUCTION, 
>
> INC.,YELLOW JACKET 
>
> OILFIELD,YELLOWHOUSE 
>
> MACHINERY CO.
>
>  
>
> [image: cid:image002.png@01D46D3C.007A56F0]
>
> -- 
> For group guidelines, visit 
> http://www.rbase.com/support/usersgroup_guidelines.php
> --- 
> You received this message because you are subscribed to the Google Groups 
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an 
> email to rbase-l+u...@googlegroups.com .
> For more options, visit https://groups.google.com/d/optout.
>

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

RE: [RBASE-L] - Re: LISTOF question 10.0.4.10913

2018-10-27 Thread Claudine Robbins 
Thanks Mike, that works fine for the LISTOF command.

However; the name picked in the subsequent CHOOSE command using the vValueList 
now contains the company name without the comma (YELLOW JACKET CONSTRUCTION 
INC.) so EDI USI COMPANIES WHERE COMPANY_NAME = .VCHOOSE command fails the 
field match.

I need for YELLOW JACKET CONSTRUCTION, INC. and other names containing commas 
to be within quotes, like an AS CSV unload, i.e.:

SET NULL -0-
OUTPUT test.csv
UNLOAD DATA FOR i_companies USING company_name AS CSV WHERE company_name 
CONTAINS 'YELLOW'
OUTPUT SCREEN
SET NULL ' '
RBEDIT test.csv
RETURN

'YELLOW JACKET CONSTRUCTION, INC.'
YELLOW JACKET OILFIELD
YELLOWHOUSE MACHINERY CO.

Claudine

From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of 
Michael Byerley
Sent: Saturday, October 27, 2018 8:57 AM
To: RBASE-L
Subject: [RBASE-L] - Re: LISTOF question 10.0.4.10913



It doesn't.

Try this instead:

  (listof((srpl(ColumnWithEmbeddedComma,',','',0



On Friday, October 26, 2018 at 4:07:52 PM UTC-4, crobbins wrote:
Hello all,

My experience with LISTOF is that it automatically puts quotes around fields 
that contain commas but I’m running into a situation where it does not.

One of the fields is YELLOW JACKET CONSTRUCTION, INC., LISTOF returns the space 
plus INC. as a separate value.

However, it correctly returns 3 for the ITEMCNT variable.

What am I overlooking?

R>sho v vValueList
YELLOW JACKET CONSTRUCTION,
INC.,YELLOW JACKET
OILFIELD,YELLOWHOUSE
MACHINERY CO.

[cid:image002.png@01D46D3C.007A56F0]
--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 
rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

-- 
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- 
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.