Regex match string part on specific lines

Question

I need to run advanced find and replace using regex. I have a CSV similar to the following:

"Item 1a,,,,
,,Item 1b,,,,
,,Item 1c"
"Item 2a,,,,
,,Item 2b,,,,"

I need to remove the trailing commas for lines that start with a " quote. I can match the correct lines like so:

(".*?),,,,$

The problem is, that selects the entire row, rather than just the trailing commas.

Anybody know how to match this correctly? so that only the commas are matched, on lines that start with " quote.

Bohemian · Accepted Answer · 2015-09-28 00:29:11Z

1

You are already capturing the content before the commas, just put it all back using a back reference in the replace:

Search: ^(".*?),+$
Replace: $1

Note: You need to anchor you regex to start of line ^ to match a quote there (otherwise it will match a quote anywhere in the line).

edited Sep 28, 2015 at 0:29

answered Sep 28, 2015 at 0:22

Bohemian♦

427k103 gold badges603 silver badges750 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Bohemian Over a year ago

@hwnd but he doesn't want to highlight, he wants to replace the commas with blank to remove them. From OP's question: I need to run advanced find and replace using regex ... to remove the trailing commas for lines that start with a ". OP thinks he has to match only the commas, but this is a solution that works.

hwnd Over a year ago

I get that, it is replacing (only selecting the commas): regex101.com/r/aQ4sI6/2 Bohemian is correct, it's too easy to just backreference the captured group in the replacement.

Collectives™ on Stack Overflow

Regex match string part on specific lines

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related