Two sed and 5 AWK methods for doing this re-formatting job are explained here, including a surprisingly simple trick that requires GNU AWK 4.2 or later.

Source: LXer – Re-format blah,YYYYMMDD,blah as blah,YYYY,MM,DD,blah