Having formatting problems when exporting table from phpMyAdmin
I'm having some trouble in exporting some data directly from phpMyAdmin. I'm selecting a table in phpMyAdmin, from a specific database, and then I'm exporting that table in Excel based CSV format.
The table I'm exporting has 2 columns in it:
Movie Name | Description
Movie Name contains a name, such as Argo. No problems in the movie name. The corresponding entry for Description contains this:
<h2>Product Details</h2>
<ul>
<li><b>Actors:</b> Ben Affleck, Bryan Cranston, Alan Arkin, John Goodman</li>
<li><b>Directors:</b> Ben Affleck</li>
<li><b>Writers:</b> Chris Terrio</li>
<li><b>Producers:</b> Ben Affleck, Grant Heslov, George Clooney, David Klawans, Nina Wolarsky</li>
<li><b>Format:</b> AC-3, Blu-ray, Dolby, NTSC, Subtitled, Widescreen</li>
<li><b>Language:</b> English, Spanish</li>
<li><b>Subtitles:</b> Spanish, Portuguese, French</li>
<li><b>Subtitles for the Hearing Impaired:</b> English</li>
<li><b>Region:</b> Region A/1 (Read more about DVD/Blu-ray formats.)</li>
<li><b>Aspect Ratio:</b> 2.40:1</li>
<li><b>Number of discs:</b> 2</li>
<li><b>Rated: </b> <span class=""medSprite s_medR ""><span>R (Restricted)</span></span></li>
<li><b>Studio:</b> Warner Home Video</li>
<li><b>DVD Release Date:</b> February 19, 2013</li>
<li><b>Run Time:</b> 120 minutes</li>
</ul>
That is, the WHOLE HTML block above is the Description value for that Argo record.
But when I export the above from phpMyAdmin, this is what I see for the Description:
Argo;<h2>Product Details</h2>
<ul>
<li><b>Actors:</b> Ben Affleck Bryan Cranston Alan Arkin John Goodman</li>
<li><b>Directors:</b> Ben Affleck</li>
<li><b>Writers:</b> Chris Terrio</li>
<li><b>Producers:</b> Ben Affleck Grant Heslov George Clooney David Klawans Nina Wolarsky</li>
<li><b>Format:</b> AC-3 Blu-ray Dolby NTSC Subtitled Widescreen</li>
<li><b>Language:</b> English Spanish</li>
<li><b>Subtitles:</b> Spanish Portuguese French</li>
<li><b>Subtitles for the Hearing Impaired:</b> English</li>
<li><b>Region:</b> Region A/1 (Read more about DVD/Blu-ray formats.)</li>
<li><b>Aspect Ratio:</b> 2.40:1</li>
<li><b>Number of discs:</b> 2</li>
<li><b>Rated: </b> <span class="medSprite s_medR "><span>R (Restricted)</span></span></li>
<li><b>Studio:</b> Warner Home Video</li>
<li><b>DVD Release Date:</b> February 19 2013</li>
<li><b>Digital Copy Expiration Date:</b> February 19 2015 (Click here for more information)</li>
<li>&
I'm having some trouble in exporting some data directly from phpMyAdmin. I'm selecting a table in phpMyAdmin, from a specific database, and then I'm exporting that table in Excel based CSV format.
The table I'm exporting has 2 columns in it:
Movie Name | Description
Movie Name contains a name, such as Argo. No problems in the movie name. The corresponding entry for Description contains this:
<h2>Product Details</h2>
<ul>
<li><b>Actors:</b> Ben Affleck, Bryan Cranston, Alan Arkin, John Goodman</li>
<li><b>Directors:</b> Ben Affleck</li>
<li><b>Writers:</b> Chris Terrio</li>
<li><b>Producers:</b> Ben Affleck, Grant Heslov, George Clooney, David Klawans, Nina Wolarsky</li>
<li><b>Format:</b> AC-3, Blu-ray, Dolby, NTSC, Subtitled, Widescreen</li>
<li><b>Language:</b> English, Spanish</li>
<li><b>Subtitles:</b> Spanish, Portuguese, French</li>
<li><b>Subtitles for the Hearing Impaired:</b> English</li>
<li><b>Region:</b> Region A/1 (Read more about DVD/Blu-ray formats.)</li>
<li><b>Aspect Ratio:</b> 2.40:1</li>
<li><b>Number of discs:</b> 2</li>
<li><b>Rated: </b> <span class=""medSprite s_medR ""><span>R (Restricted)</span></span></li>
<li><b>Studio:</b> Warner Home Video</li>
<li><b>DVD Release Date:</b> February 19, 2013</li>
<li><b>Run Time:</b> 120 minutes</li>
</ul>
That is, the WHOLE HTML block above is the Description value for that Argo record.
But when I export the above from phpMyAdmin, this is what I see for the Description:
Argo;<h2>Product Details</h2>
<ul>
<li><b>Actors:</b> Ben Affleck Bryan Cranston Alan Arkin John Goodman</li>
<li><b>Directors:</b> Ben Affleck</li>
<li><b>Writers:</b> Chris Terrio</li>
<li><b>Producers:</b> Ben Affleck Grant Heslov George Clooney David Klawans Nina Wolarsky</li>
<li><b>Format:</b> AC-3 Blu-ray Dolby NTSC Subtitled Widescreen</li>
<li><b>Language:</b> English Spanish</li>
<li><b>Subtitles:</b> Spanish Portuguese French</li>
<li><b>Subtitles for the Hearing Impaired:</b> English</li>
<li><b>Region:</b> Region A/1 (Read more about DVD/Blu-ray formats.)</li>
<li><b>Aspect Ratio:</b> 2.40:1</li>
<li><b>Number of discs:</b> 2</li>
<li><b>Rated: </b> <span class="medSprite s_medR "><span>R (Restricted)</span></span></li>
<li><b>Studio:</b> Warner Home Video</li>
<li><b>DVD Release Date:</b> February 19 2013</li>
<li><b>Digital Copy Expiration Date:</b> February 19 2015 (Click here for more information)</li>
<li>&
No comments:
Post a Comment