Concatenatation of filed in one filed
I am concatenating few field to a character field..by separating with "|" symbol..it is something like this..
*|||***||** (* refers char value)
few field does not have value for which subsequent '|' symbol is there..
I want number of spaces (as per data-element) should be there instead of blank. Some thing like this..
*| | |***| |**
How to achieve this?