Forum Discussion
How to extract continuous string set from a column with multiple criteria
Anonymous - OK, I updated this with a Client Name output version and Project output version in 2 additional columns. I checked the matches, don't see anything obviously amiss. Solved?
PBIX is attached.
Anonymous - So, yes, we can return the entire matching project, that we can do. I will see what I can do with that. The problem with Blue Cross is that the client names are so long that it ends up not meeting the threshold requirements for a match. I may be able to adjust those. So, for example
Blue Cross and Blue Shield of Arizona I
Matches 11 out of like 40 characters or .275% This makes it fall below thresholds set to filter out other stuff. The Ernst & Young entry for Blue Cross is even worse.
Greg_DecklerI have attached the current list of client names for your reference. You could use this list in your working file if it is convenient.
Anonymous - I will take a look.
Anonymous - OK, I updated this with a Client Name output version and Project output version in 2 additional columns. I checked the matches, don't see anything obviously amiss. Solved?
PBIX is attached.
Anonymous Glad we got there, was an interesting problem. There are still replies in this thread you haven't kudo'd... 🙂
This may be my record for longest thread before solution, 6 pages!!!
Greg_DecklerGenius!! Thank you so much for this. You have literally spared me a grave headache. Wish I could give you a dozen Kudos haha!! Peace!
Hi Greg, pleasure in greeting you... 2 queries:
1. Does the Microsoft Power BI Cookcbook (2nd Edition) have a Spanish version?
2. In the book, will you have cases to identify ranges of text and texts with momodines?
Example, if I have the value "AC23", "AJ80" and "KRZ600".
Number Since Until Caso1 AB01 AJ70 Caso2 A* J* Caso3 KRZ600 AC23 = Case1 and Case2
AJ80 = Caso2
KRZ600 = Caso3
Thanks and greetings...
