Substring inverse part of a field based on another field

[dshay249]

Hi,

Is there a way to substring a field based on another field value that is not fixed length and display the inverse   i.e

Field 1             Field 2         DESIRED RESULT

ADCDEFG      ABCD                 EFG       

DEFGHI           DEF                   GHI

KLMNOPQ        KL                 MNOPQ

Thanks any help would be appreciated.

dshay

[atcodedog05 · Accepted solution]

Hi @dshay249 

You can use replace function to get the desired result.

Formula:

Replace([Field 1],[Field 2],"")

Workflow:

Hope this helps : )

[dshay249]

Thanks it works very well.

Much appreciated.

dshay

[atcodedog05]

Happy to help : ) @dshay249 

Cheers and have a nice day!