> For the complete documentation index, see [llms.txt](https://docs.onum.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.onum.com/pipelines/actions/transformation/field-transformation/field-transformation-operations.md). # Field Transformation Operations A comprehensive list of the operations available in the [Field Tranformation](/pipelines/actions/transformation/field-transformation.md) Action.
OperationDescriptionExample
AES-256-GCM decryptDecrypts a base64-encoded AES-256-GCM ciphertext using the provided encryption key.
  • Input data - "c3RhbmRhcmQgbm9uY2UxMjM0NTY3OGNpcGhlcnRleHRleGFtcGxl"
  • Encryption key - "603deb1015ca71be2b73aef0857d77811f352c073b6108d72d9810a30914dff4603deb1015ca71be2b73aef0857d77811f352c073b6108d72d9810a30914dff4"
  • Output data - "Hello, World!"
AES-256-GCM encryptEncrypts a plaintext string using the AES-256-GCM algorithm and returns a base64(nonce || ciphertext).
  • Input data - "Hello, World!"
  • Encryption key - "603deb1015ca71be2b73aef0857d77811f352c073b6108d72d9810a30914dff4603deb1015ca71be2b73aef0857d77811f352c073b6108d72d9810a30914dff4"
  • Output data - "c3RhbmRhcmQgbm9uY2UxMjM0NTY3OGNpcGhlcnRleHRleGFtcGxl"
Byte to human readableConverts a size in bytes to a human-readable string.
  • Input data - "134367"
  • Output data - "131.22 KiB"
Bzip2 compressCompresses data using the bzip2 compression algorithm.
  • Input data - "Hello, World!"
  • Compression Level - 9
  • Output Format - Base64
  • Output data - "QlpoOTFBWSZTWebY/t8AAAGXgGAEAEAAgAYEkAAgACIjNDahADCbaTwKg3hdyRThQkObY/t8"
Bzip2 decompressDecompresses data it using the bzip2 algorithm.
  • Input data - "QlpoOTFBWSZTWebY/t8AAAGXgGAEAEAAgAYEkAAgACIjNDahADCbaTwKg3hdyRThQkObY/t8"
  • Input format - Base64
  • Output data - "Hello, World!"
Convert areaConverts values from one unit of measurement to another.
  • Input data - "134367"
  • Input units - "Square foot (sq ft)"
  • Output units - "Square metre (sq m)"
  • Output data - "464.515215"
Convert data unitsConverts a unit of data to another format.
  • Input data - "2"
  • Input units - "Megabits (Mb)"
  • Output units - "Kilobytes (KB)"
  • Output data - "250"
Convert distanceConverts values from one unit of length to another.
  • Input data - "100"
  • Input units - "Metres (m)"
  • Output units - "Yards (yd)"
  • Output data - "109.3613298"
Convert massConverts values from one unit of mass to another.
  • Input data - "100"
  • Input units - "Kilogram (kg)"
  • Output units - "Pound (lb)"
  • Output data - "220.4622622"
Convert speedConverts values from one unit of speed to another.
  • Input data - "200"
  • Input units - "Kilometres per hour (km/h)"
  • Output units - "Miles per hour (mph)"
  • Output data - "124.2841804"
Count list booleanCounts the number of elements in a list of booleans.
  • Input data - true, false
  • Output data - 2
Count list floatCounts the number of elements in a list of float values.
  • Input data - 1.5, -2.3, 3.8
  • Output data - 3
Count list integerCounts the number of elements in a list of integer values.
  • Input data - 10, 20, 30
  • Output data - 3
Count list stringCounts the number of elements in a list of strings.
  • Input data - "test1, test2"
  • Output data - 2
Count list timestampCounts the number of elements in a list of timestamps.
  • Input data - 2024-05-17T14:30:00Z, 2022-10-19T14:30:04Z, 1998-04-10T14:49:00Z
  • Output data - 3
Count occurrencesCounts the amount of times a given string occurs in your input data.
  • Input data - "This is a sample test"
  • Search - test
  • Search Type - simple
  • Output data - 1
CRC8 checksumCalculates an 8-bit Cyclic Redundancy Check (CRC) value for a given input.
  • Input data - "hello 1234"
  • Output data - "C7"
CRC16 checksumCalculates an 16-bit Cyclic Redundancy Check (CRC) value for a given input.
  • Input data - "hello 1234"
  • Output data - "57D4"
CRC24 checksumCalculates an 24-bit Cyclic Redundancy Check (CRC) value for a given input.
  • Input data - "hello 1234"
  • Output data - "3B6473"
CRC32 checksumCalculates an 32-bit Cyclic Redundancy Check (CRC) value for a given input.
  • Input data - "hello 1234"
  • Output data - "7ED8D648"
Credit card obfuscatorObfuscates all digits of a credit card number except for the last 4 digits.
  • Input data - "1111222233334444"
  • Output data - "************4444"
CSV to JSONConverts a CSV file to JSON format.
  • Input data - "First name,Last name,Age,City John,Wick,20,New-York Tony,Stark,30,Madrid"
  • Cell delimiter - ","
  • Row delimiter - null
  • Format - Array of dictionaries
  • Output data - "[ { "First name": "John", "Last name": "Wick", "Age": "20", "City": "New-York" }, { "First name": "Tony", "Last name": "Stark", "Age": "30", "City": "Madrid" } ]"
Defang IP addressDefangs an IP address to prevent it from being recognized.
  • Input data - "192.168.1.1"
  • Output data - "192[.]168[.]1[.]1"
Defang URLDefangs a URL to prevent it from being recognized as a clickable link.
  • Input data - "https://example.com"
  • Escape Dots - true
  • Escape HTTP - true
  • Escape :// - false
  • Process Type - Everything
  • Output data - "hxxps://example[.]com"
DivideDivides a list of numbers provided in the input string, separated by a specific delimiter.
  • Input data - "26:2:4"
  • Delimiter - Colon
  • Output data - 3.25
Escape stringEscapes specific characters in a string.
  • Input data - "She said, "Hello, world!""
  • Escape Level - special chars
  • Escape Quote - double
  • JSON compatible - false
  • Output data - "She said, \"Hello, world!\""
Extract email addressesExtracts email addresses from a given input text.
  • Input data - "The quarterly department meeting has been rescheduled to next Thursday. Please contact Sarah Johnson (
    sjohnson384@example.net) with any conflicts. The marketing team's proposal, submitted by Michael Chen (mchen2023@samplemail.org), received positive feedback from the board"
  • Sort - false
  • Unique - true
  • Output data - "sjohnson384@example.net,mchen2023@samplemail.org"
