Field Transformation Operations

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

Operation	Description	Example
Byte to Human Readable	Converts a size in bytes to a human-readable string.	Input data - 134367 Output data - 131.22 KiB
Convert Area	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
Convert Data Units	Converts a unit of data to another format.	Input data - 2 Input units - Megabits (Mb) Output units - Kilobytes (KB) Output data - 250
Convert Distance	Converts values from one unit of length to another.	Input data - 100 Input units - Metres (m) Output units - Yards (yd) Output data - 109.3613298
Convert Mass	Converts values from one unit of mass to another.	Input data - 100 Input units - Kilogram (kg) Output units - Pound (lb) Output data - 220.4622622
Convert Speed	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
Count Occurrences	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
CRC8 Checksum	Calculates an 8-bit Cyclic Redundancy Check (CRC) value for a given input.	Input data - hello 1234 Output data - C7
CRC16 Checksum	Calculates an 16-bit Cyclic Redundancy Check (CRC) value for a given input.	Input data - hello 1234 Output data - 57D4
CRC24 Checksum	Calculates an 24-bit Cyclic Redundancy Check (CRC) value for a given input.	Input data - hello 1234 Output data - 3B6473
CRC32 Checksum	Calculates an 32-bit Cyclic Redundancy Check (CRC) value for a given input.	Input data - hello 1234 Output data - 7ED8D648
Credit Card Obfuscator	Obfuscates all digits of a credit card number except for the last 4 digits.	Input data - 1111222233334444 Output data - ************4444
CSV to JSON	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" } ]
Defang IP Address	Defangs an IP address to prevent it from being recognized.	Input data - 192.168.1.1 Output data - 192[.]168[.]1[.]1
Defang URL	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
Divide Operation	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
Encode URI	Analyzes a URI into its individual components.	Input data - https://user:[e-mail]: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
Escape String	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!\"
Extract IP Address	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
Fang IP Address	Makes defanged IP addresses valid.	Input data - 192[.]168[.]1[.]1 Output data - 192.168.1.1
Fang URLs	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
Filter	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
Find and Replace	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.
From Base64	Decodes data from a Base64 string back into its raw format.	Input data - SGVsbG8sIE9udW0h Strict Mode - true Output data - Hello, Onum!
From Hex	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
From UNIX Timestamp	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
IP to hexadecimal	Converts an IP address (either IPv4 or IPv6) to its hexadecimal representation.	Input data - 192.168.1.1 Output data - c0a80101
JSON Minify	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"}}
JSON to CSV	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
JWT Decode	Decodes the payload in a JSON Web Token string.	Input data - eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiaWF0IjoxNTE2MjM5MDIyfQ.SflKxwRJSMeKKF2QT4fwpMeJf36POk6yJV_adQssw5c Output data - {"sub":"1234567890","name":"John Doe","iat":1516239022}
Keccak	Generates a Keccak cryptographic hash function from a given input.	Input data - Hello World ! Size - 256 Output data -3ea2f1d0abf3fc66cf29eebb70cbd4e7fe762ef8a09bcc06c8edf641230afec0
List to String	Converts 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
MD2	Produces a MD2 hash string from a given input.	Input data - Hello World! Output data - 315f7c67223f01fb7cab4b95100e872e
MD4	Produces a MD4 hash string from a given input.	Input data - Hello World! Output data -b2a5cc34fc21a764ae2fad94d56fadf6
MD5	Produces a MD5 hash string from a given input.	Input data - Hello World! Output data -d41d8cd98f00b204e9800998ecf8427e
Median	Calculates the median of given values.	Input data - 10, 5, 20, 15, 25 Delimiter - , Output data - 15
Multiply Operation	Calculates the result of the multiplication of given values.	Input data - 2, 3, 5 Delimiter - , Output data - 30
Pad Lines	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
Parse Int	Parses a string and returns an integer of the specified base.	Input data - 100 Base - 2 Output data -4
Parse UNIX File Permissions	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 | | +---------+-------+-------+-------+
Regex	Extracts or manipulates parts of your input strings that match a specific regular expression pattern.	Input data - 100 Base - 2 Output data -4
Remove Whitespace	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
Reverse String	Reverses the order of the characters in a string.	Input data - Hello World! Reverse mode - Character Output data - !dlroW olleH
SHA0	Returns the SHA0 hash of a given string.	Input data - Hello World! Output data - 1261178ff9a732aacfece0d8b8bd113255a57960
SHA1	Returns the SHA1 hash of a given string.	Input data - Hello World! Output data - 2ef7bde608ce5404e97d5f042f95f89f1c232871
SHA2	Returns the SHA2 hash of a given string.	Input data - Hello World! Size - 512 Output data - f4d54d32e3523357ff023903eaba2721e8c8cfc7702663782cb3e52faf2c56c002cc3096b5f2b6df870be665d0040e9963590eb02d03d166e52999cd1c430db1
SHA3	Returns the SHA3 hash of a given string.	Input data - Hello World! Size - 512 Output data - 32400b5e89822de254e8d5d94252c52bdcb27a3562ca593e980364d9848b8041b98eabe16c1a6797484941d2376864a1b0e248b0f7af8b1555a778c336a5bf48
Shake	Returns the SHAKE hash of a given string.	Input data - Hello World! Capacity - 256 Size - 512 Output data - 35259d2903a1303d3115c669e2008510fc79acb50679b727ccb567cc3f786de3553052e47d4dd715cc705ce212a92908f4df9e653fa3653e8a7855724d366137
Shuffle	Shuffles the characters of a given string.	Input data - Hello World! Delimiter - Nothing (separate chars) Output data - rH Wl!odolle
SM3	Returns the SM3 cryptographic hash function of a given string.	Input data - Hello World! Length - 64 Output data - 0ac0a9fef0d212aa
Sort	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
String to List	Converts 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]
Substring	Extracts characters from a given string.	Input data - [phone] Start Index - 3 Length - 9 Output data - 678987678
Subtract Operation	Calculates the result of the subtraction of given values.	Input data - 10, 5, 2 Delimiter - Comma Output data - 3
Sum Operation	Calculates the total of given values.	Input data - 10, 5, 2 Delimiter - Comma Output data - 17
Swap Case	Swaps the case of a given string.	Input data - Hello World! Output data - hELLO wORLD!
To Base64	Encodes raw data into an ASCII Base64 string.	Input data - Hello, Onum! Output data - SGVsbG8sIE9udW0h
To Hex	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
To Lower Case	Converts the characters of a string to lower case.	Input data - Hello World! Output data - hello world!
To Timestamp	Transforms a string representing a date into a timestamp.	Input data - 2006-01-02 Format - DateOnly Output data - 2006-01-02T00:00:00Z
To UNIX Timestamp	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
To Upper Case	Converts the characters of a string to upper case.	Input data - Hello World! Output data - HELLO WORLD!
Translate Datetime Format	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
Unescape String	Removes escape characters from a given string.	Input data - She said, \"Hello, world!\" Output data - She said, "Hello, world!"
URL Decode	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!
URL Encode	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