Delimited Column Replacer Text Transposer Text Columns to Rows Converter Text Rows to Columns Converter Text Column Swapper Text Column Delimiter Changer HTML to Markdown Converter Markdown to HTML Converter HTML to Jade Converter Jade to HTML Converter ...
Shows how to use an AutoOpen macro to update the TOC whenever any document that contains a TOC is opened. Permalink Comments Introducing a new class for PowerTools for Open XML: TextReplacer August 4, 2011 at 5:16 pm · Filed under Functional Programming, LINQ to XML, Open XML, PowerToo...
(Textwithspace, "Textwithoutspace", each [Text])," ","",Replacer.ReplaceText,{"Textwithoutspace"}), Lengthoftextwithoutspace = Table.TransformColumns(Textwithoutspace,{{"Textwithoutspace", Text.Length, Int64.Type}}), #"Added Custom" = Table.AddColumn(Lengthoftextwithouts...