Modifying markdown display data from essql

Hi,
Have a markdown element.
The data source for which is an essql statement like -->

SELECT * FROM "myJunkIndex" WHERE itemName = 'CategoryA.1' LIMIT 1

In markdown element I display the value of one of the fields in the filtered row(from essql) -->

{{#each rows}}
{{itemInfo}}
{{/each}}

In the above example {{itemInfo}} expression evaluates to a value like "123 x 678 abc"

I was looking for a way to:

  1. Have the value displayed as an upper case value. Example: "123 x 678 ABC"
  2. Also in a separate markdown element with similar data was looking for a way to process the string to only show part of the string. Example: "123 x 678"

Any pointer/examples of how this could be done.
Thank You

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.