It's pretty simple but I didn't know this: TRIM ( '.,! ' FROM '# test .' )