Extract particular Text from String in Crystal rep
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=22178
Printed Date: 04 May 2024 at 12:09pm
Topic: Extract particular Text from String in Crystal rep
Posted By: Arpit
Subject: Extract particular Text from String in Crystal rep
Date Posted: 14 Dec 2016 at 7:43am
HI
I have a situation where I need to extract text from string which ends with delimiters.
Here is an example
e.g. Text &BIC&
the text is of different length in every row and same is with BIC. I want to extract the Text and eliminate the BIC from the field. Please can anyone suggest a formula for this in Crystal Reports 11
|
Replies:
Posted By: kevlray
Date Posted: 14 Dec 2016 at 11:27am
Look at the replace function. ie, Replace({somefield},"BIC", "") (I may have the syntax wrong).
|
Posted By: hilfy
Date Posted: 15 Dec 2016 at 9:26am
Also, if you need just a part of the string without the delimiters, you can use Split(<string field>, <delimiter>) to split it into an array and then walk through the array to get the pieces that you need.
-Dell
------------- Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|