Field Transformation Operations

A comprehensive list of the operations available in the Field Tranformation Action.

Operation
Description
Example

Converts a size in bytes to a human-readable string.

  • Input data - 134367

  • Output data - 131.22 KiB

Converts values from one unit of measurement to another.

  • Input data - 5000

  • Input units - Square foot (sq ft)

  • Output units - Square metre (sq m)

  • Output data - 464.515215

Converts a unit of data to another format.

  • Input data - 2

  • Input units - Megabits (Mb)

  • Output units - Kilobytes (KB)

  • Output data - 250

Converts values from one unit of length to another.

  • Input data - 100

  • Input units - Metres (m)

  • Output units - Yards (yd)

  • Output data - 109.3613298

Converts values from one unit of mass to another.

  • Input data - 100

  • Input units - Kilogram (kg)

  • Output units - Pound (lb)

  • Output data - 220.4622622

Converts 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

Counts 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

Calculates an 8-bit Cyclic Redundancy Check (CRC) value for a given input.

  • Input data - hello 1234

  • Output data - C7

Calculates an 16-bit Cyclic Redundancy Check (CRC) value for a given input.

  • Input data - hello 1234

  • Output data - 57D4

Calculates an 24-bit Cyclic Redundancy Check (CRC) value for a given input.

  • Input data - hello 1234

  • Output data - 3B6473

Calculates an 32-bit Cyclic Redundancy Check (CRC) value for a given input.

  • Input data - hello 1234

  • Output data - 7ED8D648

Obfuscates all digits of a credit card number except for the last 4 digits.

  • Input data - 1111222233334444

  • Output data - ************4444

Converts 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 - ,

  • 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" } ]

Defangs an IP address to prevent it from being recognized.

  • Input data - 192.168.1.1

  • Output data - 192[.]168[.]1[.]1

Defangs 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

Divides 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

Analyzes 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

Escapes specific characters in a string

  • Input data - She said, "Hello, world!"

  • Escape Level - Special chars

  • Escape Quote - "

  • JSON compatible -false

  • Output data - She said, \"Hello, world!\"

Extracts 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

Makes defanged IP addresses valid.

  • Input data - 192[.]168[.]1[.]1

  • Output data - 192.168.1.1

Makes defanged URLs valid.

  • Input data - hxxps://example[.]com

  • Escape Dots - true

  • Escape HTTP - true

  • Escape ://* - false

  • Process Type - Everything

  • Output data - https://example.com

Splits 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 - Line feed

  • Regex - ^Error

  • Invert - false

  • Output data -

Error: File not found Error: Disk full

Finds 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

  • Output data - The server encountered an issue while processing your request.

Decodes data from a Base64 string back into its raw format.

  • Input data - SGVsbG8sIE9udW0h

  • Strict Mode - true

  • Output data - Hello, Onum!

Converta 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

Converts 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

Converts an IP address (either IPv4 or IPv6) to its hexadecimal representation.

  • Input data - 192.168.1.1

  • Output data - c0a80101

Reduces 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"}}

Converts 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

Decodes the payload in a JSON Web Token string.

  • Input data - eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiaWF0IjoxNTE2MjM5MDIyfQ.SflKxwRJSMeKKF2QT4fwpMeJf36POk6yJV_adQssw5c

  • Output data - {"sub":"1234567890","name":"John Doe","iat":1516239022}

Generates a Keccak cryptographic hash function from a given input.

  • Input data - Hello World !

  • Size - 256

  • Output data -3ea2f1d0abf3fc66cf29eebb70cbd4e7fe762ef8a09bcc06c8edf641230afec0

Produces a MD2 hash string from a given input.

  • Input data - Hello World!

  • Output data - 315f7c67223f01fb7cab4b95100e872e

Produces a MD4 hash string from a given input.

  • Input data - Hello World!

  • Output data -b2a5cc34fc21a764ae2fad94d56fadf6

Produces a MD5 hash string from a given input.

  • Input data - Hello World!

  • Output data -d41d8cd98f00b204e9800998ecf8427e

Calculates the median of given values.

  • Input data - 10, 5, 20, 15, 25

  • Delimiter - ,

  • Output data - 15

Calculates the result of the multiplication of given values.

  • Input data - 2, 3, 5

  • Delimiter - ,

  • Output data - 30

