G'day Mike, I load that type of file into NoteTab Pro and do a search and replace on spaces.
It will allow you to replace' ' with ' '. It will also allow you to use ^P to replace an end of line char, so if you wished to, for instance, replace a RETURN in an IF statement but not elsewhere you could specify: ^P RETURN^PENDIF as the text to be replaced by: ^P GOTO Blah^PENDIF At 03:16 PM 09/10/2001 -0400, you 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 Warmest regards, Tom Grimshaw coy: Just For You Software tel: 612 9552 3311 fax: 612 9566 2164 mobile: 0414 675 903 post: PO Box 470 Glebe NSW 2037 Australia street: 3/66 Wentworth Park Rd Glebe NSW 2037 email: [EMAIL PROTECTED] web: www.just4usoftware.com.au This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses.
