Help to arrange text??

  • Hi guys my problem may seems dumb but i was playing with notepad++ for 2 days and still cant seems to find how to do it :(

    So my question is that i have a set of data arranged in raw text like this :


    and Because i have lots of data and for efficient time i would like fo it to be output like :


    Like all info in the same line separated by a | if you know how to do it please let me know would be glady appreciate :)

  • Hello, @parkourfinger and All,

    • If each record consists of 3 consecutive fields only, use this regex S/R :

    SEARCH : (?-s)^.+:(.+)\R.+:(.+)\R.+:(.+)

    REPLACE \1|\2|\3

    • If each record consists of several consecutive fields, use the generic regex S/R :

    SEARCH (?-is)(?:(Title of the Last Field)|.+)Value Separator(.+)\R?

    REPLACE \2?1\r\n:Field Separator

    In this present example as :

    • The Title of the Last Field is the word Work

    • The Value Separator is the : punctuation sign

    • The Field Separator is the | symbol

    Hence the following regex S/R :

    SEARCH (?-is)(?:(Work)|.+):(.+)\R?

    REPLACE \2?1\r\n:|

    As usual, select the Regular expression search mode and tick, preferably, the Wrap around option !

    Best Regards,


  • @guy038 Thank you very much it worked!

Log in to reply