First letter from a string after 'The' or special characters

Question

Hi, I'm bringing in some data like the below and having a difficult time getting the expected output.

nameexpectedOutputThe Name TestN-Company NameC

(k)Name, LLCkTestT4 Your Test4

Using the below formula, I'm able to get all of the expected outputs except for the last one that starts with a number

if StartsWith([name],'the') then Substring([name],4,1)
elseif (REGEX_Match([name],'[a-zA-Z].*') or REGEX_Match([name],'\d.*[a-zA-Z]') = 1) then Substring([name],0,1)
else Substring([name],1,1)
endif

TEST OUTPUT:

nameTEST OutputThe Name TestN-Company NameC(k)Name, LLCkTestT4 Your Test

Not sure what I'm missing.  TIA

ChrisTX · Accepted Answer

In your second REGEX_Match you have " = 1"

Remove the = 1 and it works fine.