jaymc Posted April 23, 2008 Share Posted April 23, 2008 Im using replace to cut out various chars However, I need to replace a bunch of chars, but not sure if replce supports this I need to replace the following with NULL . ' " , Can replace take in an array of parameters, for instance, and Im using * as a fake seperator here replace(field_name, ',*'*"*.', '') I need it to work like that if possible, is there syntax for it... Quote Link to comment Share on other sites More sharing options...
fenway Posted April 23, 2008 Share Posted April 23, 2008 Nope... you have to nest all of the REPLACEs. Or you could write a UDF. Or you could install a set of UDFs with PCREs and make it easy. Quote Link to comment Share on other sites More sharing options...
jaymc Posted April 23, 2008 Author Share Posted April 23, 2008 Ok, can you give me an example of NESTED replaces Quote Link to comment Share on other sites More sharing options...
fenway Posted April 23, 2008 Share Posted April 23, 2008 Ok, can you give me an example of NESTED replaces Does this help? Quote Link to comment Share on other sites More sharing options...
jaymc Posted April 23, 2008 Author Share Posted April 23, 2008 Ha, I was just reading the same page before checking your post, yes its ok I will just use NESTED its no problem Cheers Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.