making cell Blank or Null

[ashaik1]

Hello,

The Data2 column of my output has '' in the cell. I tried to make it blank or null using the formula tool. But looks like it is not recognizing '' quote. Can you advise. Attached is the sample WF

[Qiu]

@ashaik1 

Your '' is two single quote, since use two double quotes to escape.

[AbhilashR]

Hi @ashaik1, building on @Qiu's solution and making it applicable to your problem statement, below is an alternate approach

I hope this helps!

[ashaik1]

Thanks It has worked

[ashaik1]

Thanks Abhilash