>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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/RegEx/message.cfm/messageid:1063 Subscription: http://www.houseoffusion.com/groups/RegEx/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.21
