Return only a portion of a variable

[zagzebski]

I have the following

Variable1 = North

Variable2 = North East

I need the ability to create an expression that would remove the portion of Variable1 that is in Variable2.  In the example above the expression would return "East" because "North" would be removed from Variable2 because it  is also in Variable1.

Thanks for any help!

Z

[antoniotiman]

Hi Steve,

may be

Replace(Variable2,Variable1,'')

Regards,

Antonio

[jayshrinipurte · Accepted solution]

Hi Steve,

According to my understanding whatever you asked i tried solving it

plz check whether it is matching your requirement

If(SubField($(vVariable2),' ',1)=SubField($(vVariable1),1),Replace($(vVariable2),$(vVariable1),''))

Regards,

Jayshri

[zagzebski]

Thanks so much!

[jayshrinipurte]

Welcome Steve