If the file is called TEST and the multi-valued data is in attribute 42 then you could create a dictionary item like this:
0001 A 0002 0 0003 0004 0005 0006 0007 0008 TTEST;X;;42]MCC; ;- 0009 L 0010 10 where ']' is a multi-value mark, char(253), and there is a space, char(32), in between the two ';'s in the MCC conversion. Also, in order for this to work you need to have 'tconv_no_replace = false' in 'Config_EMULATE'. Dan On Thu, Feb 16, 2012 at 4:41 AM, Calvin <[email protected]> wrote: > Hello Jbase Experts, > > I need your help. > > I am trying to select Multivalues from tables and display them with a > known separator. When you use the LIST command it just seems to > separate the Multivalue fields with spaces. I need to be able to > separate them with a distinct value. > > Need to list the multivalues with a user specified marker or > seperator? > > Thanks > > -- > IMPORTANT: T24/Globus posts are no longer accepted on this forum. > > To post, send email to [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en > -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
