Solved

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

Posted on 2009-04-07
1
759 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

689 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