Crystal Reports Text fields (How to cut off stuff)???

Technical Questions

Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions

Topic: Text fields (How to cut off stuff)???

Post Reply

Post New Topic

Author	Message
swatts Groupie Joined: 17 Mar 2010 Online Status: Offline Posts: 83	Topic: Text fields (How to cut off stuff)??? Posted: 24 Jan 2012 at 3:31am
	I have text fields that look like this V51.09 B31.10 314.29 CA1.29 A19.22.E V43.20.A I need to get rid of the .E and .A off of the fields on the last 2. Is there a way to get rid of those?
	IP Logged


rkrowland Senior Member Joined: 20 Dec 2011 Location: England Online Status: Offline Posts: 259	Posted: 24 Jan 2012 at 4:25am
	You could do the following, which would work on the example data you provided. However, if your complete dataset has more complex entries (eg if the format of the values you want varies from "A##.##") then it won't work for everything; left({table.field},6) Regards, Ryan.
	IP Logged

swatts Groupie Joined: 17 Mar 2010 Online Status: Offline Posts: 83	Posted: 24 Jan 2012 at 5:57am
	Thank you! That worked perfect!!!
	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