Replace data in string field

[SCK]

Hi all, not sure if a similar question has been posted, but I really need help. I need to replace a certain data in a field with blank, but I am able to do so using regex_replace option if I put in 2 conditions. Please help.

[JosephSerpis · Accepted solution]

Hi @SCK can you not filter out the data with blanks as based on your input rows that have cadbury or cheetah have no data for the colour column, then in your output they are removed? I mocked up a workflow that takes your input data and produces the output. Let me know if that is correct?

[SCK · Accepted solution]

Thanks  @JosephSerpis . I modified the input file to as to not have any blank columns. How should I proceed now?

[JosephSerpis · Accepted solution]

Hi @SCK came up with a couple of ways let me know what you think?

[grazitti_sapna · Accepted solution]

Hi @SCK , you can try this with regex_replace or normal replace with a if else condition.

Thanks.