In From List, you can specify the list of special characters that needs to be replaced
In To List, you can specify the list of new characters that will replace the special chars. In your case it will 'N'.
In Expression, you can give the column name.
No commas... unless you want those replaced as well... with another comma.
I'd still like to see examples of these 'special characters' before people go too crazy with the suggestions...
Edited to add: Ack, am I in the PX forum? Dang. That's technically a Server answer so the PX syntax may very well require commas. If that's the case, my bad..
Last edited by chulett on Thu Oct 26, 2006 5:42 pm, edited 1 time in total.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Because, as I noted, you are telling it to replace all commas in the string with yet another comma, so it just looks like it works fine. Check the examples in the online help.
It's certainly not a fatal problem, just wastes cycles. It's not all that different from telling it to replace all 'X' characters with an 'X'.
-craig
"You can never have too many knives" -- Logan Nine Fingers