need space when concatenating
i want a space befor my hyphen and after the hyphen,
i tried using ' ' before and after the hyphen but i dont see any space...how to do that???
concatenate wa_Fin-a '- ' wa_fin-b into wa_fin-c.
Matthew Billingham replied
I was going to reject this post, but saw the question about 5 spaces, so I decided it's sufficiently different to remain.
>concatenate wa_Fin-a ' - ' wa_fin-b into wa_fin-c . > or, > concatenate wa_Fin-a space '-' space wa_fin-b into wa_fin-c .
Nonsense. Have you tried it?
To the original poster. Concatenate ignores (removes) trailing spaces from the components. ( Generally - there are some exceptions in later releases, read F1 help for more info. ). If you need to retain spaces, or add extra ones in, try something like this
CONCATENATE field1 '#####-#####' field2 INTO output. TRANSLATE output USING '# '.
Edited by: Matt on Apr 2, 2009 8:21 AM