String Split in SSRS Report

Question

I have string "02Years02Months". In the SSRS Report i need to show the string like

"02 Years 02 Months". Is there any good method in SSRS report Expression.

Please advice, Thanks

Answer 1

=Left(Fields!String.Value, 2) & " " & Mid(Fields!String.Value, 3, 7) & " " & Right(Fields!String.Value, 6)

That's assuming your numbers will always be padding with zeroes as in the example above, and given you replace the Fields!String.Value with the field containing the string being returned in your report.

Answer 2

I found the solution, Here is the answer

=Left(Fields!Value, 2) & " " & Mid(Fields!Value, 3, 5) & " " & Mid(Fields!Value, 8, 2) & " " & Right(Fields!Value,  6)

Thanks for the support