Change AWK field separator on the fly
<p>I'd like to use AWK to take the following spread sheet where the first name and last name are in one column:</p>

<pre><code>Peter Griffin, 31 Spooner St, Quahog
Homer Simpson, 732 Evergreen Terr, Springfield
Fred Flintstone, 301 Cobblestone Way, Bedrock
</code></pre>

<p>and output to a new spreadsheet where the first name and last name have their own columns:</p>

<pre><code>Peter, Griffin, 31 Spooner St, Quahog
Homer, Simpson, 732 Evergreen Terr, Springfield
Fred, Flintstone, 301 Cobblestone Way, Bedrock
</code></pre>

<p>I've tried changing field separators on the fly doing something like:</p>

<pre><code>awk '{print $1 "," $2} {FS=","} {print $3} {FS=" "}' spreadsheet.csv
</code></pre>

<p>but it doesn't seem to work that way, and I get a jumbled mess.  Is this possible using AWK?</p>