substring in a global variable
Posted on 2006-05-30
i'm looping through a whole bunch of files in a dts pacakge. i'm attempting to loop through them and load them into a table. one of the columns is actually based on the filename. can i substring the global variable in the activeX such that it is ONLY everything to the left of the first underscore in the filename, instead of the whole filename?
my gv is gv_FileFullName, which for whatever reason is equating to this right now: \\servername\shared\aaaa\Compositions\VFH_ETF_Co
I need to substring the gv such that filename becomes this: VFH_basketid
but, i don't want that servername\directory stuff. i just want the filename.
and, If i could just pull the 'VFH', couldn't i prepend everything to '_basketid' ?
how would I do that?