# Field Transformation Operations

A comprehensive list of the operations available in the [Field Tranformation](https://docs.onum.com/the-workspace/pipelines/actions/transformation/field-transformation) Action.

<table data-full-width="false"><thead><tr><th width="186.33333333333331">Operation</th><th width="260">Description</th><th>Example</th></tr></thead><tbody><tr><td><a href="field-transformation-operations/utils/byte-to-human-readable">Byte to human readable</a></td><td>Converts a size in bytes to a human-readable string.</td><td><ul><li><strong>Input data</strong> - <code>"134367"</code></li><li><strong>Output data</strong> - <code>"131.22 KiB"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/compression/bzip2-compress">Bzip2 compress</a></td><td>Compresses data using the bzip2 compression algorithm.</td><td><ul><li><strong>Input data</strong> - <code>"Hello, World!"</code></li><li><strong>Compression Level</strong> - <code>9</code></li><li><strong>Output Format</strong> - <code>Base64</code></li><li><strong>Output data</strong> - <code>"QlpoOTFBWSZTWebY/t8AAAGXgGAEAEAAgAYEkAAgACIjNDahADCbaTwKg3hdyRThQkObY/t8"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/compression/bzip2-decompress">Bzip2 decompress</a></td><td>Decompresses data it using the bzip2 algorithm.</td><td><ul><li><strong>Input data</strong> - <code>"QlpoOTFBWSZTWebY/t8AAAGXgGAEAEAAgAYEkAAgACIjNDahADCbaTwKg3hdyRThQkObY/t8"</code></li><li><strong>Input format</strong> - <code>Base64</code></li><li><strong>Output data</strong> - <code>"Hello, World!"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/conversion/convert-area">Convert area</a></td><td>Converts values from one unit of measurement to another. </td><td><ul><li><strong>Input data</strong> - <code>"134367"</code></li><li><strong>Input units</strong> - <code>"Square foot (sq ft)"</code></li><li><strong>Output units</strong> - <code>"Square metre (sq m)"</code></li><li><strong>Output data</strong> - <code>"464.515215"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/conversion/convert-data-units">Convert data units</a></td><td>Converts a unit of data to another format. </td><td><ul><li><strong>Input data</strong> - <code>"2"</code></li><li><strong>Input units</strong> - <code>"Megabits (Mb)"</code></li><li><strong>Output units</strong> - <code>"Kilobytes (KB)"</code></li><li><strong>Output data</strong> - <code>"250"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/conversion/convert-distance">Convert distance</a></td><td>Converts values from one unit of length to another.</td><td><ul><li><strong>Input data</strong> - <code>"100"</code></li><li><strong>Input units</strong> - <code>"Metres (m)"</code></li><li><strong>Output units</strong> - <code>"Yards (yd)"</code></li><li><strong>Output data</strong> - <code>"109.3613298"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/conversion/convert-mass">Convert mass</a></td><td>Converts values from one unit of mass to another.</td><td><ul><li><strong>Input data</strong> - <code>"100"</code></li><li><strong>Input units</strong> - <code>"Kilogram (kg)"</code></li><li><strong>Output units</strong> - <code>"Pound (lb)"</code></li><li><strong>Output data</strong> - <code>"220.4622622"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/conversion/convert-speed">Convert speed</a></td><td>Converts values from one unit of speed to another.</td><td><ul><li><strong>Input data</strong> - <code>"200"</code></li><li><strong>Input units</strong> - <code>"Kilometres per hour (km/h)"</code></li><li><strong>Output units</strong> - <code>"Miles per hour (mph)"</code></li><li><strong>Output data</strong> - <code>"124.2841804"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/list-manipulation/count-list-boolean">Count list boolean</a></td><td>Counts the number of elements in a list of booleans.</td><td><ul><li><strong>Input data</strong> - <code>true, false</code></li><li><strong>Output data</strong> - <code>2</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/list-manipulation/count-list-float">Count list float</a></td><td>Counts the number of elements in a list of float values.</td><td><ul><li><strong>Input data</strong> - <code>1.5, -2.3, 3.8</code></li><li><strong>Output data</strong> - <code>3</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/list-manipulation/count-list-integer">Count list integer</a></td><td>Counts the number of elements in a list of integer values.</td><td><ul><li><strong>Input data</strong> - <code>10, 20, 30</code></li><li><strong>Output data</strong> - <code>3</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/list-manipulation/count-list-string">Count list string</a></td><td>Counts the number of elements in a list of strings.</td><td><ul><li><strong>Input data</strong> - <code>"test1, test2"</code></li><li><strong>Output data</strong> - <code>2</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/list-manipulation/count-list-timestamp">Count list timestamp</a></td><td>Counts the number of elements in a list of timestamps.</td><td><ul><li><strong>Input data</strong> - <code>2024-05-17T14:30:00Z, 2022-10-19T14:30:04Z, 1998-04-10T14:49:00Z</code></li><li><strong>Output data</strong> - <code>3</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/count-occurrences">Count occurrences</a></td><td>Counts the amount of times a given string occurs in your input data.</td><td><ul><li><strong>Input data</strong> - <code>"This is a sample test"</code></li><li><strong>Search</strong> - <code>test</code> </li><li><strong>Search Type</strong> - <code>simple</code></li><li><strong>Output data</strong> - <code>1</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/crc8-checksum">CRC8 checksum</a></td><td>Calculates an 8-bit Cyclic Redundancy Check (CRC) value for a given input.</td><td><ul><li><strong>Input data</strong> - <code>"hello 1234"</code></li><li><strong>Output data</strong> - <code>"C7"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/crc16-checksum">CRC16 checksum</a></td><td>Calculates an 16-bit Cyclic Redundancy Check (CRC) value for a given input.</td><td><ul><li><strong>Input data</strong> - <code>"hello 1234"</code></li><li><strong>Output data</strong> - <code>"57D4"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/crc24-checksum">CRC24 checksum</a></td><td>Calculates an 24-bit Cyclic Redundancy Check (CRC) value for a given input.</td><td><ul><li><strong>Input data</strong> - <code>"hello 1234"</code></li><li><strong>Output data</strong> - <code>"3B6473"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/crc32-checksum">CRC32 checksum</a></td><td>Calculates an 32-bit Cyclic Redundancy Check (CRC) value for a given input.</td><td><ul><li><strong>Input data</strong> - <code>"hello 1234"</code></li><li><strong>Output data</strong> - <code>"7ED8D648"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/credit-card-obfuscator">Credit card obfuscator</a></td><td>Obfuscates all digits of a credit card number except for the last 4 digits.</td><td><ul><li><strong>Input data</strong> - <code>"1111222233334444"</code></li><li><strong>Output data</strong> - <code>"************4444"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/format-conversion/csv-to-json">CSV to JSON</a></td><td>Converts a CSV file to JSON format.</td><td><ul><li><strong>Input data</strong> - <code>"First name,Last name,Age,City John,Wick,20,New-York Tony,Stark,30,Madrid"</code></li><li><strong>Cell delimiter</strong> - <code>","</code></li><li><strong>Row delimiter</strong> - <code>null</code></li><li><strong>Format</strong> - <code>Array of dictionaries</code></li><li><strong>Output data</strong> - <code>"[ { "First name": "John", "Last name": "Wick", "Age": "20", "City": "New-York" }, { "First name": "Tony", "Last name": "Stark", "Age": "30", "City": "Madrid" } ]"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/networking/defang-ip-address">Defang IP address</a></td><td>Defangs an IP address to prevent it from being recognized.</td><td><ul><li><strong>Input data</strong> - <code>"192.168.1.1"</code></li><li><strong>Output data</strong> - <code>"192[.]168[.]1[.]1"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/networking/defang-url">Defang URL</a></td><td>Defangs a URL to prevent it from being recognized as a clickable link.</td><td><ul><li><strong>Input data</strong> - <code>"https://example.com"</code></li><li><strong>Escape Dots</strong> - <code>true</code></li><li><strong>Escape HTTP</strong> - <code>true</code></li><li><strong>Escape ://</strong> - <code>false</code></li><li><strong>Process Type</strong> - <code>Everything</code></li><li><strong>Output data</strong> - <code>"hxxps://example[.]com"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/arithmetic-logic/divide">Divide</a></td><td>Divides a list of numbers provided in the input string, separated by a specific delimiter.</td><td><ul><li><strong>Input data</strong> - <code>"26:2:4"</code></li><li><strong>Delimiter</strong> - <code>Colon</code> </li><li><strong>Output data</strong> - <code>3.25</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/control-characters/escape-string">Escape string</a></td><td>Escapes specific characters in a string.</td><td><ul><li><strong>Input data</strong> - <code>"She said, "Hello, world!""</code></li><li><strong>Escape Level</strong> - <code>special chars</code></li><li><strong>Escape Quote</strong> - <code>double</code></li><li><strong>JSON compatible</strong> - <code>false</code></li><li><strong>Output data</strong> - <code>"She said, \"Hello, world!\""</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/extraction/extract-email-addresses">Extract email addresses</a></td><td>Extracts email addresses from a given input text.</td><td><ul><li><strong>Input data</strong> - <code>"The quarterly department meeting has been rescheduled to next Thursday. Please contact Sarah Johnson (</code><br><code>sjohnson384@example.net) with any conflicts. The marketing team's proposal, submitted by Michael Chen (mchen2023@samplemail.org), received positive feedback from the board"</code></li><li><strong>Sort</strong> - <code>false</code></li><li><strong>Unique</strong> - <code>true</code></li><li><strong>Output data</strong> - <code>"sjohnson384@example.net,mchen2023@samplemail.org"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/networking/extract-ip-address">Extract IP address</a></td><td>Extracts all the IPv4 and IPv6 addresses from a block of text or data.</td><td><ul><li><strong>Input data</strong> - <code>"User logged in from 192.168.1.1. Another login detected from 10.0.0.5"</code></li><li><strong>Output data</strong> - <code>"192.168.1.1,10.0.0.5"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/extraction/extract-mac-addresses">Extract MAC addresses </a></td><td>Extracts MAC addresses from a given input text.</td><td><ul><li><strong>Input data</strong> - <code>"We need to prioritize the replacement of the aging routers on the executive floor," Samantha noted in her report. "The Cisco device at 4F:5E:AB:23:CD:01 has been experiencing memory leaks, and the backup unit with MAC address 84:7B:EB:22:10:DF isn't configured properly for automatic failover"</code></li><li><strong>Output Separator</strong> - <code>Colon (:)</code></li><li><strong>Sort</strong> - <code>false</code></li><li><strong>Unique</strong> - <code>true</code></li><li><strong>Output data</strong> - <code>"4F:5E:AB:23:CD:01,84:7B:EB:22:10:DF"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/extraction/extract-urls">Extract URLs</a></td><td>Extracts URLs from a given input text.</td><td><ul><li><strong>Input data</strong> - <code>"Check the latest sales figures at reports.example.com before tomorrow's call. The customer feedback survey (survey.fictional-company.net) closes Friday. Product documentation has moved to docs.nonexistent-tech.org"</code></li><li><strong>Protocol Must Be Present</strong> - <code>true</code></li><li><strong>Output data</strong> - <code>"reports.example.com,survey.fictional-company.net,docs.nonexistent-tech.org"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/networking/fang-ip-address">Fang IP address</a></td><td>Makes defanged IP addresses valid.</td><td><ul><li><strong>Input data</strong> -<code>"192[.]168[.]1[.]1"</code></li><li><strong>Output data</strong> - <code>"192.168.1.1"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/networking/fang-urls">Fang URLs</a></td><td>Makes defanged URLs valid.</td><td><ul><li><strong>Input data</strong> - <code>"hxxps://example[.]com"</code></li><li><strong>Escape Dots</strong> - <code>true</code></li><li><strong>Escape HTTP</strong> - <code>true</code></li><li><strong>Escape ://*</strong> - <code>false</code></li><li><strong>Output data</strong> - <code>"https://example.com"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/filter">Filter</a></td><td>Splits the input string using a specified delimiter and filters.</td><td><ul><li><strong>Input data</strong> - <code>"Error: File not found Warning: Low memory Info: Operation completed Error: Disk full"</code></li><li><strong>Delimiter</strong> - <code>Space</code></li><li><strong>Regex</strong> - <code>"^Error"</code></li><li><strong>Invert</strong> - <code>false</code></li><li><strong>Output data</strong> - <code>"Error:"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/find-and-replace">Find and replace</a></td><td>Finds values in a string and replace them with others.</td><td><ul><li><strong>Input data</strong> - <code>"The server encountered an error while processing your request"</code></li><li><strong>Substring to find</strong> - <code>"error"</code></li><li><strong>Replacement</strong> - <code>"issue"</code></li><li><strong>Global Match</strong> - <code>true</code></li><li><strong>Case Insensitive</strong> - <code>true</code></li><li><strong>Multiline</strong> - <code>false</code></li><li><strong>Dot Matches All</strong> - <code>false</code></li><li><strong>Output data</strong> - <code>"The server encountered an issue while processing your request"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/conversion/float-to-string">Float to string</a></td><td>This operation transforms a float into a string using a Go format string.</td><td><ul><li><strong>Input data</strong> - <code>5.218</code> </li><li><strong>Radix (Base)</strong> - <code>"%.1f"</code></li><li><strong>Output data</strong> - <code>"5.2"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/data-format/from-base">From base</a></td><td>Converts a number from a specified base (or radix) into its decimal form.</td><td><ul><li><strong>Input data</strong> - <code>"100"</code></li><li><strong>Radix (Base)</strong> - <code>2</code></li><li><strong>Output data</strong> - <code>"4"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/data-format/from-base32">From base32</a></td><td>Decodes data from a Base32 string back into its raw format.</td><td><ul><li><strong>Input data</strong> - <code>"NBSWY3DP,!"</code></li><li><strong>Alphabet</strong> - <code>RFC4648 (Standard)</code></li><li><strong>Remove non-original chars</strong> - <code>true</code></li><li><strong>Output data</strong> - <code>"hello"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/data-format/from-base64">From base64</a></td><td>Decodes data from a Base64 string back into its raw format.</td><td><ul><li><strong>Input data</strong> - <code>"SGVsbG8sIE9udW0h"</code> </li><li><strong>Strict Mode</strong> - <code>true</code></li><li><strong>Output data</strong> - <code>"Hello, Onum!"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/encoding-decoding/from-binary">From binary</a></td><td>Decodes a binary string into plain text.</td><td><ul><li><strong>Input data</strong> - <code>"01001000 01101001"</code></li><li><strong>Delimiter</strong> - <code>Space</code></li><li><strong>Byte Length</strong> - <code>8</code></li><li><strong>Output data</strong> - <code>"Hi"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/from-ebcdic-037">From EBCDIC 037</a></td><td>Converts a EBCDIC 037 string into a different output format.</td><td><ul><li><strong>Input data</strong> - <code>"414243c"</code></li><li><strong>Output Format</strong> - <code>ASCII / UTF-8</code></li><li><strong>Output data</strong> - <code>"ABC"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/data-format/from-hex">From hex</a></td><td>Converts hexadecimal-encoded data back into its original form.</td><td><ul><li><strong>Input data -</strong> <code>"48 65 6c 6c 6f 20 57 6f 72 6c 64"</code></li><li><strong>Delimiter</strong> - <code>Space</code></li><li><strong>Output data</strong> - <code>"Hello World"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/date-time/from-unix-timestamp">From Unix timestamp</a></td><td>Converts a timestamp into a human-readable date string.</td><td><ul><li><strong>Input data</strong> - <code>978346800</code></li><li><strong>Time Unit</strong> - <code>Seconds</code></li><li><strong>Timezone Output</strong> - <code>"UTC"</code></li><li><strong>Format Output</strong> - <code>"Mon 2 January 2006 15:04:05 UTC"</code></li><li><strong>Output data</strong> - <code>"Mon 1 January 2001 11:00:00 UTC"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/compression/gzip-compress">Gzip compress</a></td><td>Compresses data using the gzip compression algorithm.</td><td><ul><li><strong>Input data</strong> - <code>"Hello, World!"</code></li><li><strong>Compression Level</strong> - <code>-1</code></li><li><strong>Output Format</strong> - <code>Base64</code></li><li><strong>Output data</strong> - <code>"H4sIAAAAAAAA//JIzcnJ11EIzy/KSVEEBAAA///Qw0rsDQAAAA=="</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/compression/gzip-decompress">Gzip decompress</a></td><td>Decompresses data using the gzip compression algorithm.</td><td><ul><li><strong>Input data</strong> - <code>"H4sIAAAAAAAA//JIzcnJ11EIzy/KSVEEBAAA///Qw0rsDQAAAA==</code></li><li><strong>Input Format</strong> - <code>Base64</code></li><li><strong>Output data</strong> - <code>"Hello, World!"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/list-manipulation/index-list-boolean">Index list boolean</a></td><td>Extracts a specific element from a list of boolean values.</td><td><ul><li><strong>Input data</strong> - <code>true, false, true, false</code></li><li><strong>Index</strong> - <code>1</code></li><li><strong>Output data</strong> - <code>false</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/list-manipulation/index-list-float">Index list float</a></td><td>Extracts a specific element from a list of float values.</td><td><ul><li><strong>Input data</strong> - <code>0.0, -1.0, 2.0</code></li><li><strong>Index</strong> - <code>1</code></li><li><strong>Output data</strong> - <code>-0.1</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/list-manipulation/index-list-integer">Index list integer</a></td><td>Extracts a specific element from a list of integer values.</td><td><ul><li><strong>Input data</strong> - <code>0, 1, 2, 3</code></li><li><strong>Index</strong> - <code>1</code></li><li><strong>Output data</strong> - <code>1</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/list-manipulation/index-list-string">Index list string</a></td><td>Extracts a specific element from a list of strings.</td><td><ul><li><strong>Input data</strong> - <code>test0, test1, test2</code></li><li><strong>Index</strong> - <code>1</code></li><li><strong>Output data</strong> - <code>test1</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/list-manipulation/index-list-timestamp">Index list timestamp</a></td><td>Extracts a specific element from a list of timestamps.</td><td><ul><li><strong>Input data</strong> - <code>1654021200, 1700000000,1750000000</code></li><li><strong>Index</strong> - <code>1</code></li><li><strong>Output data</strong> - <code>1700000000</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/conversion/integer-to-uuid">Integer to UUID</a></td><td>Converts an integer value into a standard UUID format.</td><td><ul><li><strong>Input data</strong> - <code>"20583658"</code></li><li><strong>Output data</strong> - <code>"00000000-0000-0000-0000-0000013a14ea"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/networking/ip-to-hexadecimal">IP to hexadecimal</a></td><td>Converts an IP address (either IPv4 or IPv6) to its hexadecimal representation.</td><td><ul><li><strong>Input data</strong> - <code>192.168.1.1</code></li><li><strong>Output data</strong> - <code>c0a80101</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/code-tidy/json-minify">JSON minify</a></td><td>Reduces the size of a JSON file by removing unnecessary characters from it.</td><td><ul><li><strong>Input data</strong> - </li></ul><p><code>{ "name": "John Doe", "age": 30, "isActive": true, "address": { "city": "New York", "zip": "10001" } }</code></p><ul><li><strong>Output data</strong> -</li></ul><p><code>{"name":"John Doe","age":30,"isActive":true,"address":{"city":"New York","zip":"10001"}}</code></p></td></tr><tr><td><a href="field-transformation-operations/format-conversion/json-to-csv">JSON to CSV</a></td><td>Converts a JSON file to CSV format.</td><td><ul><li><strong>Input data</strong> -</li></ul><p><code>[ { "First name": "John", "Last name": "Wick", "Age": "20", "City": "New-York" }, { "First name": "Tony", "Last name": "Stark", "Age": "30", "City": "Madrid" } ]</code></p><ul><li><strong>Cell delimiter</strong> - <code>,</code></li><li><strong>Row delimiter</strong> - <code>/n</code></li><li><strong>Output data</strong> -</li></ul><p><code>First name,Last name,Age,City John,Wick,20,New-York Tony,Stark,30,Madrid</code></p></td></tr><tr><td><a href="field-transformation-operations/format-conversion/json-to-protobuf">JSON to Protobuf</a></td><td>Converts a JSON into a Protobuf file.</td><td><ul><li><strong>Input data</strong> - <code>{ "id": 1, "name": "foo" }</code></li><li><strong>Proto file</strong> - <code>syntax = "proto3"; message ExampleMessage { int32 id = 1; string name = 2; }</code></li><li><strong>Message type</strong> - <code>ExampleMessage</code></li><li><strong>Output data</strong> - <code>foo</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/encryption-encoding/jwt-decode">JWT decode</a></td><td>Decodes the payload in a JSON Web Token string.</td><td><ul><li><strong>Input data</strong> - <code>eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiaWF0IjoxNTE2MjM5MDIyfQ.SflKxwRJSMeKKF2QT4fwpMeJf36POk6yJV_adQssw5c</code></li><li><strong>Output data</strong> - <code>{"sub":"1234567890","name":"John Doe","iat":1516239022}</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/hashing/keccak">Keccak</a></td><td>Generates a Keccak cryptographic hash function from a given input.</td><td><ul><li><strong>Input data</strong> - <code>Hello World!</code></li><li><strong>Size</strong> - <code>256</code> </li><li><strong>Output data -</strong><code>3ea2f1d0abf3fc66cf29eebb70cbd4e7fe762ef8a09bcc06c8edf641230afec0</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/string/length">Length</a></td><td>Returns the number of Unicode characters in your input strings.</td><td><ul><li><strong>Input data</strong> - <code>hello world!</code></li><li><strong>Output data</strong> - <code>12</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/conversion/list-to-string">List to string</a></td><td>Converts a list of comma-separated values into a string of values divided by a specific separator.</td><td><ul><li><strong>Input data</strong> - <code>hello,my,world</code></li><li><strong>Separator</strong> - <code>/</code> </li><li><strong>Output data -</strong> <code>hello/my/world</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/hashing/md2">MD2</a></td><td>Produces a MD2 hash string from a given input.</td><td><ul><li><strong>Input data</strong> - <code>Hello World!</code></li><li><strong>Output data</strong> - <code>315f7c67223f01fb7cab4b95100e872e</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/hashing/md4">MD4</a></td><td>Produces a MD4 hash string from a given input.</td><td><ul><li><strong>Input data</strong> - <code>Hello World!</code></li><li><strong>Output data</strong> -<code>b2a5cc34fc21a764ae2fad94d56fadf6</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/hashing/md5">MD5</a></td><td>Produces a MD5 hash string from a given input.</td><td><ul><li><strong>Input data</strong> - <code>Hello World!</code></li><li><strong>Output data</strong> -<code>ed076287532e86365e841e92bfc50d8c</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/arithmetic-logic/median">Median</a></td><td>Calculates the median of given values, separated by a specific delimiter.</td><td><ul><li><strong>Input data</strong> - <code>10, 5, 20, 15, 25</code></li><li><strong>Delimiter</strong> - <code>,</code></li><li><strong>Output</strong> <strong>data</strong> - <code>15</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/arithmetic-logic/multiply">Multiply</a></td><td>Calculates the result of the multiplication of given values, separated by a specific delimiter.</td><td><ul><li><strong>Input data</strong> - <code>2, 3, 5</code></li><li><strong>Delimiter</strong> -  <code>,</code></li><li><strong>Output data</strong> - <code>30</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/text-sample-adding/pad-lines">Pad lines</a></td><td>Pads each input line with a specified number of characters.</td><td><ul><li><strong>Input data</strong> - <code>Apple Banana Cherry</code></li><li><strong>Pad position</strong> - <code>Start</code> </li><li><strong>Pad line</strong> - <code>7</code> </li><li><strong>Character</strong> - <code>>>></code></li><li><strong>Output data</strong> - </li></ul><p><code>>>> >>>Apple >>> >>>Banana >>> >>>Cherry</code></p></td></tr><tr><td><a href="field-transformation-operations/utils/parse-color-code">Parse color code</a></td><td>Converts a color code in a supported format to other standard color format.</td><td><ul><li><strong>Input data</strong> - <code>#ff0000</code></li><li><strong>Format color</strong> - <code>RGB</code> </li><li><strong>Output data</strong> - <code>rgb(255, 0, 0)</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/other/parse-int">Parse int</a></td><td>Parses a string and returns an integer of the specified base.</td><td><ul><li><strong>Input data</strong> - <code>100</code></li><li><strong>Base</strong> - <code>2</code> </li><li><strong>Output data</strong> -<code>4</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/file-system-permissions/parse-unix-file-permissions">Parse Unix file permissions</a></td><td>Takes Unix file permission strings and converts them to code format or vice versa.</td><td><ul><li><strong>Input data</strong> - <code>-rwxr-xr--</code></li><li><strong>Output data</strong> - </li></ul><p><code>Textual representation: -rwxr-xr-- Octal representation: 0754 +---------+-------+-------+-------+ | | User | Group | Other | +---------+-------+-------+-------+ | Read | X | X | X | +---------+-------+-------+-------+ | Write | X | | | +---------+-------+-------+-------+ | Execute | X | X | | +---------+-------+-------+-------+</code></p></td></tr><tr><td><a href="field-transformation-operations/networking/parse-uri">Parse URI</a></td><td>Analyzes a URI into its individual components.</td><td><ul><li><strong>Input data</strong> -</li></ul><p><code>https://user:pass@example.com:8080/path/to/resource?key=value#fragment</code></p><ul><li><strong>Output data</strong> - </li></ul><p><code>Scheme: https Host: example.com:8080 Path: /path/to/resource Arguments: map[key:[value]] User: user Password: pass</code></p></td></tr><tr><td><a href="field-transformation-operations/format-conversion/protobuf-to-json">Protobuf to JSON</a></td><td>Converts events in Protobuf (Protocol Buffers) format into JSON.</td><td><ul><li><strong>Input data</strong> - <code>CAESA2Zvbw==</code></li><li><strong>Proto file</strong> - <code>syntax = "proto3"; message ExampleMessage { int32 id = 1; string name = 2; }</code></li><li><strong>Message type</strong> - <code>ExampleMessage</code></li><li><strong>Output data</strong> - <code>{ "id": 1, "name": "foo" }</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/regex">Regex</a></td><td>Extracts or manipulates parts of your input strings that match a specific regular expression pattern.</td><td><ul><li><strong>Input data</strong> - <code>100</code></li><li><strong>Base</strong> - <code>2</code> </li><li><strong>Output data</strong> -<code>4</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/remove-whitespace">Remove whitespace</a></td><td>Removes whitespace and other characters characters from a string.</td><td><ul><li><strong>Input data</strong> -</li></ul><p>   <code>Hello   World!</code>    </p><p><code>This is    a   test.</code></p><ul><li><strong>Spaces</strong> - <code>true</code></li><li><strong>Carriage returns</strong> - <code>false</code></li><li><strong>Line feeds</strong> - <code>true</code></li><li><strong>Tabs</strong> - <code>false</code></li><li><strong>Form feeds</strong> - <code>false</code></li><li><strong>Full stops</strong> - <code>true</code></li><li><strong>Output data</strong> - </li></ul><p><code>HelloWorld!Thisisatest</code></p></td></tr><tr><td><a href="field-transformation-operations/utils/reverse-string">Reverse string</a></td><td>Reverses the order of the characters in a string.</td><td><ul><li><strong>Input data</strong> - <code>Hello World!</code></li><li><strong>Reverse mode</strong> - <code>Character</code></li><li><strong>Output data</strong> - <code>!dlroW olleH</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/hashing/sha0">SHA0</a></td><td>Returns the SHA0 hash of a given string.</td><td><ul><li><strong>Input data</strong> - <code>Hello World!</code></li><li><strong>Output data</strong> - <code>1261178ff9a732aacfece0d8b8bd113255a57960</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/hashing/sha1">SHA1</a></td><td>Returns the SHA1 hash of a given string.</td><td><ul><li><strong>Input data</strong> - <code>Hello World!</code></li><li><strong>Output data</strong> - <code>2ef7bde608ce5404e97d5f042f95f89f1c232871</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/hashing/sha2">SHA2</a></td><td>Returns the SHA2 hash of a given string.</td><td><ul><li><strong>Input data</strong> - <code>Hello World!</code></li><li><strong>Size</strong> - <code>512</code></li><li><strong>Output data</strong> - <code>f4d54d32e3523357ff023903eaba2721e8c8cfc7702663782cb3e52faf2c56c002cc3096b5f2b6df870be665d0040e9963590eb02d03d166e52999cd1c430db1</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/hashing/sha3">SHA3</a></td><td>Returns the SHA3 hash of a given string.</td><td><ul><li><strong>Input data</strong> - <code>Hello World!</code></li><li><strong>Size</strong> - <code>512</code></li><li><strong>Output data</strong> - <code>32400b5e89822de254e8d5d94252c52bdcb27a3562ca593e980364d9848b8041b98eabe16c1a6797484941d2376864a1b0e248b0f7af8b1555a778c336a5bf48</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/hashing/shake">Shake</a></td><td>Returns the SHAKE hash of a given string.</td><td><ul><li><strong>Input data</strong> - <code>Hello World!</code></li><li><strong>Capacity</strong> - <code>256</code></li><li><strong>Size</strong> - <code>512</code></li><li><strong>Output data</strong> -  <code>35259d2903a1303d3115c669e2008510fc79acb50679b727ccb567cc3f786de3553052e47d4dd715cc705ce212a92908f4df9e653fa3653e8a7855724d366137</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/shuffle">Shuffle</a></td><td>Shuffles the characters of a given string.</td><td><ul><li><strong>Input data</strong> - <code>Hello, World!</code></li><li><strong>Delimiter</strong> - <code>Comma</code></li><li><strong>Output data</strong> - <code>eollH,ro!ld W</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/hashing/sm3">SM3</a></td><td>Returns the SM3 cryptographic hash function of a given string.</td><td><ul><li><strong>Input data</strong> - <code>Hello World!</code></li><li><strong>Length</strong> - <code>64</code></li><li><strong>Output data</strong> - <code>0ac0a9fef0d212aa</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/sort">Sort</a></td><td>Sorts a list of strings separated by a specified delimiter according to the provided sorting order.</td><td><ul><li><strong>Input data</strong> - <code>banana,apple,orange,grape</code></li><li><strong>Delimiter</strong> - <code>Comma</code></li><li><strong>Order</strong> - <code>Alphabetical (case sensitive)</code></li><li><strong>Reverse</strong> - <code>false</code></li><li><strong>Output data</strong> - <code>apple,banana,grape,orange</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/conversion/string-to-float">String to float</a></td><td>Converts a numeric string into a float value.</td><td><ul><li><strong>Input data</strong> - <code>"3.14"</code></li><li><strong>Output data</strong> - <code>3.14</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/conversion/string-to-list">String to list</a></td><td>Converts a string composed of values separated by a specific separator into a list of comma-separated values.</td><td><ul><li><strong>Input data</strong> - <code>hello/my/world</code></li><li><strong>Separator</strong> - <code>/</code> </li><li><strong>Output data</strong> - <code>hello,my,world</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/substring">Substring</a></td><td>Extracts characters from a given string.</td><td><ul><li><strong>Input data</strong> - <code>+34678987678</code></li><li><strong>Start Index</strong> - <code>3</code></li><li><strong>Length</strong> - <code>9</code></li><li><strong>Output data</strong> - <code>678987678</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/arithmetic-logic/subtract">Subtract</a></td><td>Calculates the result of the subtraction of given values, separated by a specific delimiter.</td><td><ul><li><strong>Input data</strong> - <code>10, 5, 2</code></li><li><strong>Delimiter</strong> - <code>Comma</code></li><li><strong>Output data</strong> - <code>3</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/arithmetic-logic/sum">Sum</a></td><td>Calculates the sum of given values, separated by a specific delimiter.</td><td><ul><li><strong>Input data</strong> - <code>10, 5, 2</code></li><li><strong>Delimiter</strong> - <code>Comma</code></li><li><strong>Output data</strong> - <code>17</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/swap-case">Swap case</a></td><td>Swaps the case of a given string.</td><td><ul><li><strong>Input data</strong> - <code>Hello World!</code></li><li><strong>Output data</strong> - <code>hELLO wORLD!</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/data-format/to-base">To base</a></td><td>Converts a number into its representation in a specified numeric base (or radix).</td><td><ul><li><strong>Input data</strong> - <code>100</code></li><li><strong>Radix (Base)</strong> - <code>2</code></li><li><strong>Output data</strong> - <code>1100100</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/data-format/to-base32">To base32</a></td><td>Encodes raw data into a Base32 string.</td><td><ul><li><strong>Input data</strong> - <code>hello</code></li><li><strong>Standard</strong> - <code>standard</code></li><li><strong>Output data</strong> - <code>NBSWY3DP</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/data-format/to-base64">To base64</a></td><td>Encodes raw data into an ASCII Base64 string.</td><td><ul><li><strong>Input data</strong> - <code>Hello, Onum!</code> </li><li><strong>Output data</strong> - <code>SGVsbG8sIE9udW0h</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/encoding-decoding/to-binary">To binary</a></td><td>Converts a text string into its binary representation.</td><td><ul><li><strong>Input data</strong> - <code>Hello</code></li><li><strong>Delimiter</strong> - <code>Comma</code></li><li><strong>Byte Length</strong> - <code>8</code></li><li><strong>Output data</strong> - <code>01001000,01100101,01101100,01101100,01101111</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/encoding-decoding/to-decimal">To decimal</a></td><td>Converts a text string into its ordinal integer decimal representation.</td><td><ul><li><strong>Input data</strong> - <code>Hello</code></li><li><strong>Delimiter</strong> - <code>Comma</code></li><li><strong>Support signed values</strong> - <code>false</code></li><li><strong>Output data</strong> - <code>72,101,108,108,111</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/data-format/to-hex">To hex</a></td><td>Converts a string to its corresponding hexadecimal code. </td><td><ul><li><strong>Output data</strong> - <code>Hello World!</code></li><li><strong>Delimiter</strong> - <code>Space</code></li><li><strong>Bytes per line</strong> - <code>0</code></li><li><strong>Input data</strong> - <code>48 65 6c 6c 6f 20 57 6f 72 6c 64</code> </li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/to-lower-case">To lower case</a></td><td>Converts the characters of a string to lower case. </td><td><ul><li><strong>Input data</strong> - <code>Hello World!</code> </li><li><strong>Output data</strong> - <code>hello world!</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/date-time/to-timestamp">To timestamp</a></td><td>Transforms a string representing a date into a timestamp.</td><td><ul><li><strong>Input data</strong> - <code>2006-01-02</code></li><li><strong>Format</strong> - <code>Date Only</code></li><li><strong>Output data</strong> - <code>2006-01-02T00:00:00Z</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/date-time/to-unix-timestamp">To Unix timestamp</a></td><td>Parses a datetime string in UTC and returns the corresponding Unix timestamp.</td><td><ul><li><strong>Input data</strong> - <code>2006-01-02 15:04:05</code></li><li><strong>Unit</strong> - <code>Seconds</code></li><li><strong>Output data</strong> - <code>1136214245</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/to-upper-case">To upper case</a></td><td>Converts the characters of a string to upper case. </td><td><ul><li><strong>Input data</strong> - <code>Hello World!</code> </li><li><strong>Output data</strong> - <code>HELLO WORLD!</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/date-time/translate-datetime-format">Translate datetime format</a></td><td>Converts a date and time from one format to another.</td><td><ul><li><strong>Input data</strong> - <code>05-20-2023 10:10:45</code></li><li><strong>Input Format</strong> - <code>01-02-2006 15:04:05</code></li><li><strong>Input Timezone</strong> - <code>UTC+1</code></li><li><strong>Output Format</strong> - <code>Mon, 2 Jan 2006 15:04:05 +0000</code></li><li><strong>Output Timezone</strong> - <code>UTC+1</code></li><li><strong>Output data</strong> - <code>Sat, 20 May 2023 10:10:45 +0000</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/date-time/translate-datetime-nites-format">Translate datetime NITES format</a></td><td>Parses a datetime string in one format and rewrites it in another format, using NITES format.</td><td><ul><li><strong>Input data</strong> - <code>2023-06-15 14:30:00</code></li><li><strong>Input Format</strong> - <code>yyyy-mm-dd hhh:ii:ss</code></li><li><strong>Input Timezone</strong> - <code>UTC</code></li><li><strong>Output Format</strong> - <code>dd-mm-yyyy hhh:ii:ss</code></li><li><strong>Output Timezone</strong> - <code>America/Los_Angeles</code></li><li><strong>Output data</strong> - <code>15-06-2023 07:30:00</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/trim-left-string">Trim left string</a></td><td>Removes unwanted characters from the beginning of a string.</td><td><ul><li><strong>Input data</strong> - <code>"!!!Hello, World!!!"</code></li><li><strong>Characters to trim</strong> - <code>!</code>       </li><li><strong>Output data</strong> - <code>"Hello, World!!!"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/trim-prefix-from-string">Trim prefix from string</a></td><td>Removes a specified prefix from the beginning of a string, if it exists.</td><td><ul><li><strong>Input data</strong> - <code>"Hello, World!"</code></li><li><strong>Prefix to trim</strong> - <code>Hello</code>        </li><li><strong>Output data</strong> - <code>"World!"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/trim-right-string">Trim right string</a></td><td>Removes unwanted characters from the end of a string.</td><td><ul><li><strong>Input data</strong> - <code>"Hello, World!!!"</code></li><li><strong>Characters to trim</strong> - <code>!</code>       </li><li><strong>Output data</strong> - <code>"Hello, World"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/trim-string">Trim string</a></td><td>Removes unwanted characters from the beginning and end of a string.</td><td><ul><li><strong>Input data</strong> - <code>" !!!Hello, World!!! "</code></li><li><strong>Characters to trim</strong> - <code>!</code>       </li><li><strong>Output data</strong> - <code>"Hello, World"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/utils/trim-suffix-from-string">Trim suffix from string</a></td><td>Removes a specified suffix from the end of a string.</td><td><ul><li><strong>Input data</strong> - <code>"report_final.txt"</code></li><li><strong>Prefix to trim</strong> - <code>.txt</code>        </li><li><strong>Output data</strong> - <code>"report_final"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/control-characters/unescape-string">Unescape string</a></td><td>Removes escape characters from a given string.</td><td><ul><li><strong>Input data</strong> - <code>She said, \"Hello, world!\"</code></li><li><strong>Output data</strong> - <code>She said, "Hello, world!"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/networking/url-decode">URL decode</a></td><td>Decodes a URL and returns its corresponding URL-decoded string.</td><td><ul><li><strong>Input data</strong> - <code>https%3A%2F%2Fexample.com%2Fsearch%3Fq%3DHello+World%21</code></li><li><strong>Output data</strong> - <code>https://example.com/search?q=Hello World!</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/networking/url-encode">URL encode</a></td><td>Encodes a URL-decoded string back to its original URL format,</td><td><ul><li><strong>Input data</strong> - <code>https://example.com/search?q=Hello World!</code></li><li><strong>Output data</strong> - <code>https://example.com/search?q=Hello%20World!</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/conversion/uuid-to-integer">UUID to integer</a></td><td>Converts a valid UUID into its corresponding integer.</td><td><ul><li><strong>Input data</strong> - <code>"00000000-0000-0000-0000-0000013a14ea"</code></li><li><strong>Output data</strong> - <code>"20583658"</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/compression/zlib-compress">Zlib compress</a></td><td>Compresses data using the zlib compression algorithm.</td><td><ul><li><strong>Input data</strong> - <code>"Hello, World!"</code></li><li><strong>Compression Level</strong> - <code>-1</code></li><li><strong>Output Format</strong> - <code>Base64</code></li><li><strong>Output data</strong> - <code>"eJzySM3JyVcozy/KSQEEAAuUAw0="</code></li></ul></td></tr><tr><td><a href="field-transformation-operations/compression/zlib-decompress">Zlib decompress</a></td><td>Deompresses data using the zlib compression algorithm.</td><td><ul><li><strong>Input data</strong> - <code>"eJzySM3JyVcozy/KSQEEAAuUAw0="</code></li><li><strong>Input Format</strong> - <code>Base64</code></li><li><strong>Output data</strong> - <code>"H4sIAAAAAAAA//JIzcnJ11EIzy/KSVEEBAAA///Qw0rsDQAAAA=="</code></li></ul></td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.onum.com/the-workspace/pipelines/actions/transformation/field-transformation/field-transformation-operations.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
