| drop dataverse test if exists; |
| create dataverse test; |
| use dataverse test; |
| |
| write output to nc1:"rttest/string_replace22.adm"; |
| |
| let $c1 := replace2("abracadabra","", null , null) |
| let $c2 := replace2("abracadabra","bra", "XXX" ,"") |
| let $c3 := replace2(null,"hello world", "XxXx" , "x") |
| let $c4 := replace2("abracadabra","bra", "XXX" ,null) |
| let $c5 := replace2("abracadabra",null, "XXX" ,null) |
| let $c6 := replace2("abracadabra","Bra", null ,"i") |
| let $c7 := replace2("abracadabra","Bra", "" ,"i") |
| let $c8 := replace2("abracadabra","", "XXX" ,"") |
| return {"result1": $c1,"result2": $c2,"result3": $c3,"result4": $c4,"result5": $c5,"result6": $c6,"result7": $c7,"result8": $c8} |