Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: How to remove the space in data with Crystal Repor Post Reply Post New Topic
Author Message
sophieTaureau
Newbie
Newbie


Joined: 26 Jan 2012
Online Status: Offline
Posts: 17
Quote sophieTaureau Replybullet Topic: How to remove the space in data with Crystal Repor
    Posted: 26 Jan 2012 at 3:45am
Hi,
in the data there are the space like " off"
I try to create a formula to remove this space like:
 
if nameP=" off" then "off"
 
but Crystal Report can't find this data with space, so Dead
How can I complete this formula
 
Thanks very much
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 26 Jan 2012 at 3:56am
trim({table.nameP})
IP IP Logged
sophieTaureau
Newbie
Newbie


Joined: 26 Jan 2012
Online Status: Offline
Posts: 17
Quote sophieTaureau Replybullet Posted: 26 Jan 2012 at 4:49am

Bingo, very good idea, super Fonction

Thank very very much DBlank
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.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.