How can one parse multiple twitter handles and the actual text using RegEx?

[Smckenna]

I am a very new student to Alteryx and am trying to use RegEx to help parse information I have from Twitter.  I captured text from a twitter account and need to parse out the twitter handle and text.  Some of the tweets have multiple names to the one text. 

For example:

@NiceKid @greatnephew @nannaT Can't wait to see you in Florida!

I have rows of tweets of varying lengths, some with none, one or more "@"names and then text (or emoji).  So There is no distinct pattern, other than the tweet handles start with "@".

How can I parse out the @handles from the text using RegEx?

Thank you in advance!

[MarqueeCrew]

Add a RecordID to each row.  Take the data into a RegEx tool:

Expression:  @\w+

TOKENIZE:

Split to Rows

Cheers,

Mark

[echuong1 · Accepted solution]

See attached for example. I essentially parsed out the handles to separate lines and also the text from the tweet. From there I joined them back together.

Let me know if that works!

[Smckenna]

That worked well to separate out the twitter handles in each "text" and creating new records but it removed the text information in that column rather than parsing the text into a new column.

[Smckenna]

That's it!   Thank you, echuong1!