Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Deleting extra spaces Post Reply Post New Topic
Author Message
vzirock
Newbie
Newbie


Joined: 28 Sep 2010
Location: United States
Online Status: Offline
Posts: 6
Quote vzirock Replybullet Topic: Deleting extra spaces
     Posted: 07 Oct 2010 at 5:58am
Is there a way to tell a combined field not to print spaces?  I have a field called location that pulls data from street number, street direction, street name and street type (from outside source).  When I bring the location field into my report and combine it with the intersection field I get a return that looks like this...
 
123       W        Main                       Street / 234          E           Main         Street
 
Any ideas?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 07 Oct 2010 at 6:32am
one way would be to trim all the fields
trim(field1) + ' ' + trim(field2) + ' ' + ...


Edited by DBlank - 07 Oct 2010 at 6:32am
IP IP Logged
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