SAGA.table_tools.24: Formatted Text

With this tool you can create new text field contents from the contents of other fields. To address other field's contents you have some format options as listed below.<br/>Fields are addressed either by their zero based column number or by their name.<br/>If the use <i>no-data flag</i> is unchecked and a no-data value appears in a record's input fields, the result will be an empty text string.<br/>Field contents can be combined using the '+' operator. Free text arguments have to be added in quota.<br/>A simple example:<br/><i>"No. " + index(1) + ": the value of '" + upper(0) + "' is " + number(1, 2)</i><br/><table border="0"><tr><td><b>index(offset = 0)</b></td><td>record's index</td></tr><tr><td><b>string(field)</b></td><td>field's content as it is</td></tr><tr><td><b>lower(field)</b></td><td>field's content as lower case text</td></tr><tr><td><b>upper(field)</b></td><td>field's content as upper case text</td></tr><tr><td><b>integer(field)</b></td><td>field's content as integer number</td></tr><tr><td><b>real(field, precision)</b></td><td>field's content as real number with optional precision argument</td></tr></table>

Inputs

Table

format
href
Please set a value for TABLE.

Field

format
href
Please set a value for FIELD.

Field Name

string

Format

string

Selection

boolean

Use No-Data

boolean

Outputs

Result

format
transmission

Execution options

successUri
inProgressUri
failedUri

format

mode

Execute End Point

View the execution endpoint of a process.

View the alternative version in HTML.

{"id": "SAGA.table_tools.24", "title": "Formatted Text", "description": "With this tool you can create new text field contents from the contents of other fields. To address other field's contents you have some format options as listed below.<br/>Fields are addressed either by their zero based column number or by their name.<br/>If the use <i>no-data flag</i> is unchecked and a no-data value appears in a record's input fields, the result will be an empty text string.<br/>Field contents can be combined using the '+' operator. Free text arguments have to be added in quota.<br/>A simple example:<br/><i>\"No. \" + index(1) + \": the value of '\" + upper(0) + \"' is \" + number(1, 2)</i><br/><table border=\"0\"><tr><td><b>index(offset = 0)</b></td><td>record's index</td></tr><tr><td><b>string(field)</b></td><td>field's content as it is</td></tr><tr><td><b>lower(field)</b></td><td>field's content as lower case text</td></tr><tr><td><b>upper(field)</b></td><td>field's content as upper case text</td></tr><tr><td><b>integer(field)</b></td><td>field's content as integer number</td></tr><tr><td><b>real(field, precision)</b></td><td>field's content as real number with optional precision argument</td></tr></table>", "version": "1.0.0", "jobControlOptions": ["sync-execute", "async-execute", "dismiss"], "outputTransmission": ["value", "reference"], "links": [{"rel": "http://www.opengis.net/def/rel/ogc/1.0/execute", "type": "application/json", "title": "Execute End Point", "href": "http://tb17.geolabs.fr:8119/ogc-api/processes/SAGA.table_tools.24/execution"}, {"rel": "alternate", "type": "text/html", "title": "Execute End Point", "href": "http://tb17.geolabs.fr:8119/ogc-api/processes/SAGA.table_tools.24/execution.html"}], "inputs": {"TABLE": {"title": "Table", "description": "Table", "extended-schema": {"oneOf": [{"allOf": [{"$ref": "http://zoo-project.org/dl/link.json"}, {"type": "object", "properties": {"type": {"enum": ["text/csv", "text/csv"]}}}]}, {"type": "object", "required": ["value"], "properties": {"value": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/csv"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "text/csv"}]}}}]}, "schema": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/csv"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "text/csv"}]}, "id": "TABLE"}, "FIELD": {"title": "Field", "description": "Field", "extended-schema": {"oneOf": [{"allOf": [{"$ref": "http://zoo-project.org/dl/link.json"}, {"type": "object", "properties": {"type": {"enum": ["text/csv", "text/csv"]}}}]}, {"type": "object", "required": ["value"], "properties": {"value": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/csv"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "text/csv"}]}}}], "nullable": true}, "schema": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/csv"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "text/csv"}]}, "id": "FIELD"}, "NAME": {"title": "Field Name", "description": "Field Name", "schema": {"type": "string", "default": "New Field", "nullable": true}, "id": "NAME"}, "FORMAT": {"title": "Format", "description": "Format", "schema": {"type": "string", "default": "\"Index: \" + index(1)", "nullable": true}, "id": "FORMAT"}, "SELECTION": {"title": "Selection", "description": "Selection", "schema": {"type": "boolean", "default": false, "enum": ["true", "false"], "nullable": true}, "id": "SELECTION"}, "USE_NODATA": {"title": "Use No-Data", "description": "Use No-Data", "schema": {"type": "boolean", "default": false, "enum": ["true", "false"], "nullable": true}, "id": "USE_NODATA"}}, "outputs": {"RESULT": {"title": "Result", "description": "Result", "extended-schema": {"oneOf": [{"allOf": [{"$ref": "http://zoo-project.org/dl/link.json"}, {"type": "object", "properties": {"type": {"enum": ["text/csv", "text/csv"]}}}]}, {"type": "object", "required": ["value"], "properties": {"value": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/csv"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "text/csv"}]}}}]}, "schema": {"oneOf": [{"type": "string", "contentEncoding": "utf-8", "contentMediaType": "text/csv"}, {"type": "string", "contentEncoding": "base64", "contentMediaType": "text/csv"}]}, "id": "RESULT"}}}

http://tb17.geolabs.fr:8119/ogc-api/processes/SAGA.table_tools.24.html
Last modified: Sat Feb 19 15:43:34 CET 2022