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
    4 years ago

    Hi Simon_29 ,

     

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

     

    Pete

  • jennratten's avatar
    jennratten
    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.

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.

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

    I appreciate your advice. Everything is already working. Thank you very much