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<javascript:> [mailto:rba...@googlegroups.com<javascript:>] 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<javascript:>. 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.