Training, Open Source computer languages
PerlPHPPythonMySQLApache / TomcatTclRubyJavaC and C++LinuxCSS 
Search for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact
Removing blank columns in csv file

Posted by nano (nano), 1 November 2005
Hi ,

Using the following to create a CSV (comma seperated value) file
my $delim = ",";
printf " %s%s%s%s\n" $colA,$colB,$delim, $delim,$colE;

Now i don't want to see empty columns for C, and D Does anyone know if you can hide /remove empty columns in a CSV file

Thanks ,



Posted by Custard (Custard), 1 November 2005
Hey!

Not exactly sure by 'i don't want to see empty columns for C, and D'.
Do you mean you want

A,B,E

instead of

A,B,,,E

?


As for your existing code, why not use an array, and 'join'.

Code:
my $delim=',';
my @data=($colA,$colB,$colE);
print join( $delim, @data )."\n";


A bit more flexible, and maybe does what you want.

B



This page is a thread posted to the opentalk forum at www.opentalk.org.uk and archived here for reference. To jump to the archive index please follow this link.

You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2014: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho