Tuesday, May 27, 2014

Sort String Regex.Replace

Hi,


When applying the below sort string against Sort Matter field, the report sorting is jumping from 20141 - 201410. Can anyone advise why this may be occuring?


NB: I am accessing the data from SSAS.


=System.Text.RegularExpressions.Regex.Replace(Fields!MATTER_NO.Value, "[^0-9]", "").Trim(";")


Thanks,



Matt


No comments:

Post a Comment