SUBFIELD() HELP

mahitham — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

Can any one please help me on Below requirement.

I have a field called TYPE from that field i need to created EXPECTED_TYPE Field.

TYPE contains below records. Here I have to remove AA,AAK from each records I have to consider only first two parts from each TYPE record.

Please help me on this. Thanks in advance.

TYPE EXPECTED_TYPE

AGSH-00B3RT-AA AGSH-00B3RT

AGSH-00B3RT-AAK AGSH-00B3RT

AGSH-ABID-AA AGSH-ABID

AGSH-ABID-AAK AGSH-ABID

AGSH-00UUKT-AA AGSH-00UUKT

AGSH-00UUKT-AAK AGSH-00UUKT

Re: SUBFIELD() HELP

YoussefBelloum — Tue, 10 Jul 2018 08:15:46 GMT

Hi,

using Subfield, you can try this:

=SubField(TYPE,'-',1)&'-'&SubField(TYPE,'-',2)

fvelascog72 — Tue, 10 Jul 2018 08:24:05 GMT

Hi,

You can also try:

Left(DATA, Index(DATA, '-', 2)-1)

Saludos