Amend formula

[chiragpatel_1]

Hi ,

I  have the below formula, I want to amend part of it, so that it picks out letters before the first number. How would i do that?

IF REGEX_Match([Outcode], '\d+') THEN [Outcode]
ELSE REGEX_Replace([Outcode], '\d', '')
ENDIF

thank you

[binuacs]

@chiragpatel_1 @Can you provide a sample data and explain what you are trying to achieve? 

[chiragpatel_1]

for example there is a cell in outcode column which is CH639HP, currently that is being outputed as CHHP , i wan the formula to only output CH

[binuacs]

@chiragpatel_1 

IF REGEX_Match([Outcode], '^\D.+') THEN
 REGEX_Replace([Outcode], '(.\D+)\d.*', '$1')

ELSE

[Outcode]
ENDIF