Curious that you’re not doing that in your SQL query, but I’m assuming you want to do that using Find/Replace in Notepad. Other assumptions: 2) The column divider appears to be a space, but also could be a tab. 3) The words in the Name column will always begin with a letter and never a number (for example, this value would not be present in the Name column: Auto 1CF Asset Pricing Procedure). 4) Only a single space separates the words in the Name column. 5) The ROW_ID column will always begin with a single digit and a hyphen and will never contain spaces. This could be incorrect, but based on your sample data, that seems reasonable.
So with your output open in Notepad++, open the Replace dialog (Ctrl+H works) and click the bottom radio button Regular expression. Also make sure the Match case checkbox is not checked. You’ll need to do 2 Replace operations. First, paste the next line into the Find what box:
[ ]([a-z]\S+)
(?# Space followed by letter followed by non-space chars)
and paste this into the Replace with box:
_spc\1
(?# _spc followed by stuff in parentheses)
Click the Replace All button and it should replace all spaces, except for the ones in front of the second column, with _spc.
Then paste this into the Find what box:
[ \t]+(\d-\S+)
(?# 1 or more spaces or tabs followed by a digit then a hypen then non-space chars)
and paste this into the Replace with box:
=“\1”
(?# =" followed by stuff in parentheses then by ")
Click the Replace All button and it should replace all spaces before column 2 with =" and put a " after the value.
Obviously, check the result to make sure the assumptions were correct and nothing unexpected happened, but that should get you the result from your example.
