Findstring issue SSIS

Question

I have a string like (first)0001ABC_Leo, i want to extra the value with 0001ABC. I tried with findstring but it doesn't work. Please help！Thank u in advance.

Answer 1

Hi @SLi，

If you only want to extra the one value, you may easily use substring to do that.

SUBSTRING("(first)0001ABC_Leo",8,7)

If not, please provide more details about your column value or regular of your column.

Regards，

Zoe Hui

---

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

Answer 2

Hi @SLi, It is much better to use tokenization for such scenarios.

• (first)0001ABC_Leo => 0001ABC
• (second)0002ABC_Yoga => 0002ABC

Check it out the following SSIS expression leveraging TOKEN() function:

TOKEN(REPLACE(@[User::inputString],")","_"), "_", 2)