[thelist] Dreamweaver REGEX Find and Replace help.

[Jon Hughes]

I have the following in a comma-delimited plaintext file.


Item1, item2, item3
"Add #84FD. to this item","Put 7 #HH23. to this item,"Needs 9 #HH47."

I am trying to make it this:

Item1, item2, item3
"#84FD","#HH23","#HH47"


The logic:
Find everything from ',"' parens around anything starting with a # + 4
characters, continue finding until '",' replace all with ',"$1",'

After about 45 mins, this is all I have...

,.+#(.+ ).+, which doesn't work at all :)

Anyone know how to achieve this?

Thank You,
- Jon Hughes