Data Cleaning With SSIS

Question

Hi Experts,

Please help me to resolve this issue. First Set is raw data I want to clean the record and store into the TGT table as give below

User has changed the requirement they want to Just ignore the html phrase inside <Just want to Know> bracket. rest everything they want

Sample

PQWS,<Get>was it,<Mas>

Expected

PQWS, was it

I want the result in ssis and t-sql. Sorry again. Please help

Answer 1

Hi @San ,

Please try the following expressison:

(FINDSTRING(column, "<" , 1) == 0) ? column : LEFT(column, FINDSTRING(column, "<" , 1) - 2)  

Both functions FINDSTRING() and LEFT() work only with the DT_WSTR data type. So you need to cast the column if it has a different data type.

(FINDSTRING((DT_WSTR,256)column, "<" , 1) == 0) ? column : LEFT((DT_WSTR,256)column, FINDSTRING((DT_WSTR,256)column, "<" , 1) - 2)  

I assumed that the 256 length is enough. It could be easily adjusted to accomodate the real length.

Answer 2

Hi @San ,

I think YitzhakKhabinsky-0887 has given the correct answer to resolve your issue.

Don't forget to mark it as answer so other user with similar problem could see this easier. :)

Regards，

Zoe

---

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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October