Conditional Replace Value - Not Working - No Syntax Error

[Anonymous]

Hi, I'm connected to an SQL Database, doing some data cleaning (translations), and I'm not sure why the Replace Value is not responding. Am I missing something? Screenshot below:

Thank you, 
Ovidiu

[Anonymous]

Yes, the Replacer.ReplaceValue did it. Thank you! 

Is ReplaceValue a standard for any format? 

I normally use the Replace Values menu to get the formula set up and then I add the conditions... but it always says Replacer.ReplaceText

[BA_Pete]

@Anonymous ,

I'm not 100% sure on the mechanics behind to be honest but, at first glance, ReplaceText should theoretically have worked as you were only dealing with pure text values (not integer, boolean, special etc.). The only thing I can think it might be is that the cells you were trying to replace started as nulls and therefore not text, but wouldn't stake my house on this.

As a general rule of thumb with replacing values, if one doesn't work, the other will 🙂

Pete

[BA_Pete · Accepted solution]

Hi @Anonymous ,

Try changing the M code in the formula bar from 'Replacer.ReplaceText' to 'Replacer.ReplaceValue'.

If this doesn't work, then you can just add a new custom column using the same logic from your replace code.

Pete