Find month number from dataset

[Shaaz]

Hi Team, I've data like below.

Expected Output:

I dont want to write ifelse condition to fix Sept entry rather I'm trying with RegEx_Match

if !REGEX_Match([ID], "[0-9]") then ToNumber(substring(DateTimeParse([ID], "%b"),5,2))
else [ID]
endif

the above formula is failing for entries where we have 10,11,12

[binuacs · Accepted solution]

@Shaaz One way of doing