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