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