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".

: 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.

: : 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().

: 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".


I just have to ask...

Where do you live that has "red days"???


Melissa