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>
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://demo.mapmint.com/ogc-api/processes/SAGA.table_tools.24/execution"}, {"rel": "alternate", "type": "text/html", "title": "Execute End Point", "href": "http://demo.mapmint.com/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": "Champ", "description": "Champ", "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": "Any value", "nullable": true}, "id": "NAME"}, "FORMAT": {"title": "Format", "description": "Format", "schema": {"type": "string", "default": "Any value", "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"}}}
Display original data as JSON
http://demo.mapmint.com/ogc-apihttp://localhost/ogc-api/processes/SAGA.table_tools.24.html
Last modified: Sat Feb 19 15:43:34 CET 2022