Regular Expressions 101

^start of line

Group 1((?:[^\t\n]*\t){3})

Non-Capturing Group(?:[^\t\n]*\t){3}

{3}repeats the group contents below exactly 3 times:

Negated Character Class[^\t\n]*

*matches any number of characters outside the set below:

\ta tab character (ASCII 9)

\na line-feed (newline) character (ASCII 10)

\ta tab character (ASCII 9)

Group 2(.*?)

.*?any Unicode character (except for line terminators), repeated any number of times

Positive Lookahead(?=\t\s*SM)

\ta tab character (ASCII 9)

\s*a Unicode whitespace character, repeated any number of times

SMthe literal text SM (case sensitive)

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

^((?:[^\t\n]*\t){3})(.*?)(?=\t\s*SM)

New

   ID      TO          FROM        BODY                        TYPE  OTHER COLUMNS
    2501	12345678910	12345678910	40m Test Content	 Here.	SMxx  x x x x x x x
    2502	1234567891	1234567891	Varying Content	 Here.	    SMxx  x x x x x x x

Regular Expression

Extraction