Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: How To: Extract Certain Data From A String Post Reply Post New Topic
Author Message
charmaine_121
Newbie
Newbie


Joined: 25 Feb 2010
Location: Malaysia
Online Status: Offline
Posts: 1
Quote charmaine_121 Replybullet Topic: How To: Extract Certain Data From A String
    Posted: 25 Feb 2010 at 6:20am
I need help on how to create a formula to extract a certain data/string from a string.

Part Number
01,ABC123,PM012345,PONA,procars123,PMpp121
02,ABC111,DEF123,PM987654,PMXXX789,qt59,IN700,PM456
PM888999,XYZ007,ABCXYZ,PM12345678
...
...


How do I extract strings that begins with 'PM' so that the report will look like:

Part Number
PM012345,
PMpp121
PM987654,PMXXX789,PM456
PM888999,PM12345678
...
...


Pls help Cry

Thanks!
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.017 seconds.