I need to split string and numbers in ssrs report

My input data is like: ABC DE 12 3456

I need to split char and numbers separately

value1 = ABC DE

value2 = 12 3456

even there will be a space also in splitted values


Try this…

i need to use this function inside ssrs report

Try the following expression for…
value1 = System.Text.RegularExpressions.Regex.Replace(Fields!Name.Value, “[0-9]”, “”)
value2 = System.Text.RegularExpressions.Regex.Replace(Fields!Name.Value, “[A-Z]”, “”)

Replace function is not working on ssrs…

Ur AX version.??

AX 2012 r2, VS2010