Sep 30, 2023 06:31 PM - edited Oct 01, 2023 12:59 AM
List A: the, cat on, was not, sat on
List B: cat on, sat on
output: the, was not
EDIT: List A & B are linked fields. Linked to the same original field.
I want to implement this functionality. It is achievable using a SUBSTITUTE on list B to add the relevant REGEX characters []* etc.
This substitute would be placed in a REGEX_REPLACE to remove all the words in list B.
I know it’s doable - but I struggling with the regex. Can anyone help please?
Solved! Go to Solution.
Sep 30, 2023 11:21 PM
Oct 01, 2023 12:18 PM
Sorry, but after your edit it's totally unclear. Linked fields are linked to tables, not fields. So how many tables..... but wait, maybe it doesn't matter. Just use the same formula with CONCATENATE({Field Name}) instead of just {Field Name}
Sep 30, 2023 11:21 PM
Oct 01, 2023 12:58 AM
Great solution, but unfortunately this doesn't appear to work with Linked fields. I've tried rollup on linked fields to with no luck either.
Oct 01, 2023 06:13 AM
Screenshots? What are you rollup formulas?
Oct 01, 2023 09:25 AM
Rolling up a linked list. Guessing that's the problem. It's not an array.
Oct 01, 2023 12:18 PM
Sorry, but after your edit it's totally unclear. Linked fields are linked to tables, not fields. So how many tables..... but wait, maybe it doesn't matter. Just use the same formula with CONCATENATE({Field Name}) instead of just {Field Name}
Oct 01, 2023 05:02 PM
Screen shots of all the fields involved showing exact field types and formulas would help. Including screenshots of the fields you are rolling up. Screenshots make it very clear what the field types are, and screenshots of formulas reveal other things. There also could be hidden spaces that screenshots don’t show, but screenshots are still useful.
You could just try forcing items to strings as Alexey suggests and see if it works. But if you have lookups anywhere in the system, it may not solve your issues.
Oct 02, 2023 02:06 AM
Thanks - between all three of you i've managed to solve this - it was a "type" problem and CONCATing at the right place worked. It's complex so between 5 different tables so wasn't really something easily shared, nor was the information shareable.
Thanks for the help and patience. I've not got a load of commas to remove.