Replace Text within Same Column

[RAHULBANDI]

Hi 

I have Following Data-set

DATA

Right issue with Debentires

Right Isuue with Equity

Bonus Issue

Stock Split

Buy Back of Shares

DATA   ( EXPECTED OUT-PUT)

Right issue

Right issue

Bonus Issue

Stock Split

Buy Back of Shares

I want expected out put in the same column. {without adding any new columns}

[AlexisOlson · Accepted solution]

It looks like you could use a Text Before Delimiter transformation using " with" as the delimiter.