<div>
is it always same format between 2nd and 3rd occurances of &quot;_&quot;? 
if so try 
SUBSTRING(@[User::FileName], FINDSTRING(@[User::FileName], &quot;_&quot;, 1) + 1, FINDSTRING(@[User::FileName],&quot;_&quot;,3) - FINDSTRING(@[User::FileName],&quot;_&quot;,1)-7) 

</div>

is it always same format between 2nd and 3rd occurances of "_"?
if so try
SUBSTRING(@[User::FileName], FINDSTRING(@[User::FileName], "_", 1) + 1, FINDSTRING(@[User::FileName],"_",3) - FINDSTRING(@[User::FileName],"_",1)-7)


<div>
No thats not the same it changes. Here are the examples 
 
ProductCatalog_141199_20100527164603.CSV_201069_20144_2010625_191748_2010714_142617 
 
ProductCatalog_132700_20100706024658.CSV_2010710_185129 
 
ProductCatalog_182404_03072008_201077_201082_05439 
 
Output Required example: 
 
141199_20100527 
132700_20100706 
182404_03072008 
 

</div>

No thats not the same it changes. Here are the examples

ProductCatalog_141199_20100527164603.CSV_201069_20144_2010625_191748_2010714_142617

ProductCatalog_132700_20100706024658.CSV_2010710_185129

ProductCatalog_182404_03072008_201077_201082_05439

Output Required example:

141199_20100527
132700_20100706
182404_03072008



<div>
<div class="content wysiwyg-content">
Hi Guys, 
 
&nbsp; 
 
Input: ProductCatalog_181416_20100513010253_2010517_22715_2010715_172740 
 
Expression Used: SUBSTRING(@[User::FileName], FINDSTRING(@[User::FileName], &quot;_&quot;, 1) + 1, FINDSTRING(@[User::FileName],&quot;_&quot;,3) - FINDSTRING(@[User::FileName],&quot;_&quot;,1)-1) 
 
Output Getting: 181416_20100513010253 
 
&nbsp; 
 
Out Put Required : 181416_20100513 
 
&nbsp; 
 
Can please help he out how to get above output. 
 
&nbsp; 
 
Thanks,
</div>
</div>

Hi Guys,

 

Input: ProductCatalog_181416_20100513010253_2010517_22715_2010715_172740

Expression Used: SUBSTRING(@[User::FileName], FINDSTRING(@[User::FileName], "_", 1) + 1, FINDSTRING(@[User::FileName],"_",3) - FINDSTRING(@[User::FileName],"_",1)-1)

Output Getting: 181416_20100513010253

 

Out Put Required : 181416_20100513

 

Can please help he out how to get above output.

 

Thanks,

SSIS Expression

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

A regular expression ("regex") is a sequence of characters that define a search pattern, mainly for use in pattern matching with strings, or string matching, i.e. "find and replace"-like operations. Regular expression processors are found in several search engines, search and replace dialogs of several word processors and text editors, and in the command lines of text processing utilities, such as sed and AWK. Many programming languages provide regular expression capabilities, some built-in, for example Perl, JavaScript, Ruby, AWK, and Tcl, and others via a standard library, for example .NET languages, Java, Python and C++ (since C++11). Most other languages offer regular expressions via a library.