Thanks for the input folks. Whilst there are a few ways of achieving my aim I have researched Krikor's suggestion and will continue to use QUIZ/QTP in this instance.
Cheers
Simon
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of krikor Gullekian
Sent: Tuesday, 2 August 2011 5:24 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] Powerhouse question
With the INDEX and SUBSTRING functions you can eliminate the blanks.
Krikor
--- On Mon, 8/1/11, Buckingham, Simon <[log in to unmask]> wrote:
From: Buckingham, Simon <[log in to unmask]>
Subject: [HP3000-L] Powerhouse question
To: [log in to unmask]
Date: Monday, August 1, 2011, 3:20 AM
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 *
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 *
|