Regular Expressions 101

^start of line

Group 1(\w+)

\w+any word character, repeated at least once

\s+any whitespace character, repeated at least once

Group 2([\w-]+)

Character Class[\w-]+

+matches at least one character from the set below:

\wany word character

-the literal - (45₁₀ / 55₈ / 2D₁₆)

$end of line

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

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

^(\w+)\s+([\w-]+)$\n

New

5067235721	24-FEB-16
5067245417	24-FEB-16
5067212004	10-FEB-16
5067148322	22-FEB-16
5067148330	19-FEB-16
5067148349	17-FEB-16
5067148357	17-FEB-16
5067148365	18-FEB-16
5067148373	17-FEB-16
5067148284	23-FEB-16
5067148292	23-FEB-16
5067148306	23-FEB-16

Substitution

  select \1, to_date('\2') from dual;\nunion\n