M Code to extract between characters that are not same position

[ysherriff]

Hi all,

Does anyone know how to extract the year from this text string? I trired "Text Extraction" and "Delimiter" but it is not coming out the way I want.

I want the year in one column but I am also showing "Gen".

Thank you for your help

[Daryl-Lynch-Bzy]

Hi @ysherriff - you could try something like Text.Remove - PowerQuery M | Microsoft Learn or Text.Select - PowerQuery M | Microsoft Learn

Select = Text.Select( [Text] , {"0".."9"} )
Remove = Text.Remove( [Text] , {"a".."z", "A".."Z"})

[ysherriff · Accepted solution]

Thank you but this solution works


List.RemoveNulls (
List.Transform (
Text.Split ( _[Campaign Name], "-" ),
each try Number.From ( _ ) otherwise null
)
){0}