Extract IP addressExtracts all the IPv4 and IPv6 addresses from a block of text or data.
  • Input data - "User logged in from 192.168.1.1. Another login detected from 10.0.0.5"
  • Output data - "192.168.1.1,10.0.0.5"
Extract MAC addresses Extracts MAC addresses from a given input text.
  • Input data - "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"
  • Output Separator - Colon (:)
  • Sort - false
  • Unique - true
  • Output data - "4F:5E:AB:23:CD:01,84:7B:EB:22:10:DF"
Extract URLsExtracts URLs from a given input text.
  • Input data - "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"
  • Protocol Must Be Present - true
  • Output data - "reports.example.com,survey.fictional-company.net,docs.nonexistent-tech.org"
Fang IP addressMakes defanged IP addresses valid.
  • Input data -"192[.]168[.]1[.]1"
  • Output data - "192.168.1.1"
Fang URLsMakes defanged URLs valid.
  • Input data - "hxxps://example[.]com"
  • Escape Dots - true
  • Escape HTTP - true
  • Escape ://* - false
  • Output data - "https://example.com"
FilterSplits the input string using a specified delimiter and filters.
  • Input data - "Error: File not found Warning: Low memory Info: Operation completed Error: Disk full"
  • Delimiter - Space
  • Regex - "^Error"
  • Invert - false
  • Output data - "Error:"
