Hi all,
I am having 2 fields WS-FIRSTNAME and WS-LASTNAME. The data in them contains
"JOE " and "SMITH "
How do I get my final output to be "JOE SMITH" ?
Any suggestions through INSPECT or EXAMINE or REPLACE SPACES BY NULLS, etc ?
? ? I don't want to use any loop to search each and every field position for
spaces or anything like that..
The data in these 2 fields is left justified but can contain any names and
may not always look like the example provided above. It can also contain
special names like "JOE SR. " or JOE III "
Thanks
Raghu.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *