How to remove the value before the special character in SSIS

Question

I have a column like:

001/balabala

002/balbaal

003/balabaal

And my expected output is:

balabala

balbaal

balabaal

That's say, I only want to keep the value after '/'

Answer 1

Hi @BeyondZ,

You may also use below code:

RIGHT("yourcolumn",FINDSTRING(REVERSE("yourcolumn"),"/",1) - 1)

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi @BeyondZ,

SSIS expression language has many useful functions. One of them is TOKEN().

For the reference: https://learn.microsoft.com/en-us/sql/integration-services/expressions/token-ssis-expression?view=sql-server-ver16

Here is an expression that you need for your scenario in the "Derived Column" Task:

TOKEN([ColumnName], "/", 2)

Answer 3

Use a "Derived Column" task with the functions SUBSTRING and FINDSTRING, like

SUBSTRING( [ColumnName] , FINDSTRING([ColumnName], "/", 1) + 1 , 100 )