Forum Discussion
Solved
TextSplit
Hi, I have this string where I have succesfully grabed, adults, children and infants. This has been done by this formula by a fellow community member: List.Sum(List.Transform(Lis...
You can use following formula for everything here. Just replace "market_code by say adults etc.
= try Text.Split(List.RemoveNulls(List.Transform(Text.Split(Text.Remove([metadata],""""),","),(x)=>if Text.Contains(x,"market_code") then x else null)){0},":"){1} otherwise null
You can use following formula for everything here. Just replace "market_code by say adults etc.
= try Text.Split(List.RemoveNulls(List.Transform(Text.Split(Text.Remove([metadata],""""),","),(x)=>if Text.Contains(x,"market_code") then x else null)){0},":"){1} otherwise null
Thank you so much Vijay for your fast response - This is awesome! 🙂