Combine multiple Replace expressions for a SSIS Derived Column

Question

I have 3 Replace expressions that resolve in SSIS derived columns. When I attempt to combine them into 1 string they error. The replace are all in the same column. Immediately below are the 3 resolved expressions.

    REPLACE([Column1],":",":")

    REPLACE([Column1],"\n"," ")

    REPLACE([Column1],"</div>"," ")

Below are the 2 unresolved expressions I have attempted.

    REPLACE([Column1],"&#58;",":","\n"," ","</div>"," ")

    Replace(Replace([Column1],"&#58;",":"),"\n"," "),"</div>"," ")

Any assistance in getting the correct syntax is greatly appreciated.

Answer 1

This will replace your [Column1] with all your values.

REPLACE(REPLACE(REPLACE([nightrate],"&#58;",":"),"\n"," "),"</div>"," ")