how to extract value from text string? In SQL, data is stored in one string, when we copy it to notepad++, we get rows separated by CRLF. I want to get the value from line 103
enter image description here
enter image description here
at the end, I need this value to be in the “Value” cell before the SQL UPDATE command, but for it to be 997.51
declare @rich_text_to_modify as nvarchar(2000) = ‘
.
.
.
0
0
0’;
SELECT Value FROM STRING_SPLIT(@rich_text_to_modify,CHAR(13));
enter image description here
Adrian Chochorowski is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.