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