edit
Field values can be edited by using this tag.
Any Ruby function can be used, as long as its on the format field.method
or field[0..3]
.
Multiple methods can be chained, e.g. field.method1.method2
etc.
The edits will be done in the final table, after all the lookups (joins).
Sorting will be done after the edits.
Example
<table>
...
<edit>[0..2]</edit> <!-- extracts country code +47 from +4790011111 -->
<edit>date.in_time_zone</edit> <!-- converts to local time zone -->
<edit>semester.gsub("s1","semester 1")</edit> <!-- semester 1 instead of s1 -->
<edit>grade.gsub(/^.{0}$/,"---")</edit> <!-- If no grade, draw a line -->
<edit>timer.gsub(".0","")</edit> <!-- e.g. 5 instead of 5.0 -->
<edit>location.capitalize</edit> <!-- Trondheim is a city in norway -->
<edit>location.titleize</edit> <!-- Trondheim Is A City In Norway -->
<edit>location.downcase</edit> <!-- trondheim is a city in norway -->
<edit>location.upcase</edit> <!-- TRONDHEIM IS A CITY IN NORWAY -->
Each table and field can have multiple edits, as shown above. Searching on edited fields will currently search in the original data.
Use lowercase when possible