How to extract continuous string set from a column with multiple criteria

Greg_DecklerThanks for the file. I went throught the implementation and I somehow feel the logic is taking a different approach. Let me jot down the logic that I feel is a right approach. I am not sure if this is implementable with the current formula and functions in PBI.

Logic:

1. Pick value of first cell in Project table(Value to be found reference column). Start with searching for the first 3 characters of this cell in the Client Name (Find Within column). Return all the cells having these 3 characters in the Client Name appearing continuously and save it in a variable. Now add the 4th character and search for the continuous appearances in Client Name (Return values will decrease because of adding the 4th continuous character). Repeat adding characters until no matches are found.

Final value to be returned is the last variable value with the maximum continuous matches.

2. Now repeat the entire thing for value in the second cell of the Project Table.

This logic seems flawless and satisfies all criteria required. It also returns "Barcalays" or "Barcalays ".

Also doesnt match Tristate capital and Barcalays capital together because the search for character is always beginning from the first charater of the string which is Barcalays and not capital.

And yes the entire thing should be case insensitive.

Hope I was able to explain in an understandable way. The logic SEEMS easily implementable but the actual work is finding the right set of combinations of DAX to do so.