Issue On Values when separate it to value and text?

but you use split_string and this is not available on sql server 2012