Skip to content

Instantly share code, notes, and snippets.

Created February 11, 2018 15:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save anonymous/50702100352f90e84231611255c7f52b to your computer and use it in GitHub Desktop.
Save anonymous/50702100352f90e84231611255c7f52b to your computer and use it in GitHub Desktop.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8kjMyTm8LTkjNU9JR8lQKVYnWikstejwkryU1KLSvHSgoBFY0D01PTXv8J6k1CKgkLFSbCwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Value = _t, Column2 = _t]),
Replace1 = Table.ReplaceValue(Source,"ä","ae",Replacer.ReplaceText,{"Value"}),
Replace2 = Table.ReplaceValue(Replace1,"ö","oe",Replacer.ReplaceText,{"Value"}),
Replace3 = Table.ReplaceValue(Replace2,"ü","ue",Replacer.ReplaceText,{"Value"})
in
Replace3
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment