Solved

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

Posted on 2009-04-07
1
756 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
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…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

770 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