on Geeks with Blogs
See other posts from Geeks with Blogs
or by Compudicted
Published on Mon, 31 Jan 2011 17:14:23 GMT Indexed on 2011/01/31 23:26 UTC
Read the original article Hit count: 99
It will be a super short and looks like the first and last post in January 2011.
So back to the topic, I decided to share an SSIS expression I crafted to extract the value concealed between two characters (I needed to get a portion of text in a file path):
Substring(@[User::MyString],FINDSTRING(@[User::MyString],"(",1)+1,FINDSTRING(@[User::MyString],")",1) - FINDSTRING(@[User::MyString],"(",1)-1)
The value of MyString say could be c:\test\test(testing123456789).txt, then the resulting text captured testing123456789.
Hopefully it will be needed to somebody.
© Geeks with Blogs or respective owner