Is there an efficient way of deleting extraneous embedded spaces in a text string? The STRIM function deletes trailing spaces but I'd like to replace extra spaces within a text string to just one space character. The TRIM function in Excel, for instance, says it will "Removes all spaces from a text string except for single spaces between words."
My specific situation is that I am loading an R:Base table with a fixed field file from our VAX-based business system. The file contains five 80-character text fields that contain comments. I'd like to load this into one 400-character text field in R:Base and then be able to remove all the extra spaces. Any suggestions are greatly appreciated! Mike Ramsour Technology Department AK Steel Coshocton Works 17400 SR 16 Coshocton, OH 43812-0190 Voice: (740) 829-4340 FAX : (740) 829-4211
