string formatting?

is there a way to format a string - i am using both assoc arrays and sql queries to feed MergeBlock calls - for some string results i want to limit the number of characters printed to a certain number in a column (for instance, 20 characters for a news item listing i have) - witih the arrays i could process them before calling merge - for the sql queries i dont get the results so i cannot change the strings first

- is there a way to do this with the frm command? if not, how can this be done - thanks

Hi PowerPop,

Parameter 'max' enables you to limits the number of characters.
But it adds '...' when string is cut.

Parameter 'frm' is only for date and numeric values.

Otherwise, you can use parameter 'onformat' on a field, or 'onsection' on a block to edit values before display them.