Specific Word Split Columns

Question

Hi&nbsp;I have following Data-set&nbsp;DATARight Issue of Fully Convertible Debentures&nbsp;Right Issue of Fully Convertible Debentures&nbsp;Right Issue of Equity Shares&nbsp;Right Issue of Equity Shares&nbsp;&nbsp;Expected-Output&nbsp;DATADATA1.1Right Issue of Fully Convertible Debentures&nbsp;Right IssueRight Issue of Fully Convertible Debentures&nbsp;Right IssueRight Issue of Equity Shares&nbsp;Right IssueRight Issue of Equity Shares&nbsp;Right Issue

mussaenda · Accepted Answer

Hi&nbsp;RAHULBANDI&nbsp;,
&nbsp;
All values on your data column has the same start?
&nbsp;
There are multiple ways to achieve your DATA1.1
&nbsp;
you can do like&nbsp;
if Text.Contains(Text.Upper([DATA]), "RIGHT ISSUE")
then "Right Issue"
else

null
&nbsp;
&nbsp;
&nbsp;
&nbsp;

Forum Discussion

Specific Word Split Columns

2 Replies

Related content

Splitting Column values

Split a column into two separate columns

Split Columns

Column Splitting

Split and rearrange columns

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