Forum Discussion
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...
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)
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)
thq very much its working