Specific Word Split Columns

[RAHULBANDI]

Hi 

I have following Data-set

DATA

Right Issue of Fully Convertible Debentures

Right Issue of Fully Convertible Debentures

Right Issue of Equity Shares

Right Issue of Equity Shares

Expected-Output

DATA	DATA1.1
Right Issue of Fully Convertible Debentures	Right Issue
Right Issue of Fully Convertible Debentures	Right Issue
Right Issue of Equity Shares	Right Issue
Right Issue of Equity Shares	Right Issue

[Lakshmi1294]

Hi,

 If you want to split left most side Values

  First Duplicate the Column then split the column two times by Left most Delimiter 

  Now you can merge the two splitted Colums.You can get it now 

[mussaenda · Accepted solution]

Hi @RAHULBANDI ,

All values on your data column has the same start?

There are multiple ways to achieve your DATA1.1

you can do like 

if Text.Contains(Text.Upper([DATA]), "RIGHT ISSUE")
then "Right Issue"
else 

null