• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 766
  • Last Modified:

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

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
jsnpttsbrgh
Asked:
jsnpttsbrgh
1 Solution
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now