Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a database dump, looking like this:

;i:23;s:18:"Product Name1";i:24;s:27:"Product Name2";i:25;s:15:"Product Name3"; [...]

All I'd like to get in Notepad++ is this:

Product Name1,Product Name2,Product Name3

What regex should I use for search and replace in Notepad++? The closest I've gotten is ^"."$ but this does not find the string.

share|improve this question
what have you tired ? You wont find people very helping if you don't show some effort on your part – Shekhar Oct 16 '13 at 20:36
This is the first time I try to use it... now learning it from but I need quick help. Anyway, if this is the rule here, I'll try to get a solution myself :) – bacizone Oct 16 '13 at 20:48
Tried this all character between the quotation marks ^"."$ but this one does not include the " and does not find the string – bacizone Oct 16 '13 at 21:15
That's because you're matching the whole line with one char in quotes... – Radoo Oct 16 '13 at 21:19

Try this...

Find (check Regular Expressions): i:\d+;s:\d+:"([\w\s]+)";

and Replace with: \1,

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.