COMMON FIELDS
From: Allan Martin <allanmartin_at_ntlworld.com>
Date: Fri, 19 Apr 2002 14:24:14 +0100
Message-ID: <3cbfb80f_at_cpns1.saic.com>
Hi,
[Quoted] Can anyone advise the best way to pull a common string (if any) from a feild in a table. They will be grouped by another field. I plan to append results to a table.
e.g.
Date: Fri, 19 Apr 2002 14:24:14 +0100
Message-ID: <3cbfb80f_at_cpns1.saic.com>
Hi,
[Quoted] Can anyone advise the best way to pull a common string (if any) from a feild in a table. They will be grouped by another field. I plan to append results to a table.
e.g.
INPUT TABLE
PK GROUP M100A M M100B M M100C M ABCD1 A ABCD2 A ABCD3 A BG456 H AFCG H ACFE H
OUTPUT TABLE
COMMON STRING GROUP
M100 M ABCD A **NONE** H
Thanks very much,
Allan
Received on Fri Apr 19 2002 - 15:24:14 CEST