Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Need help with string manipulation Post Reply Post New Topic
Author Message
RickLap
Newbie
Newbie


Joined: 17 Jan 2007
Location: Afghanistan
Online Status: Offline
Posts: 1
Quote RickLap Replybullet Topic: Need help with string manipulation
    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-


Edited by RickLap - 18 Jan 2007 at 6:41am
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet 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>
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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



Edited by hilfy - 19 Jan 2007 at 1:26pm
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.