Replaces all occurrences of a substring in a text string in Power Query.
Challenge No. 115:
Replace “q” and “000” in the Product ID and Customer ID columns with “-“.
Solved using:Excel (HSTACK, LAMBDA, LET), Google Sheets, Power Query (Text.Replace, Table.ReplaceValue, Table.TransformColumns), Python, Python in Excel, R, SQL, and VBA.
Challenge No. 9: (Excel formulas also welcome)
There is a table which has Original Text and there is another table which contains the list of words which need to be replaced.
Solved using: Power Query (List.Transform, Table.AddColumn, Table.ReplaceValue).
Challenge No. 47: The “Question” table presents a list of product IDs collected from several warehouses.
Solved using:Excel (INDEX, LAMBDA, LET), Power Query (Text.Replace), Python, Python in Excel, and R.
