Forum Discussion
Replace value with new value containing a superscript
Hello, In Power Query how can I replace a value with a new value containing a superscript. I need to replace oldName with newName+ where the + is a superscript. Thanks,
Before:
After
With the formula:
= Table.ReplaceValue(#"Changed Type","+", Character.FromNumber(0x207A),Replacer.ReplaceText,{"Value"})Did I answer your question? Then please mark my post as the solution and make it easier to find for others having a similar problem.
If I helped you, please click on the Thumbs Up to give Kudos.Kees Stolker
A big fan of Power Query and Excel
HI Anonymous, what about this?
enter TextToReplace
Output
let
Source = #table(type table[Value=text], {{"Anything"}, {"Something else"}, {"Another text abc"}}),
TextToReplace = {"Anything", "text"},
R = [ a = List.Transform(TextToReplace, Text.Trim),
b = Record.FromList(List.Transform(a, each _ & "⁺"), a)
][b],
StepBack = Source,
Ad_Replaced = Table.AddColumn(StepBack, "Replaced", each Text.Combine(List.Transform(Text.Split([Value], " "), (x)=> Record.FieldOrDefault(R, x, x)), " "), type text)
in
Ad_Replaced