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],"&#58;",":")

    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.

score 7 · Accepted Answer · answered Nov 01 '17 at 10:32

7

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

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

answered Nov 01 '17 at 10:32

SqlKindaGuy

3,501
2
12
29

Thanks for catching the additional Replace I neglected to add. – David F Nov 01 '17 at 17:09

score 0 · Answer 2 · edited Nov 01 '17 at 12:01

0

Try

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

edited Nov 01 '17 at 12:01

Jean-François Corbett

37,420
30
139
188

answered Nov 01 '17 at 10:05

PRASHA

11

score 0 · Answer 3 · answered Nov 01 '17 at 10:39

Check This.

\ is escape character. If you want to have single backslash literal inside SSIS string you have to escape it and use \\

Code :

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

in your code you missed 3rd replace function.

Code:

Output :

Combine multiple Replace expressions for a SSIS Derived Column

3 Answers3