Forum Discussion

mike_honey's avatar
mike_honey
Icon for Memorable Member rankMemorable Member
10 years ago

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...
Tips and Tricks
ks1's avatar
ks1
Frequent Visitor
9 years ago

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

mike_honey's avatar
mike_honey
Icon for Memorable Member rankMemorable Member
8 years ago

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", ""})