Formatting Values for SQL via Notepad++

Formatting Values for Insert in Notepad++

Find what: (\d+)(\t)(\w+)(\t)(\w+)
Replace with: ,\($1, '$3', '$5'\)

Remove comma from beginning of first line

Explanation:

In the Find, the parentheses group the matches:

Grp1   Grp2  Grp3   Grp4  Grp5
(\d+)  (\t)  (\w+)  (\t)  (\w+)
1      [tab] af03b2 [tab] EPIC_CLARITY
2      [tab] 3cd8e5 [tab] EPIC_CLARITY

The replace fills in the parentheses, commas and quotes around the non-tab groups which are $1, $2 and $3 which gives us this:

,(1, 'af03b2', 'EPIC_CLARITY')
,(2, '3cd8e5', 'EPIC_CLARITY')