| ilovesoup | c9fef1d | 2012-07-08 19:30:42 +0000 | [diff] [blame] | 1 | drop dataverse test if exists; |
| 2 | create dataverse test; |
| 3 | use dataverse test; |
| 4 | |
| 5 | write output to nc1:"rttest/string_replace22.adm"; |
| 6 | |
| 7 | let $c1 := replace2("abracadabra","", null , null) |
| 8 | let $c2 := replace2("abracadabra","bra", "XXX" ,"") |
| 9 | let $c3 := replace2(null,"hello world", "XxXx" , "x") |
| 10 | let $c4 := replace2("abracadabra","bra", "XXX" ,null) |
| 11 | let $c5 := replace2("abracadabra",null, "XXX" ,null) |
| 12 | let $c6 := replace2("abracadabra","Bra", null ,"i") |
| 13 | let $c7 := replace2("abracadabra","Bra", "" ,"i") |
| 14 | let $c8 := replace2("abracadabra","", "XXX" ,"") |
| 15 | return {"result1": $c1,"result2": $c2,"result3": $c3,"result4": $c4,"result5": $c5,"result6": $c6,"result7": $c7,"result8": $c8} |