[RESOLVED] Trimming characters from a string

If I input the string 2006-03894 from a file, how can I trim the string so that the result is 2006?

Thank you,

Ed

Left$() will work:

VB Code:

Debug.Print Left$("2006-03894", Instr(1, "2006-03894", "-") - 1)

so will split

DIm tmp() as string
tmp = Split("2006-03894", "-")
Msgbox tmp(0)

Quote:

---

Originally Posted by RhinoBull

Left$() will work:

---

Bah! When will the symbols die?

In VB6 never! :rolleyes:
In case you never knew - there are two Left funtions: one return variant (Left) and one return string (Left$). Same for Mid/Mid$ and some others. ;)