But what is the pattern. All of the text after any dash? All text if no dash exists? All text after a dash assuming that the text before the dash has no vowels?
On 9/11/07, Rebecca Wells <[EMAIL PROTECTED]> wrote: > > >Does crystal reports support RegEx and to what degree? Also, is that the > >standard format so it'll always be capital letters followed by a dash > >followed by one or more words that need to be first letter capped? Are > there > >always 1-2 words after the dash or can there be more? > >This can be done using a single line of code based on some more > specifics. > > > >http://www.houseoffusion.com/tutorials/regular-expressions/ > > I just ran a query to see all the records, and unfortunately they don't > all follow the same pattern. Here is the data I'm dealing with: > > CITY COUNCIL > CC-LEGISLATIVE > HUMAN RESOURCES/RISK MGMT/CIVIL SVC > HR-HUMAN RES/RISK MGMT/CIVIL SVC > ADMINSTRATIVE JUDICIAL LEGAL SERVICES > AJLS-ADMIN/JUDICIAL/LEGAL > AJLS-MUNICIPAL COURT > AJLS-CITY CLERK > AJLS-HEARING EXAMINER > FINANCE AND INFORMATION SERVICES > FIS-ACCOUNTING & FINANCIAL PLAN > FIS-INFORMATION SERVICES > PUBLIC BUILDINGS AND PUBLIC WORKS > PBPW-ADMINISTRATION > PBPW-DEVELOP/CONSTRUCTION SVC > PBPW-TRANSPORTATION > PBPW-TRANS SYS MAINT > PBPW-STREET MAINT SVC > PBPW-UTILITY SYS > PBPW-UTILITY MAINT > PBPW-AIRPORT > PBPW-EQUIPMENT RENTAL > ECONOMIC DEVEL & NEIGHBORHOOD SPECIAL PLN > EDNSP-ECONOMIC DEVELOPMENT ADM > POLICE DEPARTMENT > POLICE-CHIEF > POLICE-ADM SVC & TRAINING > FIRE DEPARTMENT > FIRE-ADMINISTRATION > FIRE-SUPPRESSION/TRN/PREV > COMMUNITY SERVICES > CS-PARKS ADM > CS-HUMAN SVC > CS-PARKS FACILTIES MAINT > CS-PARKS GENERAL SVC > CS-RECREATION SVC > CS-SENIOR CENTER > CS-RCC > CS-PARKS MAPLEWOOD GOLF > CS-MUSEUM > CS-LIBRARY SERVICES > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/RegEx/message.cfm/messageid:1064 Subscription: http://www.houseoffusion.com/groups/RegEx/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.21
