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