How to parse a column

[clarrock]

eHi,

Below is my input data

Vehicle	Notes	Flag
CAR	abc1234 abc345	Yes
BUS	abc78908 2344 capture abc785	No

I want to parse my notes column such that anything with the term "abc+number" (ideally ignore anyother number and text like "capture" and "2344" creates a new record with the same vehicle and flag and only the number

This is my desired output

Vehicle	Notes	Flag
CAR	1234	Yes
CAR	345	Yes
BUS	78908	No
BUS	785	No

Is this possible on Alteryx?

[caltang · Accepted solution]

Here you go:

[flying008]

Hi, @clarrock 

FYI. if you only want get number after 'abc', then use expression (?<=abc)\d+