Solved

Is there any way to remove Comma's from fields in crystal reports?

Posted on 2009-04-07
1
752 Views
Last Modified: 2013-11-15
The database I use combines Last name and first name together and separates it by a comma. Is there a way when pulling the data into a report using Crystal XI to remove this comma without having to manually edit the file. The reason i'm asking is because once I create this report I have to export it to a .csv file. Any rogue comma's or comma's in the name field really mess with importing them into another database.
0
Comment
Question by:jsnpttsbrgh
1 Comment
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 500 total points
ID: 24089481
Create a formula with the following syntax:

Replace({table.field},",","")

This searches the field for commas and replaces them with an empty value.

~Kurt
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

758 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

24 Experts available now in Live!

Get 1:1 Help Now