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... Link to comment https://forums.phpfreaks.com/topic/102602-solved-replace/ 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. Link to comment https://forums.phpfreaks.com/topic/102602-solved-replace/#findComment-525458 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 Link to comment https://forums.phpfreaks.com/topic/102602-solved-replace/#findComment-525463 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? Link to comment https://forums.phpfreaks.com/topic/102602-solved-replace/#findComment-525466 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 Link to comment https://forums.phpfreaks.com/topic/102602-solved-replace/#findComment-525471 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.