Forum Discussion

Simon_29's avatar
Simon_29
Icon for Helper II rankHelper II
4 years ago
Solved

Change the value in a column based on a value in another column

Hello, in one community I found a command to change the value in one column based on another column, but it doesn't work properly. Could you advise me? The problem is as follows: I have an ORD...
Need Help
Show and Tell
Tips and Tricks
BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

Hi Simon_29 ,

 

Change 'Replacer.ReplaceText' in your formula bar to 'Replacer.ReplaceValue'.

 

Pete

jennratten's avatar
jennratten
Icon for Super User rankSuper User
4 years ago

FYI, the reason BA_Pete's solution works is because Replacer.ReplaceText looks for substrings and Replacer.ReplaceValue looks at the entire contents of a cell.