Good afternoon: What's the best way to remove embedded spaces from text strings?
I have a column named COMMENTS that contains text prose similar to this: 'COLD MILL CHATTER VERY LITE' I want to remove any occurrence of 2 or more spaces in a row so that I end up with a value like this: 'COLD MILL CHATTER VERY LITE' I have experimented with the various TRIM functions as well as SRPL but have not had any success yet. I'm looking for the same functionality as the TRIM () function in Excel. Any help is greatly appreciated. Best regards. Mike Ramsour AK Steel Coshocton Works Quality Department Phone: 740-829-4340 Cell: 740-502-1659 Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/OF633DC4EF.8B6FCEE6-ON852584F1.0067DC43-852584F1.0068B53F%40aksteel.com.
