Print Page | Close Window

Need help with string manipulation

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=132
Printed Date: 02 May 2024 at 9:57pm


Topic: Need help with string manipulation
Posted By: RickLap
Subject: Need help with string manipulation
Date Posted: 18 Jan 2007 at 6:29am
I'm new to Crystal Reports and need help with the following problem:
 
The name field in a report I am writing has the same person's name spelled a few different ways.
 
Example: "Mouse, Mickey M.D.",  "Mickey Mouse MD", "MOUSE, MICKEY"
 
I'm required to group the report by physician, but I don't want the report to group on each different version of the same name, instead group all procedures for all the above selections under one version: "Mouse, Mickey M.D."
 
I'd be greatly appreciated if someone could help me out with a formula to address this problem.
 
Thanks-


Replies:
Posted By: BrianBischof
Date Posted: 18 Jan 2007 at 12:56pm
Well, I wish I could help you there, but that's a tough one. When I've had problems like that, we hire an intern to come in and manually clean up the data. If anyone has any ideas for how to do this through string manipulation, I would love to hear it as well.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: hilfy
Date Posted: 18 Jan 2007 at 1:12pm

Because there are so many possibilities for how the data was entered, there's no reliable way to catch all of them in a formula.  So, the data will have to be cleaned up. 

Does anyone in your organization have access to the source code for the application?  Is there a way to request modifications to make a lookup table or enforce the format on this field?  That would be the best way to avoid this issue in the future.

-Dell



-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window