Count characters in a value in XML Tag in XML(BI Publisher)


To count the number of characters in a string in XML Publisher RTF.
string-length(XML TAG STRING)
Example of the usage in RTF template :

<?if:string-length(LIST_PRICE)> 5?> value <?end if?>

Here it returns the length of the string LIST_PRICE(XML tag used in the RTF template)





No comments:

Post a Comment

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...