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
5 Replies
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
Pls try
let Source = "Anything", tab= #table(1, {{Source}}), AddCol = Table.AddColumn(tab, "to", each [Column1]&"⁺") in AddCol
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