Find and replaceFinds values in a string and replace them with others.
  • Input data - "The server encountered an error while processing your request"
  • Substring to find - "error"
  • Replacement - "issue"
  • Global Match - true
  • Case Insensitive - true
  • Multiline - false
  • Dot Matches All - false
  • Output data - "The server encountered an issue while processing your request"
Float to stringThis operation transforms a float into a string using a Go format string.
  • Input data - 5.218
  • Radix (Base) - "%.1f"
  • Output data - "5.2"
From baseConverts a number from a specified base (or radix) into its decimal form.
  • Input data - "100"
  • Radix (Base) - 2
  • Output data - "4"
From base32Decodes data from a Base32 string back into its raw format.
  • Input data - "NBSWY3DP,!"
  • Alphabet - RFC4648 (Standard)
  • Remove non-original chars - true
  • Output data - "hello"
From base64Decodes data from a Base64 string back into its raw format.
  • Input data - "SGVsbG8sIE9udW0h"
  • Strict Mode - true
  • Output data - "Hello, Onum!"
From binaryDecodes a binary string into plain text.
  • Input data - "01001000 01101001"
  • Delimiter - Space
  • Byte Length - 8
  • Output data - "Hi"
From EBCDIC 037Converts a EBCDIC 037 string into a different output format.
  • Input data - "414243c"
  • Output Format - ASCII / UTF-8
  • Output data - "ABC"
From hexConverts hexadecimal-encoded data back into its original form.
  • Input data - "48 65 6c 6c 6f 20 57 6f 72 6c 64"
  • Delimiter - Space
  • Output data - "Hello World"
From timestampTransforms a timestamp into its string representation.
  • Input data - 2006-01-02T00:00:00Z
  • Format - Date Only
  • Output data - 2006-01-02
From Unix timestampConverts a timestamp into a human-readable date string.
  • Input data - 978346800
  • Time Unit - Seconds
  • Timezone Output - "UTC"
  • Format Output - "Mon 2 January 2006 15:04:05 UTC"
  • Output data - "Mon 1 January 2001 11:00:00 UTC"
Gzip compressCompresses data using the gzip compression algorithm.
  • Input data - "Hello, World!"
  • Compression Level - -1
  • Output Format - Base64
  • Output data - "H4sIAAAAAAAA//JIzcnJ11EIzy/KSVEEBAAA///Qw0rsDQAAAA=="
Gzip decompressDecompresses data using the gzip compression algorithm.
  • Input data - "H4sIAAAAAAAA//JIzcnJ11EIzy/KSVEEBAAA///Qw0rsDQAAAA==
  • Input Format - Base64
  • Output data - "Hello, World!"
Index list booleanExtracts a specific element from a list of boolean values.
  • Input data - true, false, true, false
  • Index - 1
  • Output data - false
Index list floatExtracts a specific element from a list of float values.
  • Input data - 0.0, -1.0, 2.0
  • Index - 1
  • Output data - -0.1
Index list integerExtracts a specific element from a list of integer values.
  • Input data - 0, 1, 2, 3
  • Index - 1
  • Output data - 1
Index list stringExtracts a specific element from a list of strings.
  • Input data - test0, test1, test2
  • Index - 1
  • Output data - test1
Index list timestampExtracts a specific element from a list of timestamps.
  • Input data - 1654021200, 1700000000,1750000000
  • Index - 1
  • Output data - 1700000000
Integer to UUIDConverts an integer value into a standard UUID format.
  • Input data - "20583658"
  • Output data - "00000000-0000-0000-0000-0000013a14ea"
IP to hexadecimalConverts an IP address (either IPv4 or IPv6) to its hexadecimal representation.
  • Input data - 192.168.1.1
  • Output data - c0a80101
JSON minifyReduces the size of a JSON file by removing unnecessary characters from it.
  • Input data -

{ "name": "John Doe", "age": 30, "isActive": true, "address": { "city": "New York", "zip": "10001" } }

  • Output data -

{"name":"John Doe","age":30,"isActive":true,"address":{"city":"New York","zip":"10001"}}

