[Solved] Find and Replace for a string in Notepad++ using regular expression

Question

Is that what you want?

Find what: (\w+)?.+?(VARCHAR.+) NULL
Replace with: cast$NULL as $2$ as $1

Don’t forget to escape the parenthesis in the replacement part!

Accepted Answer

Is that what you want?

Find what: (\w+)?.+?(VARCHAR.+) NULL
Replace with: cast$NULL as $2$ as $1

Don’t forget to escape the parenthesis in the replacement part!