SELECT command for multi-value fields

dear all

greetings

i have the following SELECT command running from the jshell in my t24 environment.

SELECT FBNK.AA.ARR.PAYMENT.SCHEDULE SAVING EVAL"PAYMENT.TYPE:',':PAYMENT.FREQ:',':CALC.AMOUNT:',':ACTUAL.AMT:',':BASE.DATE:',':ID.COMP.1:',':ID.COMP.3:',':END.DATE" .

i save the out put in &SAVEDLISTS& using SAVE-LIST command. in a CSV file format.


the command work fine but when i open the csv file in excel , the output iS not what i want. This happen whenever multi-value fields are included in select statement.

as you can see it below the date and the arrangement no is reported under payment frequency and calculated amount filed respectively

IS there any solution or this ? can any one help ?

kindly see below the sample data taken from out put of the above select command



CONSTANT e0Y e1M e0W o28D e0F 611.13 AA12048RCCG5 20120217.1
ACTUAL e0Y e1M e0W o28D e0F 611.13 AA12048RCCG5 20120217.1
20120217 AA12048RCCG520120217.1

CONSTANT e0Y e1M e0W o28D e0F 684.78 AA120487TLBD 20120217.1
ACTUAL e0Y e1M e0W o28D e0F 684.78 AA120487TLBD 20120217.1
20120217 AA120487TLBD 20120217.1