Focal Point
[CLOSED] Multi-Select List Using Values That Have Commas In Them

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7827037526

November 02, 2012, 10:08 AM
kennethb
[CLOSED] Multi-Select List Using Values That Have Commas In Them
I'm trying to create a multi select list using values like the following:

Asheville
Atlanta, GA
Wilkesboro
Chicago, IL

The problem is that some of the values have commas in them, e.g.

 WHERE (CHAPTER EQ &CHAPTER.(OR(<Asheville,Asheville><Atlanta, GA, Atlanta, GA>)).Select Chapters:. ); 


doesn't work because the values are separated by commas. Is there any way to escape the commas in the value strings? Another way to work around having commas in the value names?

Thanks!

This message has been edited. Last edited by: Kerry,


WebFOCUS 8.1.03, Windows 10/64, Oracle 11g & RDB, Output: HTML, PDF, Excel 2010
November 05, 2012, 08:56 AM
Kevin Patterson
Kenneth, did the "\" (backslash) character work?


Kevin Patterson
Appalachian State University
WebFOCUS 7.7.03
Windows, All Outputs
November 05, 2012, 03:57 PM
Tony A
Kenneth,

As your sample values are alpha then try this approach -

-SET &DUMMY = &CHAPTER.OR(<'Asheville','Asheville'>,<'Atlanta, GA','Atlanta, GA'>).Select Chapters:. ;
-SET &ECHO = ALL;
DEFINE FILE CAR
  COUNTRYA20/A20 = COUNTRY;
END
TABLE FILE CAR
  SUM RCOST DCOST
   BY COUNTRY
   BY CAR
   BY MODEL
WHERE COUNTRYA20 EQ &CHAPTER
END

T



In FOCUS
since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10