Print Page | Close Window

Deleting spaces in a string

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=7651
Printed Date: 27 Apr 2024 at 8:26am


Topic: Deleting spaces in a string
Posted By: Deborah
Subject: Deleting spaces in a string
Date Posted: 10 Sep 2009 at 12:01pm
I need to delete the spaces that are in the middle of as Social Insurance Number
 
ie.   xxx xxx xxx needs to be formatted to xxxxxxxxx
 
Is this possible?
 
 


-------------
Deborah


Replies:
Posted By: FrnhtGLI
Date Posted: 10 Sep 2009 at 1:09pm

put the field in a formula:

 
replace({socialinsurancefield}, " ", "")


Print Page | Close Window