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

A

null

null

B

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

Thank you very much for your help.

Felix

[john_miller9]

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

IFNULL([Col_name], 'C')

j

[felix]

Hi John,

Sorry for not making this clear.

My column is like 

A

null

null

B

null

null

D

null

null

I want to replace the first two null with C

and leave other nulls as nulls

Thanks,

felix

[derekbelyea · Accepted solution]

This will do it.

[john_miller9]

Here's an alternative method, leveraging Record ID

[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.

[john_miller9]

Hi @Rob48 - Please start a new post so that it'll be easier for folks to find the solution in the future.  It will also help if you could post a sample of the data.  Thanks!