I need to select strings from a list which starts with ‘R’ and the string should have a digit at second position.
example- R43.1_MAY2012 should be selected but RB_MAY2013 should not be.
I tried below code and added the starts with ‘R’ condition but couldn’t figure out how to add the second position digit condition
let
Source = Excel.Workbook(File.Contents("C:UsersadityaDocumentsTest.xlsx"), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Sheet1_Sheet,{{"Column1", type text}, {"Column2", type text}, {"Column3", type text}}),
#"Added Release" = Table.AddColumn(#"Changed Type", "Release", each let a = List.Transform(Text.Split([Column1], ";"), each Text.Trim(_)),
b = List.Select(a, each Text.StartsWith(_,"R"))
in b{0}?)
in
#"Added Release"