SUBFIELD() HELP

[mahitham]

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

[YoussefBelloum · Accepted solution]

Hi,

using Subfield, you can try this:

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

[fvelascog72]

Hi,

You can also try:

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

Saludos