Crystal Report : formula for Splitting string on / and concatenating it with other string

crystal-reports substring crystal-reports-xi
user240141 picture user240141 · Aug 26, 2013 · Viewed 43.2k times · Source

I have string coming in this format WORVS/000017/0005.

I want to split the string on /. I want only 000017 from this string and further I had another column to which it has to be concatenated.

I need a formula for same.

Answer

Siva picture Siva · Aug 26, 2013

Create a formula and add below code.

Split (dbfield,"/")[2]

Related questions

SAP Crystal Reports runtime for .Net 4.0 (64-bit)

I need a runtime for SAP Crystal Reports for .Net 4.0 (64-bit). I have been searching from the web but not getting any success. Can I get the URL from where can i download this

Read More
How to convert datetime format to date format in crystal report using C#?

i am working c# windows form application and also in crystal report.i am retriving the date from database in datetime format but i like display date only in report,Is any formula field in crystal report help for me …

Read More
Edit Crystal report file without Crystal Report software

I need to modify a static text (few words) in 3 rpt files. But I dont have Crystal Reports. How can I do it? Is there a free editor or software to be able to modify a simple text of the …

Read More