Forum Discussion
Auto-rename all Query columns e.g. to remove underscore
Today I was grappling with shaping a series of Queries based on a SQL Datawarehouse. They use what's probably the best column naming standard (IMO) e.g. Sales_Amount. However PBI Desktop doesnt see...
Hi What's the right syntax for replacing several text strings?
I tried:
= Table.TransformColumnNames(table, (columnName as text) as text => Text.Replace(columnName, {"_", ""}, {"other text", ""}))
...but that didn't work
ks1 You've probably figured this out monts ago, but you would need to nest Text.Replace, e.g.
Text.Replace(Text.Replace(columnName, {"_", ""}), {"other text", ""})