Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!69.16.185.16.MISMATCH!npeer02.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
From: Jimmy <jimmy_please@yahoo.com>
Newsgroups: comp.lang.java.programmer
Subject: need regular expression to replace part of result based on a search pattern
Date: Wed, 11 Jul 2012 10:35:05 -0700 (PDT)
Organization: http://groups.google.com
Lines: 18
Message-ID: <6aefda61-b66a-4e8f-8634-ef6a95f79c4d@googlegroups.com>
NNTP-Posting-Host: 207.35.172.194
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1342028230 10950 127.0.0.1 (11 Jul 2012 17:37:10 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 11 Jul 2012 17:37:10 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=207.35.172.194; posting-account=hbXCpAkAAABa-dLY0VSvLdcbLPQ0JRkU
User-Agent: G2/1.0
X-Received-Bytes: 1420
Xref: csiph.com comp.lang.java.programmer:15942

Have been having hard time to come up with the regular expression to replace the following..

1,"blaha",NULL,'N','Y','N','N',NULL
2,"blahb",NULL,'Y','Y','Y','N',NULL
3,"blahc",NULL,'N','N','N','N',NULL
                        ^

With all contents in column #6 (first column is column #1) to 'Y'?

i.e. result

1,"blaha",NULL,'N','Y','Y','N',NULL
2,"blahb",NULL,'Y','Y','Y','N',NULL
3,"blahc",NULL,'N','N','Y','N',NULL
                        ^

Thanks,
Jimmy