Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Conditionally Replace Values

Hi all,   I have two columns consisting of article numbers and a column that indicates if the article is sold online or not. Articles sold online do not have an article number. So I want to replace...
Need Help
Show and Tell
Tips and Tricks
BA_Pete's avatar
BA_Pete
Super User
5 years ago

Hi Anonymous ,

 

Difficult to say without being able to see the data that you are applying this to, but the first thing I would try is to change

'Replacer.ReplaceText,{"ArticleNumber"})' at the end of your replace step to

'Replacer.ReplaceValue,{"ArticleNumber"})'.

 

Also, FYI, you don't need "=true" after the Text.Contains() function, it evaluates to boolean.

 

Pete

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    hi BA_Pete 

     

    Thanks for the hint regarding "true" ou are right that was probably there from some test I made. 

    I should have added that the ArticleNumber columne is a text columne. Was this what your tip is based on? But I will try regardless.

    -dats