JSON to CSVConverts a JSON file to CSV format.
  • Input data -

[ { "First name": "John", "Last name": "Wick", "Age": "20", "City": "New-York" }, { "First name": "Tony", "Last name": "Stark", "Age": "30", "City": "Madrid" } ]

  • Cell delimiter - ,
  • Row delimiter - /n
  • Output data -

First name,Last name,Age,City John,Wick,20,New-York Tony,Stark,30,Madrid

JSON to ProtobufConverts a JSON into a Protobuf file.
  • Input data - { "id": 1, "name": "foo" }
  • Proto file - syntax = "proto3"; message ExampleMessage { int32 id = 1; string name = 2; }
  • Message type - ExampleMessage
  • Output data - foo
JWT decodeDecodes the payload in a JSON Web Token string.
  • Input data - eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiaWF0IjoxNTE2MjM5MDIyfQ.SflKxwRJSMeKKF2QT4fwpMeJf36POk6yJV_adQssw5c
  • Output data - {"sub":"1234567890","name":"John Doe","iat":1516239022}
KeccakGenerates a Keccak cryptographic hash function from a given input.
  • Input data - Hello World!
  • Size - 256
  • Output data -3ea2f1d0abf3fc66cf29eebb70cbd4e7fe762ef8a09bcc06c8edf641230afec0
LengthReturns the number of Unicode characters in your input strings.
  • Input data - hello world!
  • Output data - 12
List to stringConverts a list of comma-separated values into a string of values divided by a specific separator.
  • Input data - hello,my,world
  • Separator - /
  • Output data - hello/my/world
MD2Produces a MD2 hash string from a given input.
  • Input data - Hello World!
  • Output data - 315f7c67223f01fb7cab4b95100e872e
MD4Produces a MD4 hash string from a given input.
  • Input data - Hello World!
  • Output data -b2a5cc34fc21a764ae2fad94d56fadf6
MD5Produces a MD5 hash string from a given input.
  • Input data - Hello World!
  • Output data -ed076287532e86365e841e92bfc50d8c
MedianCalculates the median of given values, separated by a specific delimiter.
  • Input data - 10, 5, 20, 15, 25
  • Delimiter - ,
  • Output data - 15
MultiplyCalculates the result of the multiplication of given values, separated by a specific delimiter.
  • Input data - 2, 3, 5
  • Delimiter - ,
  • Output data - 30
Pad linesPads each input line with a specified number of characters.
  • Input data - Apple Banana Cherry
  • Pad position - Start
  • Pad line - 7
  • Character - >>>
  • Output data -

>>> >>>Apple >>> >>>Banana >>> >>>Cherry

Parse color codeConverts a color code in a supported format to other standard color format.
  • Input data - #ff0000
  • Format color - RGB
  • Output data - rgb(255, 0, 0)
Parse intParses a string and returns an integer of the specified base.
  • Input data - 100
  • Base - 2
  • Output data -4
Parse Unix file permissionsTakes Unix file permission strings and converts them to code format or vice versa.
  • Input data - -rwxr-xr--
  • Output data -

Textual representation: -rwxr-xr-- Octal representation: 0754 +---------+-------+-------+-------+ | | User | Group | Other | +---------+-------+-------+-------+ | Read | X | X | X | +---------+-------+-------+-------+ | Write | X | | | +---------+-------+-------+-------+ | Execute | X | X | | +---------+-------+-------+-------+

Parse URIAnalyzes a URI into its individual components.
  • Input data -

https://user:pass@example.com:8080/path/to/resource?key=value#fragment

  • Output data -

Scheme: https Host: example.com:8080 Path: /path/to/resource Arguments: map[key:[value]] User: user Password: pass

Protobuf to JSONConverts events in Protobuf (Protocol Buffers) format into JSON.
  • Input data - CAESA2Zvbw==
  • Proto file - syntax = "proto3"; message ExampleMessage { int32 id = 1; string name = 2; }
  • Message type - ExampleMessage
  • Output data - { "id": 1, "name": "foo" }
