Print Page | Close Window

How to get substrng from string in crystal report

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=14206
Printed Date: 06 May 2024 at 3:23pm


Topic: How to get substrng from string in crystal report
Posted By: aarti
Subject: How to get substrng from string in crystal report
Date Posted: 25 Aug 2011 at 11:56pm
Hi,

i want to get the sting
54321
12345
67891

from string A649:54321;A022:12345;A047:67891

How could i get it. Please help



Replies:
Posted By: FrnhtGLI
Date Posted: 26 Aug 2011 at 2:20am
right(split({table.field}, ";")[1], 5)
& chr(13)
&
right(split({table.field}, ";")[2], 5)
& chr(13)
&
right(split({table.field}, ";")[3], 5)


-------------
|< /\ '][' ( )



Print Page | Close Window