You create the following step by using Power Query Editor.
= Table.ReplaceValue(SalesLT_Address,"1318","1319",Replacer.ReplaceText,{"AddressLine1"})
A row has a value of 21318 Lasalle Street in the AddressLine1 column. What will the value be when the step is applied?
Example:
Replace the text 'ur' with the text 'or' in the table.
https://docs.microsoft.com/en-us/powerquery-m/table-replacevalue
Currently there are no comments in this discussion, be the first to comment!