VB Function - is this possible?
Discussion
Thinking about String Manipulation, is it possible to select all characters before a particular character?
So for the format:
XX.05.0001 - Description blah blah.nnn
Select everything up to the "-" on the left.
.nnn is the filetype.
I know certain things can be done, like selecting the first xNº characters, but this isn't suitable.
TIA.
So for the format:
XX.05.0001 - Description blah blah.nnn
Select everything up to the "-" on the left.
.nnn is the filetype.
I know certain things can be done, like selecting the first xNº characters, but this isn't suitable.
TIA.
Smiler. said:
Thinking about String Manipulation, is it possible to select all characters before a particular character?
So for the format:
XX.05.0001 - Description blah blah.nnn
Select everything up to the "-" on the left.
.nnn is the filetype.
I know certain things can be done, like selecting the first xNº characters, but this isn't suitable.
TIA.
Something like :So for the format:
XX.05.0001 - Description blah blah.nnn
Select everything up to the "-" on the left.
.nnn is the filetype.
I know certain things can be done, like selecting the first xNº characters, but this isn't suitable.
TIA.
Left(String,InStr(,String,"-"))
I cannot remember whether they're 0- or 1-based, but playing with that should get you there.
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff


