April 13, 2015 at 8:37 am
Would anyone able to help with the below SSIS Expression?
I need to extract the excel file name out of the filepath - see below example;
'c-Drive\Files\Data\Claims\Current Load\31 Dec 2012.xls' ==> need output to read '31 Dec 2012'
Could someone help point me in the right direction.
Thanks in advance for any help.
April 13, 2015 at 8:47 am
This works, as long as the folder hierarchy depth is always the same. If not, you'll have to get more complex & use TOKENCOUNT too.
token(token("c-Drive\\Files\\Data\\Claims\\Current Load\\31 Dec 2012.xls","\\",6),".",1)
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply