Forum Discussion

RAHULBANDI's avatar
RAHULBANDI
Helper II
4 years ago
Solved

Replace Existing Text

Hi  I have Following Data   NAME Amalgamation Annual Book Closure Bonus Issue Right Issue of Equity Shares Right Issue of Equity Shares with Warrants Right Issue of Fully Convertible Debentu...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    4 years ago

    What if you try this?

     

    = Table.AddColumn(Origen, "Custom", each let splitNAME = Splitter.SplitTextByDelimiter("Right Issue", QuoteStyle.None)([NAME]) in Text.Combine({Text.Start([NAME], 11), Text.Middle(splitNAME{0}?, 11)}), type text)

RAHULBANDI's avatar
RAHULBANDI
Helper II
4 years ago

Hi 

I have other rows in that data which are also getting splitted

 

NAME

Amalgamation                                                          Amalgamation   

Annual Book Closure                                                Annual Book 

Bonus Issue                                                                 Bonus Issue

Right Issue of Equity Shares                                        Right Issue

Right Issue of Equity Shares with Warrants                Right Issue

Right Issue of Fully Convertible Debentures               Right Issue

Exchange of Share Certificate                                     Excahnge of

 

Im looking replace only text which starts with Right Issue

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

What if you try this?

 

= Table.AddColumn(Origen, "Custom", each let splitNAME = Splitter.SplitTextByDelimiter("Right Issue", QuoteStyle.None)([NAME]) in Text.Combine({Text.Start([NAME], 11), Text.Middle(splitNAME{0}?, 11)}), type text)

  • RAHULBANDI's avatar
    RAHULBANDI
    Helper II
    4 years ago

    thq very much its working