String manipulation

Hi,

what does this expression mean and what does it do replace($Column 0$,"%" ,"" )

Thanks 

Uzma 

from the description in the node:

 

        Replaces all occurrences of a String within another String.

Examples:

replace("abcabc", "ab", "") = "cc"
replace("abcabc", "ab", "z") = "zczc"
replace(null, *, *) = null
replace("", *, *) = ""
replace("any", null, *) = "any"
replace("any", *, null) = "any"
replace("any", "", *) = "any"

* can be any character sequence.     

So you are replacing all instances of % with nothing from the value in Column 0. So you are effectively stripping out all instances of % in a String.