Math functions

“>”, “<“, “+”, “-“, “*”, “/”, “%”, Round(), Mod(), etc. – to modify numerical values in custom columns – e.g. extract size/location, then use Round() or Mod() to align object’s size/location to the grid.

String manipulation

  • Concatenate/Join – combining contents of different columns into a new column – for custom reports or export – XML/HTML/SQL/ePUB, etc.
  • Split – to split text into parts in order to extract partial information – e.g. split address in order to get Street or City for sorting or indexing
  • Replace – for a direct manipulation of the contents of the columns
  • Find – already done for filtering columns – but in this case, it could be used for other purposes – e.g. process current object in a specific way if part of the Label matches

Custom columns

Option to add new/custom columns in order to store a new information – or combination/part of already available text:

  • for extra sorting by part of the contents of the column – extract City from the full address or split object’s Label,
  • for grouping,
  • to use Math functions -e.g. MODulo(2) to get even/odd values and sort/filter,

DataMerge

Assigning Tasks to columns/fields – this way, each column/field in the DataBase can be processed differently.

In the built-in DataMerge, you can only place text or image – in ID-Tasker you can assign specific Task to the column and execute extra operations before/after or based on the contents of the field – e.g. automatically process extra taggin, fit text, resize images, etc. – do things that you would normally have to do AFTER DataMerge is finished. Also, this can have a direct effect on the contents during import of the data.

Extra Tasks for 1st/last column/row – e.g. you have a database, where each product is made from multiple records – 1st record have title, image, description and next N-records have contents for the Table or you need to import more than one image – but you don’t want to create extra placeholders for images in your template. Or when new product starts – you need to perform extra operations – select new template or location. Same when product ends – do extra formatting based on number of imported rows in the Table or number of images.

XML Manipulation

In ID-Tasker, XML is treated as a database where Root level Elements are records and then all sub-Elements are treated as fields – shown as columns.

Thanks to this – Task can be assigned to a specific Tag / Element.

Custom Reports / Exports

Thanks to Custom Columns it’s extremely easy to create custom reports – number & size of used images / number of words/characters / cited authors / etc.

In case of custom XML / HTML / SQL / ePUB export – it would be very easy to add custom tags, extract & add attributes to each object.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.