Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Deleting spaces in a string Post Reply Post New Topic
Author Message
Deborah
Newbie
Newbie


Joined: 10 Sep 2009
Location: Canada
Online Status: Offline
Posts: 1
Quote Deborah Replybullet Topic: Deleting spaces in a string
    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
IP IP Logged
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet Posted: 10 Sep 2009 at 1:09pm

put the field in a formula:

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


Edited by FrnhtGLI - 10 Sep 2009 at 1:10pm
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.