You are right, Neil, and that is what I had - I had mis-keyed my email (different machines).
----- Original Message ----- From: "Neil Charrington" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Thursday, March 25, 2004 6:46 PM Subject: RE: @WL Correlative Kate, The first thing is that in your F-correlative the ;1;20; before the [ ] needs to be ;C1;C30; otherwise it is saying use attribute 1 and attribute 30 to extract from attribute 1. The [ ] is an extract only and does not force the length of the preceding text/attribute to be 30 characters long. The solution by "Results" - F;1;(ML#30);2;: - is the correct method, it will force attribute 1 to be 30 characters long and concatenate with attribute 2. So attribute 1 multivalue 1 will concatenate with attribute 2 mv 1, att.1 mv 2 with att 2 mv 2 and so on. The (ML#30) is ignored for blank values so att 1 mv 2 (and 3 etc) will be blank and not a row of 30 spaces. As long as attribute 1 is a single value you will end up with your desired result: Name of item 1st line of notes 2nd line of notes The other important thing for this dictionary item to work, is that the length must be the same value as in the ML# command. IHTH Neil Neil Charrington C.A> Software Systems www.casoftware.co.uk www.mv4gl.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kate Stanton Sent: 25 March 2004 02:54 To: U2 Users Discussion List Subject: @WL Correlative I have a file with field 1 containing description (30 chars), and field 10 containing notes (30 characters, multi-value). For reports, I want to print a single column containing description with notes underneath. So if description is "Name of item" and notes line 1 is: "First line of notes", line 2 is "2nd line of notes", I want a column of: Name of item 1st line of notes 2nd line of notes I have tried the following correlative: F1;' ';1;30;[];10;: but it repeats the description before each line of notes: Name of item 1st line of notes Name of item 2nd line of notes If I just concatenate with F1;10;: I am not surprised to get: Name of item1st line of notes 2nd line of notes I can't for the life of me work out how to do it. Can anyone help? Please! TIA, Kate Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland, New Zealand ph +64 9 360 5310 fax +64 9 376 0750 ah +64 9 378 9594 [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.634 / Virus Database: 406 - Release Date: 18/03/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.634 / Virus Database: 406 - Release Date: 18/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
