Forum Discussion

RAHULBANDI's avatar
RAHULBANDI
Icon for Helper II rankHelper II
4 years ago
Solved

Specific Word Split Columns

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 Shar...
Need Help
  • mussaenda's avatar
    mussaenda
    4 years ago

    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

     

     

     

     

mussaenda's avatar
mussaenda
Icon for Community Champion rankCommunity Champion
4 years ago

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