× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



"Booth Martin" <Booth=zPOEG7LBV2lWk0Htik3J/w@public.gmane.org> helped
spread the news by saying:

>
>
> Are you trying to remove the blank, keep the leading zero, or both?
>
>
>
> ---------------------------------------------------------
> Booth Martin   http://www.MartinVT.com
> Booth=zPOEG7LBV2lWk0Htik3J/w@public.gmane.org
> ---------------------------------------------------------
>
> -------Original Message-------
>
> From: rpg400-l=Zwy7GipZuJhWk0Htik3J/w@public.gmane.org
> Date: Friday, October 18, 2002 11:51:19 AM
> To: rpg400-l=Zwy7GipZuJhWk0Htik3J/w@public.gmane.org
> Subject: Concatenate text + numeric
>
> I need to combine an alpha field with a numeric field to create a
> single alpha-numeric field (makes sense) like thus:
>
> Alpha = "XX"
> Number = 01234
>
> When I use the statement
>
> EVAL AlphaNum = Alpha + %char(Number)
>
> I end up with AlphaNum = "XX 1234". I've tried
>
> EVAL AlphaNum = Alpha + %editw(Number: '0 ')
> and
> EVAL AlphaNum = Alpha + %editc(Number: '3')
>
> with similar results. What's the secret to getting it to work?
>
> Eventually I ended up coding
>
> MOVEL Alpha AlphaNum
> MOVE Number AlphaNum


Sorry, I must have left that part out.  I need what I get with the MOVE
statements - that is, "XX01234".

As Carsten said, I think I need to use the edit code 'X'.

--
David Schopp
WISDM Team Leader
Computers Unlimited




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.