Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Substring inverse part of a field based on another field

dshay249
6 - Meteoroid

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

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @dshay249 

 

You can use replace function to get the desired result.

 

Formula:

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

 

Workflow:

atcodedog05_0-1630423749420.png

 

Hope this helps : )

dshay249
6 - Meteoroid

Thanks it works very well.

 

Much appreciated.

 

dshay

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @dshay249 

Cheers and have a nice day!

Labels
Top Solution Authors