RegexExtracts or manipulates parts of your input strings that match a specific regular expression pattern.
  • Input data - 100
  • Base - 2
  • Output data -4
Remove whitespaceRemoves whitespace and other characters characters from a string.
  • Input data -

Hello World!

This is a test.

  • Spaces - true
  • Carriage returns - false
  • Line feeds - true
  • Tabs - false
  • Form feeds - false
  • Full stops - true
  • Output data -

HelloWorld!Thisisatest

Reverse stringReverses the order of the characters in a string.
  • Input data - Hello World!
  • Reverse mode - Character
  • Output data - !dlroW olleH
SHA0Returns the SHA0 hash of a given string.
  • Input data - Hello World!
  • Output data - 1261178ff9a732aacfece0d8b8bd113255a57960
SHA1Returns the SHA1 hash of a given string.
  • Input data - Hello World!
  • Output data - 2ef7bde608ce5404e97d5f042f95f89f1c232871
SHA2Returns the SHA2 hash of a given string.
  • Input data - Hello World!
  • Size - 512
  • Output data - f4d54d32e3523357ff023903eaba2721e8c8cfc7702663782cb3e52faf2c56c002cc3096b5f2b6df870be665d0040e9963590eb02d03d166e52999cd1c430db1
SHA3Returns the SHA3 hash of a given string.
  • Input data - Hello World!
  • Size - 512
  • Output data - 32400b5e89822de254e8d5d94252c52bdcb27a3562ca593e980364d9848b8041b98eabe16c1a6797484941d2376864a1b0e248b0f7af8b1555a778c336a5bf48
ShakeReturns the SHAKE hash of a given string.
  • Input data - Hello World!
  • Capacity - 256
  • Size - 512
  • Output data - 35259d2903a1303d3115c669e2008510fc79acb50679b727ccb567cc3f786de3553052e47d4dd715cc705ce212a92908f4df9e653fa3653e8a7855724d366137
ShuffleShuffles the characters of a given string.
  • Input data - Hello, World!
  • Delimiter - Comma
  • Output data - eollH,ro!ld W
SM3Returns the SM3 cryptographic hash function of a given string.
  • Input data - Hello World!
  • Length - 64
  • Output data - 0ac0a9fef0d212aa
SortSorts a list of strings separated by a specified delimiter according to the provided sorting order.
  • Input data - banana,apple,orange,grape
  • Delimiter - Comma
  • Order - Alphabetical (case sensitive)
  • Reverse - false
  • Output data - apple,banana,grape,orange
String to floatConverts a numeric string into a float value.
  • Input data - "3.14"
  • Output data - 3.14
String to listConverts a string composed of values separated by a specific separator into a list of comma-separated values.
  • Input data - hello/my/world
  • Separator - /
  • Output data - hello,my,world
SubstringExtracts characters from a given string.
  • Input data - +34678987678
  • Start Index - 3
  • Length - 9
  • Output data - 678987678
SubtractCalculates the result of the subtraction of given values, separated by a specific delimiter.
  • Input data - 10, 5, 2
  • Delimiter - Comma
  • Output data - 3
SumCalculates the sum of given values, separated by a specific delimiter.
  • Input data - 10, 5, 2
  • Delimiter - Comma
  • Output data - 17
Swap caseSwaps the case of a given string.
  • Input data - Hello World!
  • Output data - hELLO wORLD!
To baseConverts a number into its representation in a specified numeric base (or radix).
  • Input data - 100
  • Radix (Base) - 2
  • Output data - 1100100
To base32Encodes raw data into a Base32 string.
  • Input data - hello
  • Standard - standard
  • Output data - NBSWY3DP
To base64Encodes raw data into an ASCII Base64 string.
  • Input data - Hello, Onum!
  • Output data - SGVsbG8sIE9udW0h
To binaryConverts a text string into its binary representation.
  • Input data - Hello
  • Delimiter - Comma
  • Byte Length - 8
  • Output data - 01001000,01100101,01101100,01101100,01101111
