330448_en-US

liliconcom

Calling regex wizards

Hey people,

 

Who's good with regular expressions? I'm looking to analyze Zoom chat logs with text explorer, and it would be desirable to strip out everything from the word "From" to the first occurrence of ":" during the regex tokenization. Attaching an example data file of the Zoom chat from one of the Discovery US talks.

 

Thanks for the help!

Jordan

Re: Calling regex wizards

Hi,

 

I'm not a regex wizard but somehow I managed to figure it out (see table with regex formula column below):

Regex( :Chat, "From (.*) : (.*)", "\2" )