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