Forum Discussion
Solved
How to isolate text or numbers trailing a particular text string
Hey good people, I am trying to get the pack number from a table as below : Towards this end, I wrote a code as below, which works part of the way : if Text.Contains([Title],"pack"...
Test this and let me know if there is any exception. If yes, I will need that data where you get exception
try Number.From(Text.Split(Text.Split([Title],"Pack of"){1}," "){1}) otherwise 1
What is the expected answer for these scenarios when following appears at the end
Pack of
Pack of 3 x 150gms
Pack of 2 (2 x 150 gms)