{"transforms":[{"category":"date","help_text":"Change a date or time to a new format or style","key":"date.formatting","label":"Format","name":"formatting","type":"transform"},{"category":"date","help_text":"Get the duration between two dates in days, hours, minutes, and seconds along with checking if they are the same.","key":"date.compare_dates","label":"Compare Dates","name":"compare_dates","type":"transform"},{"category":"date","help_text":"Manipulate a date and/or time by adding/subtracting days, months, years, hours, minutes, seconds.","key":"date.manipulate","label":"Add/Subtract Time","name":"manipulate","type":"transform"},{"category":"number","help_text":"Format a number as a currency.","key":"number.currency","label":"Format Currency","name":"currency","type":"transform"},{"category":"number","help_text":"Format a number to a new style. Does not perform any rounding or padding of the number.","key":"number.formatting","label":"Format Number","name":"formatting","type":"transform"},{"category":"number","help_text":"Perform mathematical operations on value(s). If you have [line items](https://zapier.com/help/create/basics/use-line-items-in-zaps), use [Spreadsheet-Style Formula](https://zapier.com/help/create/format/use-spreadsheet-style-formula-functions-in-zaps) instead.","key":"number.math","label":"Perform Math Operation (Legacy)","name":"math","type":"transform"},{"category":"number","help_text":"Transform a number with a spreadsheet-style formula.","key":"number.spreadsheet_formula","label":"Spreadsheet-Style Formula","name":"spreadsheet_formula","type":"transform"},{"category":"number","help_text":"Perform mathematical operations on value(s). If you have [line items](https://zapier.com/help/create/basics/use-line-items-in-zaps), use [Spreadsheet-Style Formula](https://zapier.com/help/create/format/use-spreadsheet-style-formula-functions-in-zaps) instead.","key":"number.math_v2","label":"Perform Math Operation","name":"math_v2","type":"transform"},{"category":"number","help_text":"Format a phone number to a new style. Phone number validation is on by default","key":"number.phone","label":"Format Phone Number","name":"phone","type":"transform"},{"category":"number","help_text":"Format a phone number to a new style. Phone number validation is on by default","key":"number.phone_v2","label":"Format Phone Number","name":"phone_v2","type":"transform"},{"category":"number","help_text":"Use the options below to create a random number between the lower and upper range. You can also specify the number of decimal points.","key":"number.random_number","label":"Random Number","name":"random_number","type":"transform"},{"category":"string","help_text":"Capitalize the first character of every word.","key":"string.capitalize","label":"Capitalize","name":"capitalize","type":"transform"},{"category":"string","help_text":"Return a default value if the text is empty.","key":"string.default_value","label":"Default Value","name":"default_value","type":"transform"},{"category":"string","help_text":"Return a default value if the text is empty. If a line-item field is provided, a line-item field is returned.","key":"string.default_value_v2","label":"Default Value","name":"default_value_v2","type":"transform"},{"category":"string","help_text":"Find and copy an email address out of a text field. Finds the first email address only.","key":"string.email_extract","label":"Extract Email Address","name":"email_extract","type":"transform"},{"category":"string","help_text":"Find and copy an email address out of a text field. Finds the first email address only.","key":"string.email_extract_v2","label":"Extract Email Address","name":"email_extract_v2","type":"transform"},{"category":"string","help_text":"Replace all non-ASCII characters.","key":"string.encode_ascii","label":"Convert to ASCII","name":"encode_ascii","type":"transform"},{"category":"string","help_text":"Find the first position of a value in the text, -1 if the value is not found","key":"string.find","label":"Find","name":"find","type":"transform"},{"category":"string","help_text":"Convert valid HTML to Markdown text","key":"string.htmlmarkdown","label":"Convert HTML to Markdown","name":"htmlmarkdown","type":"transform"},{"category":"string","help_text":"Count the number of characters in the text","key":"string.length","label":"Length","name":"length","type":"transform"},{"category":"string","help_text":"Convert all characters in a string to lowercase","key":"string.lower_case","label":"Lowercase","name":"lower_case","type":"transform"},{"category":"string","help_text":"Convert Markdown text into valid HTML","key":"string.markdown","label":"Convert Markdown to HTML","name":"markdown","type":"transform"},{"category":"string","help_text":"Find and copy a number in text.","key":"string.number_extract","label":"Extract Number","name":"number_extract","type":"transform"},{"category":"string","help_text":"Find a match for a regular expression pattern. Returns all matched groups with start and end position. Default is first match and no flags.","key":"string.re_extract","label":"Extract Pattern","name":"re_extract","type":"transform"},{"category":"string","help_text":"Find and copy a complete phone number out of a text field. Finds the first phone number only.","key":"string.phone_extract","label":"Extract Phone Number","name":"phone_extract","type":"transform"},{"category":"string","help_text":"Pluralize any English word (frog turns into frogs; child turns into children)","key":"string.pluralize","label":"Pluralize","name":"pluralize","type":"transform"},{"category":"string","help_text":"Replace all instances of any character, word or phrase in the text with another character, word or phrase.","key":"string.replace","label":"Replace","name":"replace","type":"transform"},{"category":"string","help_text":"Split the text on a character or word and return a segment","key":"string.split","label":"Split Text","name":"split","type":"transform"},{"category":"string","help_text":"Split text into chunks to accommodate AI prompts based on the type of model you use. You can set your output as line items or separate fields.More on using this [transform.](https://help.zapier.com/hc/en-us/articles/15406374106765)","key":"string.split_into_chunks","label":"Split Text into Chunks for AI Prompts (beta)","name":"split_into_chunks","type":"transform"},{"category":"string","help_text":"Transform text with a spreadsheet-style formula.","key":"string.spreadsheet_formula","label":"Spreadsheet-Style Formula","name":"spreadsheet_formula","type":"transform"},{"category":"string","help_text":"Remove every HTML tag to leave just the plain text.","key":"string.strip_html","label":"Remove HTML Tags","name":"strip_html","type":"transform"},{"category":"string","help_text":"Convert a name into the name of a Superhero.","key":"string.superhero","label":"Superhero Name","name":"superhero","type":"transform"},{"category":"string","help_text":"Convert all characters in a string to titlecase","key":"string.titlecase","label":"Titlecase","name":"titlecase","type":"transform"},{"category":"string","help_text":"Removes leading and trailing whitespace.","key":"string.trim_space","label":"Trim Whitespace","name":"trim_space","type":"transform"},{"category":"string","help_text":"Limit your text to a specific character length, and delete anything over that.","key":"string.truncate","label":"Truncate","name":"truncate","type":"transform"},{"category":"string","help_text":"Capitalize every character in the text","key":"string.upper_case","label":"Uppercase","name":"upper_case","type":"transform"},{"category":"string","help_text":"Decodes text from URLs.","key":"string.url_decode","label":"URL Decode","name":"url_decode","type":"transform"},{"category":"string","help_text":"Encodes text for use in URLs.","key":"string.url_encode","label":"URL Encode","name":"url_encode","type":"transform"},{"category":"string","help_text":"Find and copy a web URL out of a text field. Finds the first URL only.","key":"string.url_extract","label":"Extract URL","name":"url_extract","type":"transform"},{"category":"string","help_text":"Find and copy a web URL out of a text field. Finds the first URL only.","key":"string.url_extract_v2","label":"Extract URL v2","name":"url_extract_v2","type":"transform"},{"category":"string","help_text":"Find and copy a web URL out of a text field. Finds the first URL only.","key":"string.url_extract_v3","label":"Extract URL","name":"url_extract_v3","type":"transform"},{"category":"string","help_text":"Count the number of words in a string.","key":"string.word_count","label":"Word Count","name":"word_count","type":"transform"},{"category":"util","help_text":"'e' appended to [a,b,c,d] becomes [a,b,c,d,e]. More on line-items [here](https://help.zapier.com/hc/en-us/articles/25380258676109-Use-Formatter-to-split-text-in-Zaps#h_01JAG1PGX8EX39WRGKK2JVJ96V).","key":"util.append","label":"Append to Line-item","name":"append","type":"transform"},{"category":"util","help_text":"Pick the first, last, random, or n-th value that is not empty.","key":"util.choose","label":"Pick from list","name":"choose","type":"transform"},{"category":"util","help_text":"Import a CSV file from a public URL, File field from another Zap step, or entered text.  Limited to 150k (around 1000 rows).  Output is a line-item field for each column, and a text field with CSV file contents.  When you do your Test Step, you'll only see the first 50 rows of your CSV file, but when your Zap runs all rows will be processed. More on importing CSV files [here.](https://zapier.com/help/create/format/import-csv-files-into-zaps)","key":"util.import_csv","label":"Import CSV File (Legacy)","name":"import_csv","type":"transform"},{"category":"util","help_text":"Import a CSV file from a public URL, File field from another Zap step, or entered text.  Limited to 150k (around 1000 rows).  Output is a line-item field for each column, and a text field with CSV file contents.  When you do your Test Step, you'll only see the first 50 rows of your CSV file, but when your Zap runs all rows will be processed. More on importing CSV files [here.](https://zapier.com/help/create/format/import-csv-files-into-zaps)","key":"util.import_csv_v2","label":"Import CSV File","name":"import_csv_v2","type":"transform"},{"category":"util","help_text":"Convert comma delimited text or values to line-item(s). 'a,b,c,d' becomes [a,b,c,d]. Append or prepend to existing line-items by mapping them into the same field as comma separated text or single values. For details, learn more about [Line-items with Formatter](https://help.zapier.com/hc/en-us/articles/25380258676109-Use-Formatter-to-split-text-in-Zaps#h_01JAG1PGX8EX39WRGKK2JVJ96V).","key":"util.line_itemizer","label":"Line Itemizer (Create/Append/Prepend)","name":"line_itemizer","type":"transform"},{"category":"util","help_text":"Convert a line-item to delimited text. [a,b,c,d] becomes 'a,b,c,d'. More on line-items [here](https://help.zapier.com/hc/en-us/articles/25380258676109-Use-Formatter-to-split-text-in-Zaps#h_01JAG1PGX8EX39WRGKK2JVJ96V).","key":"util.lineitem_to_string","label":"Line-item to Text","name":"lineitem_to_string","type":"transform"},{"category":"util","help_text":"Convert a line-item to delimited text. [a,b,c,d] becomes 'a,b,c,d'. Also returns  each element of the line-item as a separate field. More on line-items [here](https://help.zapier.com/hc/en-us/articles/25380258676109-Use-Formatter-to-split-text-in-Zaps#h_01JAG1PGX8EX39WRGKK2JVJ96V).","key":"util.lineitem_to_string_v2","label":"Line-item to Text","name":"lineitem_to_string_v2","type":"transform"},{"category":"util","help_text":"Given a key and table - find the matching value.","key":"util.lookup","label":"Lookup Table","name":"lookup","type":"transform"},{"category":"util","help_text":"Convert comma delimited text to a line-item. 'a,b,c,d' becomes [a,b,c,d]. More on line-items [here](https://help.zapier.com/hc/en-us/articles/25380258676109-Use-Formatter-to-split-text-in-Zaps#h_01JAG1PGX8EX39WRGKK2JVJ96V).","key":"util.string_to_lineitem","label":"Text to Line-item","name":"string_to_lineitem","type":"transform"}]}