Formula Tool

[guadalupemota]

Hi,

I have a data set where on my "Xlarge bags" column there is an O instead of a zero. and down the column there's other numbers that should stay as is. I only need to change the alphabet letter O to 0.

I used the formula tool and I put:

IF [XLarge Bags] = "O"

THEN "0" 

ELSE "0"

ENDIF

However, this formula changed the whole columns to zeros and I only needed that row with O to change to 0.

Please advise!

Thank you,

Guadalupe  

[fmvizcaino · Accepted solution]

Hi @guadalupemota ,

You should use the following:

IF [XLarge Bags] = "O"

THEN "0" 

ELSE  [XLarge Bags] 

ENDIF

Best,

Fernando V.

[Simha]

Please replace your entire code with below:

Replace([Xlarge bags], "O", "0")

Your code is replacing the entire column with 0.

Regards

Simha

[guadalupemota]

Thank you Fernando! That formula solved my issue!