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

Question

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.

score 10 · Answer 1 · answered Aug 26 '13 at 06:55

10

Create a formula and add below code.

Split (dbfield,"/")[2]

answered Aug 26 '13 at 06:55

Siva

9,043
12
40
63

score 2 · Answer 2 · edited May 23 '17 at 11:52

2

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

edited May 23 '17 at 11:52

Community

1
1

answered May 12 '14 at 04:59

DareDevil

5,249
6
50
88

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

2 Answers2