Remove Characters Found in another Field

[mem2243]

How do I remove the EXACT characters found in one field from the end of another field?

Example

Field 1                   FIELD 2        DESIRED OUTPUT

STONE NAM         NAM             STONE

SWST                    TEXAS          SWST

I tried TrimRight([FIELD 1],[FIELD 2]) but it removes S and T from the second line because those characters are in Field 2. I only want it to remove it if all of the characters appear in order in the field. 

[Jonathan-Sherman · Accepted solution]

Hi @mem2243,

You could use:

Trim(Replace([Field1], [Field2], ''))

If this solves your issue please mark the answer as correct if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[mem2243]

Thanks! that works

[Jonathan-Sherman]

Great to hear @mem2243! Please do make sure you mark the solution as correct in order to help others find the thread more easily.