To decimalConverts a text string into its ordinal integer decimal representation.
  • Input data - Hello
  • Delimiter - Comma
  • Support signed values - false
  • Output data - 72,101,108,108,111
To hexConverts a string to its corresponding hexadecimal code.
  • Output data - Hello World!
  • Delimiter - Space
  • Bytes per line - 0
  • Input data - 48 65 6c 6c 6f 20 57 6f 72 6c 64
To lower caseConverts the characters of a string to lower case.
  • Input data - Hello World!
  • Output data - hello world!
To timestampTransforms a string representing of a date into a timestamp.
  • Input data - 2006-01-02
  • Format - Date Only
  • Output data - 2006-01-02T00:00:00Z
To Unix timestampParses a datetime string in UTC and returns the corresponding Unix timestamp.
  • Input data - 2006-01-02 15:04:05
  • Unit - Seconds
  • Output data - 1136214245
To upper caseConverts the characters of a string to upper case.
  • Input data - Hello World!
  • Output data - HELLO WORLD!
Translate datetime formatConverts a date and time from one format to another.
  • Input data - 05-20-2023 10:10:45
  • Input Format - 01-02-2006 15:04:05
  • Input Timezone - UTC+1
  • Output Format - Mon, 2 Jan 2006 15:04:05 +0000
  • Output Timezone - UTC+1
  • Output data - Sat, 20 May 2023 10:10:45 +0000
Translate datetime NITES formatParses a datetime string in one format and rewrites it in another format, using NITES format.
  • Input data - 2023-06-15 14:30:00
  • Input Format - yyyy-mm-dd hhh:ii:ss
  • Input Timezone - UTC
  • Output Format - dd-mm-yyyy hhh:ii:ss
  • Output Timezone - America/Los_Angeles
  • Output data - 15-06-2023 07:30:00
Trim left stringRemoves unwanted characters from the beginning of a string.
  • Input data - "!!!Hello, World!!!"
  • Characters to trim - !
  • Output data - "Hello, World!!!"
Trim prefix from stringRemoves a specified prefix from the beginning of a string, if it exists.
  • Input data - "Hello, World!"
  • Prefix to trim - Hello
  • Output data - "World!"
Trim right stringRemoves unwanted characters from the end of a string.
  • Input data - "Hello, World!!!"
  • Characters to trim - !
  • Output data - "Hello, World"
Trim stringRemoves unwanted characters from the beginning and end of a string.
  • Input data - " !!!Hello, World!!! "
  • Characters to trim - !
  • Output data - "Hello, World"
Trim suffix from stringRemoves a specified suffix from the end of a string.
  • Input data - "report_final.txt"
  • Prefix to trim - .txt
  • Output data - "report_final"
Unescape stringRemoves escape characters from a given string.
  • Input data - She said, \"Hello, world!\"
  • Output data - She said, "Hello, world!"
URL decodeDecodes a URL and returns its corresponding URL-decoded string.
  • Input data - https%3A%2F%2Fexample.com%2Fsearch%3Fq%3DHello+World%21
  • Output data - https://example.com/search?q=Hello World!
URL encodeEncodes a URL-decoded string back to its original URL format,
  • Input data - https://example.com/search?q=Hello World!
  • Output data - https://example.com/search?q=Hello%20World!
UUID to integerConverts a valid UUID into its corresponding integer.
  • Input data - "00000000-0000-0000-0000-0000013a14ea"
  • Output data - "20583658"
Zlib compressCompresses data using the zlib compression algorithm.
  • Input data - "Hello, World!"
  • Compression Level - -1
  • Output Format - Base64
  • Output data - "eJzySM3JyVcozy/KSQEEAAuUAw0="
Zlib decompressDeompresses data using the zlib compression algorithm.
  • Input data - "eJzySM3JyVcozy/KSQEEAAuUAw0="
  • Input Format - Base64
  • Output data - "H4sIAAAAAAAA//JIzcnJ11EIzy/KSVEEBAAA///Qw0rsDQAAAA=="