I want to sort some items in alphabetic order, but in a very specifc way.
I have, for example, the following list, each item separated by comma:
monkeys, big dogs, cats pineapple, banana, orange yellow, red, blue, green silver, gold, platinum delphi, java, c++, visual basic
An item here is defined by the piece of text: 1. starting in the beginning of a line and ended right before the first comma; 2. surrounded by commas and 3. starting right after the last comma and ending ate the end of line. So spaces are not separators, as in "big dogs" forms a single item.
I want to sort each line alphabetically, WITHOUT changing line order.
My desired result would be:
big dogs, cats, monkeys banana, orange, pineapple blue, green, red, yellow gold, platinum, silver c++, delphi, java, visual basic
My target list has got 3000+ lines, so it should be an automated process.