SSRS substring

Finance and Operations/AX Developer Forum
1

i have a data value as 0123-456789

in SSRS report in need to split this data in to two parts

Code : 0123

Value : 456789

like this

i need ssrs expression for this output

Thanks in advance

2

You can use split function. insightextractor.com/…/

3

You may use the following existing functions in SSRS Left(), Right(), Mid(), InStr().
For example in your Code field; =Left(Fields!MyField.Value, InStr(Fields!MyField.Value, “-”)-1)