Forum Discussion
Get Week number from Source name value using Mcode
Hi, I hope to get week number after right-most delimiter '_' which the result will be 'W35'. Also wanna know how I can get only number such '35' as well.
Heyy Anonymous
Please try this
Text.BeforeDelimiter( Text.AfterDelimiter([Column1], "_", 1), ".",0)
If it helps please Kudos To Work and Accept it as Solution.Heyy @jeongkim
Please try this
Text.End( Text.BeforeDelimiter( Text.AfterDelimiter([Column1], "_", 1), ".",0),2)
If it helps please Kudos To Work and Accept it as Solution.Hi Anonymous
In the GUI, go to either Transform or Add Column tab, select Extract then Between Delimiters.
Hi, I need only W35 and 35 without '.xlsx' please
Heyy @jeongkim
Please try this
Text.End( Text.BeforeDelimiter( Text.AfterDelimiter([Column1], "_", 1), ".",0),2)
If it helps please Kudos To Work and Accept it as Solution.