How to remove string from variable value?

• elchuru

  Default port

  Points: 1435

  More actions

  May 3, 2010 at 5:58 am

  #142802

  Hi,

  I created a variable with name 'source_file' with string data type and default value is 'C:\test'. In my expression i want only 'test'.How to extract only "test" into my expression.

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  May 3, 2010 at 6:30 am

  #1161211

  Hi

  My solution is based on the assumption that you have only a single "\" in your string. i.e. the variable will not contain a value like 'C\test\test". Note the two "\" values (slash) in the string.

  declare @e varchar(10)

  set @e = 'C:\test'

  select substring(@e,charindex('\',@e)+1,len(@e))

  Edit: - I hope you are not looking for SSIS expressions.

  "Keep Trying"

• divyanth

  SSCarpal Tunnel

  Points: 4303

  More actions

  May 3, 2010 at 7:18 am

  #1161248

  elchuru (5/3/2010)

  ---

  Hi,

  I created a variable with name 'source_file' with string data type and default value is 'C:\test'. In my expression i want only 'test'.How to extract only "test" into my expression.

  Check this expression:

  Replace the Variable - VariableName with your variable name in the expression

  SUBSTRING(VariableName,FINDSTRING(VariableName,"\\",1)+1,(LEN(VariableName) - FINDSTRING(VariableName,"\\",1)))

• elchuru

  Default port

  Points: 1435

  More actions

  May 3, 2010 at 7:22 am

  #1161251

  ChiragNS (5/3/2010)

  ---

  Hi

  My solution is based on the assumption that you have only a single "\" in your string. i.e. the variable will not contain a value like 'C\test\test". Note the two "\" values (slash) in the string.

  declare @e varchar(10)

  set @e = 'C:\test'

  select substring(@e,charindex('\',@e)+1,len(@e))

  Edit: - I hope you are not looking for SSIS expressions.

  Its SSIS expression