Lookup - concatenation functions

Nancy Palmquist nlp at vss3.com
Fri Mar 5 08:23:25 PST 2004


> Transpower at aol.com wrote:
> 
> In a message dated 3/5/2004 8:56:56 AM Eastern Standard Time,
> swaters at abiederman.com writes:
> 
>      Jeff,
>      Is 1&2 the same as 1{2 ?
> 
>      From: Jeff Harrison
> 
>      Yes, but use 1&2 not 1<2
> 
> No.  The "&" leaves a space.  The "{" does not.
>

This answer is incorrect.


These three functions are very different:

Here is the answer:

field 1 is 10 characters  "MARY^^^^^^"
field 2 is 5 characters   "^^^^1"
field 3 is 8 characters	  "JONES^^^"

The ^ is used to indicate a space so you can see the difference

1&2&3   will create  "MARY^^^^^^^^^^1Jones^^^"
1{2{3   will create  "MARY1JONES^^^"
1<2<3   will create  "MARY^1^JONES^^^"

If you want the spaces removed from the end of the line just add the
following:

1{2{3{""   will create "MARY1JONES"

	
-- 
Nancy Palmquist 
Virtual Software Systems
PHONE: (412) 835-9417			Web site:  http://www.vss3.com



More information about the Filepro-list mailing list