CODEWITHSUNDEEP
crystal-reportssubstringcrystal-reports-xi
user240141
user240141

Reputation:

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

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.

Upvotes: 5

Views: 55775

Answers (2)

DareDevil
DareDevil

Reputation: 5349

Have an eye to this solution, Its Simple, Splitting "Full Name" into First and Last , keeping, Excluding Last name and returning First Name part. Splitting String

Upvotes: 2

Siva
Siva

Reputation: 9101

Create a formula and add below code.

Split (dbfield,"/")[2]

Upvotes: 10

Related Questions