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
Solucionado! Ir para Solução.
Hi @dshay249
You can use replace function to get the desired result.
Formula:
Replace([Field 1],[Field 2],"")
Workflow:
Hope this helps : )
Thanks it works very well.
Much appreciated.
dshay
Happy to help : ) @dshay249
Cheers and have a nice day!