Forum Discussion
Query editor transformation
Hi Anonymous
To catch that last R5 you'll need to do a case insensitive match and then transform the resulting text to Upper Case. The line to do this when you add the custom column is
= Text.Upper(List.First(List.Select(Text.Split([Tag Names], ";"), each Text.Contains(_,"R",Comparer.OrdinalIgnoreCase)))))Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Hi Anonymous
To catch that last R5 you'll need to do a case insensitive match and then transform the resulting text to Upper Case. The line to do this when you add the custom column is
= Text.Upper(List.First(List.Select(Text.Split([Tag Names], ";"), each Text.Contains(_,"R",Comparer.OrdinalIgnoreCase)))))
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Hi Philip,
Thank You. Your calculation works.
Please also do a favour of explaining the solution in parts