Re: Correlative
Kate As an aside to this thread... Changing flavour isn't too difficult. Put the appropriate $OPTIONS PICK statement in all existing programs then change flavour. It is true there are differences with report outputs but they are not great and in many cases they are for the better. Cheers Trevor Ockenden OSP - Original Message - From: "Kate Stanton" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Friday, March 26, 2004 10:56 AM Subject: Re: Correlative > But they would not print properly on our CHANGES.LDICT, etc, etc reports. > > - Original Message - > From: "Jeff Schasny" <[EMAIL PROTECTED]> > To: "U2 Users Discussion List" <[EMAIL PROTECTED]> > Sent: Friday, March 26, 2004 9:25 AM > Subject: RE: Correlative > > > A pick flavor account will still support I types > > > 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 > --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.642 / Virus Database: 410 - Release Date: 24/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Correlative
But they would not print properly on our CHANGES.LDICT, etc, etc reports. - Original Message - From: "Jeff Schasny" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Friday, March 26, 2004 9:25 AM Subject: RE: Correlative A pick flavor account will still support I types 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
Re: Correlative
You beauty! That does it. Perfect. Many, many thanks. - Original Message - From: "Results" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Thursday, March 25, 2004 5:12 PM Subject: Re: Correlative Katie, F1;(ML#30);10;: The width of 30 will make the wrapping happen. -- Sincerely, Charles Barouch www.KeyAlly.com [EMAIL PROTECTED] Kate Stanton wrote: >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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: @WL Correlative
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
RE: Correlative
A pick flavor account will still support I types -Original Message- From: Kate Stanton [mailto:[EMAIL PROTECTED] Sent: Thursday, March 25, 2004 2:31 PM To: U2 Users Discussion List Subject: Re: Correlative You are probably right, Trevor, but we converted when we went to Universe whenever that was, and all our reporting, etc is on PICK format. Hard to get changed format to the top of the list. - Original Message - From: "Trevor Ockenden" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Thursday, March 25, 2004 5:01 PM Subject: Re: Correlative Kate Use an I-type dictionary as follows: 0001: I 0002: F1:@TM:F10 0003: 0004: Whatever 0005: 30T 0006: S If the contents of either F1 or F10 they will wrap appropriately. I find I-types to be s much easier as a programmer. Cheers Trevor Ockenden OSP - Original Message - From: "Kate Stanton" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Thursday, March 25, 2004 1:54 PM Subject: 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 > --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.642 / Virus Database: 410 - Release Date: 24/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 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Correlative
You are probably right, Trevor, but we converted when we went to Universe whenever that was, and all our reporting, etc is on PICK format. Hard to get changed format to the top of the list. - Original Message - From: "Trevor Ockenden" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Thursday, March 25, 2004 5:01 PM Subject: Re: Correlative Kate Use an I-type dictionary as follows: 0001: I 0002: F1:@TM:F10 0003: 0004: Whatever 0005: 30T 0006: S If the contents of either F1 or F10 they will wrap appropriately. I find I-types to be s much easier as a programmer. Cheers Trevor Ockenden OSP - Original Message - From: "Kate Stanton" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Thursday, March 25, 2004 1:54 PM Subject: 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 > --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.642 / Virus Database: 410 - Release Date: 24/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
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
Re: Correlative
Katie, F1;(ML#30);10;: The width of 30 will make the wrapping happen. -- Sincerely, Charles Barouch www.KeyAlly.com [EMAIL PROTECTED] Kate Stanton wrote: 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
Re: Correlative
Kate Use an I-type dictionary as follows: 0001: I 0002: F1:@TM:F10 0003: 0004: Whatever 0005: 30T 0006: S If the contents of either F1 or F10 they will wrap appropriately. I find I-types to be s much easier as a programmer. Cheers Trevor Ockenden OSP - Original Message - From: "Kate Stanton" <[EMAIL PROTECTED]> To: "U2 Users Discussion List" <[EMAIL PROTECTED]> Sent: Thursday, March 25, 2004 1:54 PM Subject: 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 > --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.642 / Virus Database: 410 - Release Date: 24/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
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