RE: [RBASE-L] - LISTOF question 10.0.4.10913

2018-10-27 Thread Javier Valencia 
Claudine,
 
Try the following:
 
SELECT LISTOF( +  your column + ) into xxx from your_table WHERE …
 
All the items should have single quotes and the comma should be inside the 
quotes.
 
Javier,
 
Javier Valencia, PE
O: 913-829-0888
H: 913-397-9605
C: 913-915-3137
 
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.
 
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.

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.
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] - GATEWAY

2018-10-27 Thread Bruce A. Chitiea 

Jan:

Not according to RSYNTAX. Would the intent be to store TableColumnName 
aliases within the dataset?


Example:

Table columnname: IMHO

First Column Row Value: 'In My Humble Opinion'

Bruce



-- Original Message --
Sent: 10/27/2018 12:31:58 PM
Subject: [RBASE-L] - GATEWAY
From: "jan johansen" 
To: rbase-l@googlegroups.com
Cc:

All,

While using GATEWAY IMPORT to a new table from a CSV file, is there an 
option to use first row as table Column Names?


Jan


--
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 

  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.

[RBASE-L] - GATEWAY

2018-10-27 Thread jan johansen 
All,

While using GATEWAY IMPORT to a new table from a CSV file, is there an 
option to use first row as table Column Names?

Jan

-- 
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.

[RBASE-L] - Re: LISTOF question 10.0.4.10913

2018-10-27 Thread Michael Byerley 


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+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.