AARoads Forum

Please login or register.

Login with username, password and session length
Advanced search  

News:

Due to a threat of legal action were forced to take the forum offline to expunge a number of posts from a banned user. We are working to resolve the database situation and restore the forum to full functionality as soon as possible.

Author Topic: Script to convert a CSV to a forum BBCode table  (Read 680 times)

Scott5114

  • *
  • *
  • Offline Offline

  • Posts: 18997
  • Nit picker of unprecedented pedantry

  • Age: 33
  • Location: Norman, OK
  • Last Login: Today at 07:10:21 AM
    • Denexa 100% Plastic Playing Cards
Script to convert a CSV to a forum BBCode table
« on: January 29, 2023, 09:06:12 PM »

Who knows if anyone else but me will ever find this useful, but, hey, if you do, knock yourself out.

No guarantees this does anything right. Licensed under whatever the latest GPL is whenever you read this.

Code: [Select]
#!/usr/bin/perl

use Text::CSV;
use strict;

# CSV parse object
my $csv = Text::CSV->new ({
  binary    => 1,
  auto_diag => 1,
  sep_char  => ','    # not really needed as this is the default
});

my $file = $ARGV[0] or die "No CSV file specified\n"; # Path to CSV file
open(my $data, "<", $file) or die "Could not open '$file' $!\n"; # Open file

print "[table]\n";

# Read file in line by line.
while (my $line = <$data>)
{
    print "[tr]";
   
    chomp $line;
   
    if ($csv->parse($line))
    {
        my @fields = $csv->fields();
       
        foreach(@fields)
        {
            print "[td]";
            print $_;
            print "[/td]";
        }
    }
    print "[/tr]\n";
}

print "[/table]\n";
Logged

kurumi

  • *
  • Offline Offline

  • Posts: 2499
  • Location: Cupertino, CA
  • Last Login: Today at 01:58:56 PM
    • kurumi.com
Re: Script to convert a CSV to a forum BBCode table
« Reply #1 on: January 29, 2023, 11:25:10 PM »

It's good to see well-written Perl in the wild. Bookmarked.
Logged
My first SF/horror short story collection is available: "Young Man, Open Your Winter Eye"

Scott5114

  • *
  • *
  • Offline Offline

  • Posts: 18997
  • Nit picker of unprecedented pedantry

  • Age: 33
  • Location: Norman, OK
  • Last Login: Today at 07:10:21 AM
    • Denexa 100% Plastic Playing Cards
Re: Script to convert a CSV to a forum BBCode table
« Reply #2 on: January 29, 2023, 11:45:00 PM »

Calling my code well-written warms my heart. Thanks. :)
Logged

 


Opinions expressed here on belong solely to the poster and do not represent or reflect the opinions or beliefs of AARoads, its creators and/or associates.