StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>The problem is complex, but it's not unsolvable. It seems to me that course will always contain a space between the alpha code and the numeric code and that the prof names will also always contain a space. But then you're pretty much screwed if somebody has a two-part last name like "VAN DYKE".</p> <p>A regex would describe this record:</p> <pre><code>my $record_exp = qr{ ^ \s* (\d{4}/\d{2}) # yyyy/mm date \s+ (\d+) # any number of digits \s+ (\S+ \s \S+) # non-space cluster, single space, non-space cluster \s+ # sames as last, possibly not there, separating spaces are included # in the conditional, because we have to make sure it will start # right at the next rule. (?:(\S+ \s \S+)\s+)? # a cluster of alpha, single space, cluster of digits (\p{Alpha}+ \s \d+) \s+ # any number of spaces (\S+) # any number of non-space \s+ # ditto.. (\S+) \s+ (\S+) }x; </code></pre> <p>Which makes the loop a lot easier: </p> <pre><code>while ( <$input> ) { my @fields = m{$record_exp}; # ... list of semantic actions here... } </code></pre> <p>But you could also store it into structures, knowing that the only variable part of the data is the profs: </p> <pre><code>use strict; use warnings; my @records; <$input>; # bleed the first line while ( <$input> ) { my @fields = split; # split on white-space my $record = { date => shift @fields }; $record->{session} = shift @fields; $record->{profs} = [ join( ' ', splice( @fields, 0, 2 )) ]; while ( @fields > 5 ) { push @{ $record->{profs} }, join( ' ', splice( @fields, 0, 2 )); } $record->{course} = splice( @fields, 0, 2 ); @$record{ qw<sec grade count> } = @fields; push @records, $record; } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload