Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: How to get rid of a \ in address field? Post Reply Post New Topic
Author Message
Tovio
Newbie
Newbie


Joined: 08 Jan 2009
Online Status: Offline
Posts: 3
Quote Tovio Replybullet Topic: How to get rid of a \ in address field?
    Posted: 08 Jan 2009 at 9:40am
The view is
vp_personv42.homestreet
 
The data is
12345 any street\
 
How can i get rid of \ on printed report?
 
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 20 Jan 2009 at 2:36pm
Create a formula that looks something like this:
Replace({vp_personv42.homestreet}, '\', '')
This will get rid of all instances of the '\' character in the string.  If '\' is a legitimate character somewhere else in the string, you can get rid of the last character in the string this way:
If Right({vp_person42.homestreet}, 1) = '\' then
  Left({vp_person42.homestreet}, length({vp_person42.homestreet}) - 1)
else
  ({vp_person42.homestreet}
 
-Dell
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.