[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Crystal Reports How to find/replace character in a string

Posted on 2011-10-05
2
Medium Priority
?
1,363 Views
Last Modified: 2012-05-12
I have a string field which I need to "clean up."  I  need to be able to find and delete a specific character in string
How do I do this?

Thanks
0
Comment
Question by:mbroad02
2 Comments
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 36921606
Is this just for display in the report?

Crystal has a REPLACE function

Replace ({YourStringToCorrect","BadCharacters","GoodCharacters")

If you need to save the string for later use you can use it as

WhilePrintingRecords;
Global StringVar strCorrected;
strCorrected := Replace ({YourStringToCorrect","BadCharacters","GoodCharacters");

If you are trying to correct it in the database then Crystal is not the tool to use.

mlmcc

0
 

Author Comment

by:mbroad02
ID: 36923635
Sorry I did not specify.  YES, it is only a display field in the report.  I will try your suggestions and let you know.

Thanks
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question