Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Report Design  
Message Icon Topic: Pull a single word from a string through formula? Post Reply Post New Topic
Author Message
Doolhoff
Newbie
Newbie
Avatar

Joined: 14 Nov 2016
Online Status: Offline
Posts: 20
Quote Doolhoff Replybullet Topic: Pull a single word from a string through formula?
    Posted: 16 Jan 2018 at 9:38am
I am attempting to create a new report, but I am having some great difficulty trying to get it to do what I need it to.

I am trying to get a single word to pull from a string. The I have tried to use the "like" function to no avail. I am trying to get the word "white" to pull from the string "5.75in Pinfed Rem White". I cannot figure this out. I have searched several forums and the help function in Crystal itself, again to no avail.

Please help.

Edited by Doolhoff - 16 Jan 2018 at 11:39am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 8794
Quote DBlank Replybullet Posted: 17 Jan 2018 at 2:32am
When you say 'pull' do you mean you want display the existing string without that word in it?
try using REPLACE()
IP IP Logged
Doolhoff
Newbie
Newbie
Avatar

Joined: 14 Nov 2016
Online Status: Offline
Posts: 20
Quote Doolhoff Replybullet Posted: 17 Jan 2018 at 9:56am
When I say pull I am wanting to display the string with only that word. Sorry for the confusion. I should have used a different way to ask that.
IP IP Logged
Doolhoff
Newbie
Newbie
Avatar

Joined: 14 Nov 2016
Online Status: Offline
Posts: 20
Quote Doolhoff Replybullet Posted: Yesterday at 8:25am
If what I am trying to do isn't possible, please let me know so I can make a new plan for my report.
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.047 seconds.