Hi JC, Added Text.Upper() inside the M Code, in the query will convert both contacts and match lookup all in Upper Case, as for output I am not ...
Hi JC, not sure this is what you want create a lookup and input all the keywords of your contact description (Air France, Air UK etc), bring t...
Hi Philip, Thanks for all your help Can you briefing explain the codes and I will try to digest and understand it, so far didn't code (don't k...
Hi Philip Really appreciate your effort in building a custom PQ function, I think space, "-", "_" scenario you script didn't take into consideratio...
Hi Mynda, in my Excel 2019 desktop version Expression.Error: The name "Splitter.SplitTextByCharacterTransition" wasn't recognized. Make sure it...
Hi Sunny, Thanks for your solution, and using native excel will take very long to process the formulae, and also the original raw pattern may hav...
Hi Mynda, Attached sample of dataset first tab was using O365 non-digit to digit which was quite ideal but unfortunate all my user don't have O3...
Hi Mynda, Thanks for your reply and this is one workaround, however I got the following pattern and others ABC_BLK-234ROOF-ARCH-1 BLK234 is w...
Hi Catalin, Ooh yah, so before all the delimiters of strings definitely is blank white space Thank you so much !!
Hi Catalin, Is it because the other two do no have prefix attached to it so we need to specify {0, RelativePosition.FromEnd} ? anyway it works ...
Hi Catalin, Attached is my complete codes actually what I hope to achieve is whenever there is any changes in the source header, for e.g. rena...
Hi Catalin, This #"Added Custom" is current year in yy format, there will be next year and previous year, this query ultimate goal is to final...