Blue4509
Blue2034
Yellow2345
Orange2341
Data_Out=Left([Data], Length([Data])-4)
Data
ParseComplex
Data
Warn
Data_Matched
Parse:
([[:alpha:]]+)(\d.+)
Data_Out=REGEX_Replace([Data],"(\l+)\d*","$1")
C:\ProgramData\Alteryx\Engine\Engine_7812_a68b6b5af0ec43d6982616332ff6ec65_\Engine_13016_7b604bdddb1947c597ece09ad5781ef4_.yxdb
C:\ProgramData\Alteryx\Engine\Engine_7812_a68b6b5af0ec43d6982616332ff6ec65_\Engine_13016_b34f8cc39137467a973a521c3c574085_.yxdb
C:\ProgramData\Alteryx\Engine\Engine_7812_a68b6b5af0ec43d6982616332ff6ec65_\Engine_13016_0bde639652dc4ecc95ce699dc9499231_.yxdb
Data_Out=REGEX_Replace([Data],"(\l+)(\d*)","$1 light has a wa...
C:\ProgramData\Alteryx\Engine\Engine_7812_a68b6b5af0ec43d6982616332ff6ec65_\Engine_13016_4da9662ada3e423986fdee0a00c9a821_.yxdb
Option 1
Option 2A
Option 2B
Option 3
Horizontal
TrimRight