Help me with Notepad++



  • I have a result of SQL query with two colums Name and ROW_ID
    For example here is the output I have pasted in notepad++
    Agreement Expire Workflow 1-TD3H3Y
    Auto CF Asset Pricing Procedure 1-TD3H4U
    Auto Complete 1-TD3HBR
    BIP AttachEntity Report Generation 1-TD3HC8
    BIP Create Report Output 1-TD3HEC
    My requirement is to replace space with _spc and the last row_ID should have double quotes. before the ROW_ID it hsould have = sign. For example it should look like this
    Export_spcAssignment_spcData=“1-7ASH7K”
    The actual nam e is Export Assignment Data 1-7ASH7K



  • 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.


Log in to reply