78 - Fixing spelling mistakes, Text Replace vs If (Power Query)
Fixing spelling mistakes in a column: When to use Text Replace, and when to use If.
Text Replace will replace a subtext inside the text, e.g. change "car" in "racecar" to "racetruck". This can give problems if you have acronyms or short words that can be found inside larger words e.g. you wanted to change "kansas" to "Kansas", but now "Arkansas" is turned into "ArKansas".
If is far more strict, and checks whether the values are exactly identical e.g. is "kansas" = "kansas"? Yes. Is "Arkansas" = "kansas"? No.
For fixing spelling mistakes, I'd mainly use If.
For general text replacement, I'd use Text.Replace - because that's what it does.
00:21 Unique values
01:04 Creating an old/new table
01:44 List Zip
01:57 List Accumulate with Text.Replace
04:04 The order matters
05:08 Using If
07:05 If vs Text.Replace
Watch video 78 - Fixing spelling mistakes, Text Replace vs If (Power Query) online without registration, duration hours minute second in high quality. This video was added by user WesleySon 07 July 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 136 once and liked it 4 people.