Pads 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

Parses a string and returns an integer of the specified base.

  • Input data - 100

  • Base - 2

  • Output data -4

Takes 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 | | +---------+-------+-------+-------+

Extracts or manipulates parts of your input strings that match a specific regular expression pattern.

  • Input data - 100

  • Base - 2

  • Output data -4

Removes 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

Reverses the order of the characters in a string.

  • Input data - Hello World!

  • Reverse mode - Character

  • Output data - !dlroW olleH

Returns the SHA0 hash of a given string.

  • Input data - Hello World!

  • Output data - 1261178ff9a732aacfece0d8b8bd113255a57960

Returns the SHA1 hash of a given string.

  • Input data - Hello World!

  • Output data - 2ef7bde608ce5404e97d5f042f95f89f1c232871

Returns the SHA2 hash of a given string.

  • Input data - Hello World!

  • Size - 512

  • Output data - f4d54d32e3523357ff023903eaba2721e8c8cfc7702663782cb3e52faf2c56c002cc3096b5f2b6df870be665d0040e9963590eb02d03d166e52999cd1c430db1

Returns the SHA3 hash of a given string.

  • Input data - Hello World!

  • Size - 512

  • Output data - 32400b5e89822de254e8d5d94252c52bdcb27a3562ca593e980364d9848b8041b98eabe16c1a6797484941d2376864a1b0e248b0f7af8b1555a778c336a5bf48

Returns the SHAKE hash of a given string.

  • Input data - Hello World!

  • Capacity - 256

  • Size - 512

  • Output data - 35259d2903a1303d3115c669e2008510fc79acb50679b727ccb567cc3f786de3553052e47d4dd715cc705ce212a92908f4df9e653fa3653e8a7855724d366137

Shuffles the characters of a given string.

  • Input data - Hello World!

  • Delimiter - Nothing (separate chars)

  • Output data - rH Wl!odolle

Returns the SM3 cryptographic hash function of a given string.

  • Input data - Hello World!

  • Length - 64

  • Output data - 0ac0a9fef0d212aa

Sorts 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

Extracts characters from a given string.

  • Input data - +34678987678

  • Start Index - 3

  • Length - 9

  • Output data - 678987678

Calculates the result of the subtraction of given values.

  • Input data - 10, 5, 2

  • Delimiter - Comma

  • Output data - 3

Calculates the total of given values.

  • Input data - 10, 5, 2

  • Delimiter - Comma

  • Output data - 17

Swaps the case of a given string.

  • Input data - Hello World!

  • Output data - hELLO wORLD!

Encodes raw data into an ASCII Base64 string.

  • Input data - Hello, Onum!

  • Output data - SGVsbG8sIE9udW0h

Converts an integer to its corresponding hexadecimal code.

  • Output data - Hello World!

  • Delimiter - Space

  • Input data - 48 65 6c 6c 6f 20 57 6f 72 6c 64

Converts the characters of a string to lower case.

  • Input data - Hello World!

  • Output data - hello world!

Transforms a string representing a date into a timestamp.

  • Input data - 2006-01-02

  • Format - DateOnly

  • Output data - 2006-01-02T00:00:00Z

Parses a datetime string in UTC and returns the corresponding UNIX timestamp.

  • Input data - Mon 1 January 2001 11:00:00

  • Unit - Seconds

  • Output data - 978346800

Converts the characters of a string to upper case.

  • Input data - Hello World!

  • Output data - HELLO WORLD!

Converts a date and time from one format to another.

  • Input data - 2024-10-24T14:11:13Z

  • Input Format - 2006-01-02T15:04:05Z

  • Input Timezone - UTC+1

  • Output Format - 02/01/2006 15:04:05

  • Output Timezone - UTC+8

  • Output data - 24/10/2024 21:11:13

Removes escape characters from a given string.

  • Input data - She said, \"Hello, world!\"

  • Output data - She said, "Hello, world!"

Decodes 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!

Encodes a URL-decoded string back to its original URL format,

  • Input data - https://example.com/search?q=Hello World!

  • Output data - ttps%3A%2F%2Fexample.com%2Fsearch%3Fq%3DHello+World%21

Last updated

Was this helpful?