regex101: Python Match Workspace

Pro

Group 1([^:\s]+)

Negated Character Class[^:\s]+

+matches at least one character outside the set below:

:the literal : (58₁₀ / 72₈ / 3A₁₆)

\sa Unicode whitespace character

:the literal : (58₁₀ / 72₈ / 3A₁₆)

Group 2([^:]+)

Negated Character Class[^:]+

+matches at least one character outside the set below:

:the literal : (58₁₀ / 72₈ / 3A₁₆)

$end of line

Global pattern flags

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

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

25 tokens

Regular Expression

([^:\s]+):([^:]+)$

Employee,Table:
Name,Description,Type
Bob,Employee,Standard
Jim,Employee,Standard
james,Employee,Standard


Tools:
Item,Serial,Tag
Battery,0101,B.
Drill,9292,D.
Phone,8464,P.

Locations:
Station,code,len
West,12,9
North,1,9
East,21,9

Extraction

Employee,Table:
Name,Description,Type
Bob,Employee,Standard
Jim,Employee,Standard
james,Employee,Standard


Tools:
Item,Serial,Tag
Battery,0101,B.
Drill,9292,D.
Phone,8464,P.

Locations:
Station,code,len
West,12,9
North,1,9
East,21,9