let multiReplace= (InputText as text,tOldNew as table)as text=> let //Use List.Generate() to do the replacements DoReplacement = List.Generate( ()=> [Counter=0, MyText=InputText], each [Counter]<Table.RowCount(tOldNew), each [Counter=[Counter]+1, MyText=Text.Replace( [MyText], tOldNew[Old]{Counter}, tOldNew[New]{Counter} ) ], each [MyText]), //Return the last item in the list that //List.Generate() returns GetLastValue = List.Last(DoReplacement) in GetLastValue in multiReplace
Thursday, February 6, 2020
Powerquery multi replace
Function to replace multiple text strings based on a table with "Old" and "New" Columns.
For powerquery / m
Subscribe to:
Posts (Atom)