Help to arrange text??

Parkourfinger

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 :

Name:Mourat
Age:65
Work:Carpenter

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

Mourat|65|Carpenter

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 :)

guy038

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 :

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

Parkourfinger

@guy038 Thank you very much it worked!