All Questions
Tagged with string-splitting sql-server-2012
3 questions
0
votes
3
answers
2k
views
Sum of decimal values that come in a string
Is there an easy way to get the sum of all decimal values in a string column.
Example:
"ABC $3.25, DEF $2.50, HIJ2 $0.25"
"ABC1 $3.25, DEF $2.50, HIJ $0.25, KLM $4.50"
I want to add only the values ...
- 1
1
vote
2
answers
4k
views
Split two delimited strings in same order without function
I am trying to split two columns with delimited strings into rows. The positions of the values in each string are related so I am trying to split it out so that the related values are in a row. I am ...
- 3,312
1
vote
2
answers
2k
views
Split String Function
I have a question regarding this Split String function Aaron Bertrand recommends here.
With it you can extract information between two slashes. Now if I want to extract not only one piece of info ...
- 13