replace data in a column

felix

Hi all!

I have an ad-hoc to do and I need your help with this step.

I have a column of data in which I need to replace some entries.

Data is like this. A,B,C are all string type names.

Col_name

null

I want to replace null with C. Please let me know how to do this.

Thank you very much for your help.

Felix

Common Use Cases

Accepted answers

derekbelyea

This will do it.

UpdateInputValues.yxmd

All comments

john_miller9

@felix A simple formula should take care of this for you.

IFNULL([Col_name], 'C')

j Replace Row.PNG

felix

Hi John,

Sorry for not making this clear.

My column is like

null

I want to replace the first two null with C

and leave other nulls as nulls

Thanks,

felix

Rob48

Hi John, great and simple explanation. i successfully used it with the below test formula with the column "ship from" as my output column in the config box:

IF [SHIP FROM]="FI07A"
THEN "Workd"
ELSE [SHIP FROM] ENDIF

this changed all instances of "FI01A" in the single column "ship from" to "Workd".

now the problem I still have:

How to use this to change every instance of "FI01A" in the entire file, every cell in every row and column?

i was directed to the Dynamic Replace Tool in another post but none of the examples quite fit my situation.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703