Simon:

I would guess that you want to keep the general idea of the original
text.  Just a thought, substitute a '-' or '_' for each embedded space.
It would sort to almost the same as the space.

Olav.

Buckingham, Simon wrote:

>My Powerhouse is a bit rusty but do any of the gurus out there have some
>QUIZ/QTP coding to remove blanks within a field. We are migrating to a
>new system which does not allow blanks in key fields (ie a value of ABC
>123 has to become ABC123)
>
>
>
>Cheers
>
>
>
>Simon Buckingham
>
>
>
>
>
>
>
>Please be advised that this email may contain confidential
>information.  If you are not the intended recipient, please notify us
>by email by replying to the sender and delete this message.  The
>sender disclaims that the content of this email constitutes an offer
>to enter into, or the acceptance of, any agreement; provided that the
>foregoing does not invalidate the binding effect of any digital or
>other electronic reproduction of a manual signature that is included
>in any attachment.
>
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
>
>

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *