Hi, I've got a table with a column which is frequently used to store paragraphs, some with new lines in between. for example
a aaaaa aa aaaaaaa.
bbb bb.
cc ccccccccccccc.
I'd like to filter these results in vb, so that the new lines (or whatever it is seperating the lines) is removed, making it so that i can instead have a cell, or a representation of a cell on a page as one long string, spaces and full stops still included.
e.g
a aaaaa aa aaaaaaa.bbb bb. cc ccccccccccccc.
does anyone have an idea of how to do this, without changing the actual database formatting.
i use a piece of code to remove commas -
Dim strcomments() As String
Dim comments As String = ""
strcomments = array(29, n).ToString.Split(",")
comments = String.Join("", strcomments)
would it be possible to do this with this code, only instead of removing a ' , ' remove the new lines generated by someone copying and pasting paragraphs into a cell.
vb.net