Data Formatting



Upper Case/Lower Case

You can populate your data in JSON/XML/JSON in UPPER case or lowercase .

Let's say {Enter_Name} is your text tag. Add the following filters to your text tag.


To populate in upper case add the filter {{Enter_Name | upper}

Similarly, to populate in lower case, use {{Enter_Name | lower}



Format Numbers

Using number formatting filters, you can set thousands separators, decimal separators, and how many decimal places.

{tagname | format_number : "thousand_sep":"decimal_sep":"decimal_place"}

Assuming you are passing 23456789.123456, the following are the results for various filters.



{Number | format_number: ",":"":"1"} -- 23,456,789.1

{Number | format_number: ",":"":"2"} --23,456.789.12

{Number | format_number: ",":"":"3"} -- 23,456,789.123

{Number | format_number: ",":"":"4"} -- 23,456,789.1234


If you want to only place thousands separator, use {Number | format_number: ","}

If you want to convert whole number to a decimal, you can use decimal separator. {Number | format_number: "":".":"2"}

For converting a text value to a number, use {Text | format_number}


Format Date

You can display dates in your chosen format from the universal timestamp in your data file.

"dateOfGeneration": "2023-04-17T09:33:24.613Z"

The date field is shown in the various formats by the tags below.


{dateOfGeneration|format_date:"MM/DD/YYYY"} - 04/17/2023

{dateOfGeneration|format_date:"MM-DD-YYYY"} - 04-17-2023

{dateOfGeneration|format_date:"DD/MM/YYYY"} - 17/04/2023

{dateOfGeneration|format_date:"MMM DD YYYY"} - Apr 17 2023

{dateOfGeneration|format_date:"MMMM DD YYYY"} - April 17 2023

{dateOfGeneration|format_date:"MM/DD/YYYY":"+5"} - 04/22/2023

{dateOfGeneration|format_date:"MM/DD/YYYY":"-5"} - 04/12/2023


Substring

The system supports the Substring function. Let's say you want to remove time from datetime.

"created_Date": "2022-02-01T20:16:14.995Z"

Use the following Substring format to achieve this.


{created_Date.substr(0,10)} displays only the date value in the generated document.


Line Break

The tag for the line break is {\n}. You can also set the size of the line break using tag {\ns1} and you can pass the value for s1 in your data file.


Page Break

The tag for page break is {\p}.