t11
June 22, 2017, 8:07pm
1
Hi there,
I was wondering if it’s possible to have a text field showing the difference between two other text fields. Example:
TEXT 1:
This is a short text.
TEXT 2:
This is a super short text.
RESULTING TEXT FIELD:
super
Tried to create some workarounds using :find&replace, but didn’t do the trick.
Any idea?
Thanks a lot!
NigelG
June 23, 2017, 5:32am
2
Doable, but not easy ! This uses an RG … but that is just to show it working.
Convert your two texts to lists of words using Extract with Regex "[^"]+"|([^)]+)|[^"\s()]+
Then do an “intersect” on your two lists, so that gives the list of words that are in both lists …
Then merge list 1 and 2 and filter where “this text” is not in the “intersect” list from the previous step.
2 Likes
t11
June 23, 2017, 3:35pm
3
Awesome! Thanks a lot, NigelG!
I’ve managed to replicate your example. But I’m guessing that’s only possible between texts of the same data type, right?
NigelG
June 27, 2017, 5:48am
4
Texts are texts … so not sure what you mean ?
system
Closed
August 31, 2017, 8:07pm
5
This topic was automatically closed after 70 days. New replies are no longer allowed.