: : anyone know how can I cut off parts of a string ?
: : for example ; I get a string value "hello, the day is red" and I want to just keep "hello".
: Dim Newstring, Oldstring As String
: Oldstring = "hello, the day is red"
: Newstring = left(Oldstring,5)
: This Will Only Work If You Know How Many Characters You Want To Splice. Grouped With This Are The Mid() And Right() Functions.
Watch out: this isn't C. This line:
Dim Newstring, Oldstring As String
actually declares a string (Oldstring) and a Variant (NewString). A better (language-wise, at least) declaration would be:
Dim Newstring as String, Oldstring As String
Back on topic, along with Mid(), Left() and Right(), I'd also add to the list of fundamental string functions Instr(), and InStrRev().