A shot from the hip on this one: (SRPL(String, " ", " ", 0))
Then you'd have to run this SRPL in a loop until you get rid of all the double spaces. One problem I recall with SRPL is that it won't replace any string with a zero length string. Somebody correct me if I'm wrong. Scott ==== Ramsour Mike wrote: > 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 -- Scott ==== Scott J. Salisbury Matrix Data Systems / The R:Street Journal 5114 Point Fosdick Drive NW, Suite E-272 Gig Harbor, WA 98335-1733 E-Mail Address: [EMAIL PROTECTED] Temporary URL: www.seanet.com/~sjs (downloads available) New Web Address: www.rStreetJournal.Com Direct Line: 206-423-7679 Toll Free: 888-386-5040 Seattle: 206-448-7975 Fax: 305-425-0491
