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

 

 

Thanks,

Related
Recommended