rereplacenocase(string, '[a-z0-9 ]+', '', 'all') This will remove every occurences of a character that is NOT within the range of A-Z (both cases), 0-9 or a space. This will include ANY non-number/letter character so if there is something you want to keep, it has to be included within the brackets.
> I know this will be simple for some .. but it isn't for me .. I have > tried to find something for this. > > I need to remove all punctuation except for spaces between words. I > only want alpha and numeric (plus spaces) left. > > Example: > > Str = I don't remember, if it was 12" or 12'? > > Result = I dont remember if it was 12 or 12 > > I have tried a few things and I can remove EVERYTHING, but can't get > it to leave just the spaces. > > THANKS > > Paul Giesenhagen > QuillDesign > 417-885-1375 > http://www.quilldesign.com > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236302 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54