semicolon

Question

i have written the expression rule to show the data in table. but how to remove these semicolons from the table

a!localVariables(
  local!contractData: rule!generatecontracttable(
    cif_int: ri!cif_int
  ),
  local!rowItemsdata: {
    "<tr>
<th class=""left"">" & index(
      local!contractData.value_txt,
      wherecontains(
        1,
        tointeger(
          local!contractData.extensionRefId_int
        )
      ),
      {}
    ),
    "</th>
<td class=""left"">" & index(
      local!contractData.value_txt,
      wherecontains(
        5,
        tointeger(
          local!contractData.extensionRefId_int
        )
      ),
      {}
    ),
    "</td>
<td class=""left"">" & index(
      local!contractData.value_txt,
      wherecontains(
        6,
        tointeger(
          local!contractData.extensionRefId_int
        )
      ),
      {}
    ),
    "</td>
<td class=""left"">" & index(
      local!contractData.value_txt,
      wherecontains(
        7,
        tointeger(
          local!contractData.extensionRefId_int
        )
      ),
      {}
    ),
    "</td>
<td class=""left"">" & index(
      local!contractData.value_txt,
      wherecontains(
        9,
        tointeger(
          local!contractData.extensionRefId_int
        )
      ),
      {}
    ),
    "</td>
<td class=""left"">" & index(
      local!contractData.value_txt,
      wherecontains(
        10,
        tointeger(
          local!contractData.extensionRefId_int
        )
      ),
      {}
    ),
    "</td>
<td class=""left"">" & index(
      local!contractData.value_txt,
      wherecontains(
        11,
        tointeger(
          local!contractData.extensionRefId_int
        )
      ),
      {}
    ),
    "</td>
<td class=""left"">" & index(
      local!contractData.value_txt,
      wherecontains(
        12,
        tointeger(
          local!contractData.extensionRefId_int
        )
      ),
      {}
    ),
    "</td>
<td class=""left"">" & index(
      local!contractData.value_txt,
      wherecontains(
        13,
        tointeger(
          local!contractData.extensionRefId_int
        )
      ),
      {}
    ),
    "</td>
<td class=""left"">" & index(
      local!contractData.value_txt,
      wherecontains(
        15,
        tointeger(
          local!contractData.extensionRefId_int
        )
      ),
      {}
    ),
    "</td>
<td class=""left"">" & index(
      local!contractData.value_txt,
      wherecontains(
        16,
        tointeger(
          local!contractData.extensionRefId_int
        )
      ),
      {}
    ),
    "</td>
</tr>"
  },
  local!rowsSumdata: {
    "<tr>
<th class=""left""> Total </th>
<td class=""left""> </td>
<td class=""left""> " & sum(
      index(
        local!contractData.value_txt,
        wherecontains(
          6,
          tointeger(
            local!contractData.extensionRefId_int
          )
        ),
        {}
      )
    ),
    " </td>
<td class=""left"">" & sum(
      index(
        local!contractData.value_txt,
        wherecontains(
          7,
          tointeger(
            local!contractData.extensionRefId_int
          )
        ),
        {}
      )
    ),
    " </td>
<td class=""left""> </td>
<td class=""left"">" & sum(
      index(
        local!contractData.value_txt,
        wherecontains(
          10,
          tointeger(
            local!contractData.extensionRefId_int
          )
        ),
        {}
      )
    ),
    " </td>
<td class=""left""> </td>
<td class=""left""> </td>
<td class=""left""> </td>
<td class=""left""> </td>
<td class=""left""> </td>
</tr>"
  },
  "<table id=""contractTabe"">
<tr>
<th style=""width:10%"">Contract ID</th>
<th style=""width:10%"">Contract Limit</th>
<th style=""width:10%"">Contract Outstanding</th>
<th style=""width:10%"">Value of Extension sought</th>
<th style=""width:10%"">Capital Amount </th>
<th style=""width:10%"">Interest Amount </th>
<th style=""width:10%"">Current Due Date</th>
<th style=""width:10%"">Days to be Extended </th>
<th style=""width:10%"">New Maturity Date </th>
<th style=""width:10%"">Is interest to be recovered</th>
<th style=""width:10%"">Account for Interest Recovery</th>
</tr>" & local!rowItemsdata & local!rowsSumdata & "
</table>"
)

this is code is generation the table

Contract ID	Contract Limit	Contract Outstanding	Value of Extension sought	Capital Amount	Interest Amount	Current Due Date	Days to be Extended	New Maturity Date	Is interest to be recovered	Account for Interest Recovery

" ) this is code is generation the table

Gabriele Camilli · Answer

Hi, just use stripwith(...,";") or substitute(...,";","")

Mike Schmitt · Answer

Unknown said: I suggest to use the joinarray() function 
 Another nice trick when using an expression rule to generate HTML code like this, is to use a char(10) separator in appropriate places as that creates linebreaks in the generated code (making it easier to read), which is then of course ignored by the HTML interpreter and should thus not affect the eventual rendered HTML table in this case.

semicolon

Top Replies