power query Replace Values - to hyphen or not to hypen?

[ajm]

I was looking for a method to replace all entries in a particular column with a static statement. i found several different posts on different sites about how to do it. The simplest by far is here:

One-step conditional value replacement in a column in Power Query - What the fact.bi

In Power Query you have to replace values in a column based on some conditions. This article shows how you can do that in one single step!

whatthefact.bi

however, i could still not get it to work with my column until i removed a hyphen in the name. My column was titled "Test - Names" and this wasn't recognised until i removed the spaces and hyphen and named it "TestNames". The example in the link above has a space in the column name so it has to be the hyphen.

Am i correct in thinking the hyphen is an issue?

with the hyphen:

= Table.ReplaceValue(#"Changed Type",each [Test - Names],"Performance Review",Replacer.ReplaceText,{"Test - Names"})

Expression.SyntaxError: Invalid identifier.

Without the hyphen, all is golden.
= Table.ReplaceValue(#"Changed Type",each [TestNames],"Performance Review",Replacer.ReplaceText,{"TestNames"})

 

[RoryA]

You'd need to use [#"Test - Names"]

 

[ajm]

Thanks Rory. i have used:

= Table.ReplaceValue(#"Changed Type",each [#"Test - Names"],"Performance Review",Replacer.ReplaceText,{"Test - Names"})

I have two blank entries left that i was wanting to change to the same thing also. Essentially, replace each cell (blank or otherwise) in the column Test-Names with Performance Review. Does this need to be done separately to replacing the names in the column, or can it be included in the line above?

cheers

 

[RoryA]

Just use Replacer.ReplaceValue instead of Replacer.ReplaceText

 

[ajm]

you're a star, Rory.

 

[RoryA]

Glad we could help.