Capitalize only the first letter of each word based on a culture

[EGobi]

Hello,

I have a table in which all columns are in capital letters. For data presentation purposes, I want one of them to have only the first letter of each word capitalized. I could use the built-in function in PowerQuery Editor, which would produce the following step:

Table.TransformColumns(A, {{"B", Text.Proper, type text}})

Where A is the table and B is the column name.

The problem is that I need the capitalization to follow the settings of my culture (pt-BR), so some words should not be capitalized. Text.Proper has a "culture" argument that works for me, but Table.TransformColumns only accepts a "transformOperations" list of functions, which doesn't seem to support function arguments.

So how can I use the Text.Proper "culture" argument inside Table.TransformColumns?

Thanks in advance

[BA_Pete · Accepted solution]

Hi @EGobi ,

Instead of using Table.TransformColumns, you could use a modified Table.ReplaceValue, something like this:

Table.ReplaceValue(
    A,
    each [B],
    each Text.Proper(_, "pt-BR"),
    Replacer.ReplaceValue,  // or Replacer.ReplaceText if this doesn't work
    {"B"}
)

Pete

[EGobi]

Neat, it worked! Thanks!