Solved

Remove comma from string field in a Crystal Report

Posted on 2003-12-04
2
2,388 Views
Last Modified: 2007-12-19
I have a string in a report that sometimes has commas in it, how can i remove these in a formula?

Like:   John Smith, Jr.
Needs to be:  John Smith Jr.
0
Comment
Question by:cybrthug
2 Comments
 
LVL 42

Accepted Solution

by:
frodoman earned 125 total points
ID: 9876645
Replace({FieldName},",","XXX")

XXX above represents whatever you want to replace the commas - you can simply use an empty string "" to remove them completely.
0
 

Author Comment

by:cybrthug
ID: 9876683
Awesome work frodoman,  I did take out the XXX and it worked great.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

910 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now