Forum Discussion

RAHULBANDI's avatar
RAHULBANDI
Helper II
3 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 Debentures

 

Expected OUT-PUT

NAME

Amalgamation

Annual Book Closure

Bonus Issue

Right Issue 

Right Issue 

Right Issue 

 

I'm looking only for right-issue to be converted

 

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 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)

5 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion
    3 years ago

    Select your column > Transform > Extract > Before Delimiter > Advance Options 

    Delimiter put space

    Number of Delimitiers to skip put 1

    • RAHULBANDI's avatar
      RAHULBANDI
      Helper II
      3 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
        3 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)