Forum Discussion
monojchakrab
Resolver III
Resolver IIIHow 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
monojchakrabResolver III
Resolver IIIVijay_A_Verma - Thanks for the quick revert.
However , the formula is probably not playing out fully and returning this error :
[Expression.Error] There weren't enough elements in the enumeration to complete the operation.
How can I send you a link for the [Title] Column from the table?
monojchakrabResolver III
Resolver IIIVijay_A_Verma - Vijay, I ran it again, and this time it worked. I most certainly used "" instead of " ", by oversight. Thanks a lot.