I need your help.
In a column I have a text with variable content and variable length, I need to find if in this string is contained a fixed length number and if this number matches with a secondo column.
Just to make sure you understood the use case I was trying to make, in the case of “3578769411524789”, “35787694” is not a standalone string, but rather a sub-part of a string. It is different from your ID 7 example of “35787694 11524789” where “35787694” is on its own.
For example, should “135787694” or “357876940” match for “35787694”?
EDIT: In the meantime I put something very simple together based on your current answer that looks like this: