Modify your data using perl snippets
-Experimental REPL console supports perl snippets which get $rec hash which is one
+Experimental REPL console supports perl snippets which get $row hash which is one
element from your dataset. All values are repetable, so you always have to create
array of values if you are creating new columns, even for single value.
* generate new columns with number of elements in some other column
- $rec->{count} = [ $#{ $rec->{original} } + 1 ];
+ $row->{author_count} = [ $#{ $row->{autor} } + 1 ];
* generate century column from year
- foreach my $year ( @{ $rec->{Year} } ) {
- push @{ $rec->{century} }, int($year/100)+1;
+ foreach my $year ( @{ $row->{Year} } ) {
+ push @{ $row->{century} }, int($year/100)+1;
}
+* modify existing column
+
+ foreach ( @{ $rec->{'Cited Author'} } ) {
+ s/^\.+//;
+ $_ = uc $_; # assigment is needed to modify value!
+ }
+
+Code examples are stored in public/code
+
+They use Column name.description.pl notatition so only snippets which have applicable
+column will be shown.