Replace value with Blank not null()

[subhajits11]

If [something]=1 then "it is one"

Else [Do Nothing] 

end if

I want my cell value should be blank.(Adding new column formula tool).i am not able to achieve [Do Nothing]  this part.

This is possible by "find replace " ,but I don,t think that's the solution.

Regards,

Subhajit

[markcurry · Accepted solution]

If you don't want to add nulls, you can and an empty string "" instead....

IF [something] = 1 THEN
"it is one"
ELSE
""
ENDIF

You can check for Empty strings with that IsEmpty function.  Hope that helps

[Bennel_Wilson · Accepted solution]

Hi @subhajits11 ,

I agree with the approach of @markcurry . A simple formula tool with the formula should do the trick.

The result this step would leave all other cells with blank spaces, what I mean is they're necessarily not empty and in an excel output they wont show as blanks. See below: 

So as a final act, you could use a data cleaning tool to remove all such white spaces which should leave the result column with absolute blank cells. See below:

 Attached workflow for your reference.

Regards

Benn

P.S: In case this solves your query, kindly mark as solution.

[subhajits11]

Thank you so much Bennel_Wilson

i found no space between inverted coma gives my expectations.

[Bennel_Wilson]

Glad, I could help

[Angelica_Obi]

i'm still getting null no matter the variation I type

[RWJS]

you can also use Null, then data cleanse to a blank (you may need to revert to a string field first)