How to parse everything to the left of "_"

[cyberbob2]

Hi all,

I have a string, "1234_testfile.doc". Can someone please show me how to parse out everything to the left of the "_"? This number will grow so this would be the best solution.

Thanks in advance,
KP

 

[trollacious]

Couple different ways to do this. One is to use Left and InStr to get the value, and the other is to Split:

Dim filevalue

filevalue = Left(filename, InStr(filename, "_") + 1)

and

Dim filevalue

filevalue = Split(filename, "_")(0)

Lee

 

[DotNetGnat]

i would go with the Split() as Lee suggested

-DNG

 

[trollacious]

My first suggestion has an error in it. The plus sign (+) should be a minus sign (-).

Lee

 

[cyberbob2]

Thanks all. Much obliged!