Tool filter

Upper Cutoff Frequency. Passband Ripple dB. Stopband Atten. Direct Coupled Capacitor Value. Direct Coupled Inductor Value. Additional Settings Component Values. Exact Standard. Capacitor Values. Capacitor Value. Inductor Values. Inductor Value. Simulation Type.

Quickly extract a text snippet of the given length. Find and Replace Text. Quickly find and replace text patterns. Find the Length of Text. Quickly count the number of characters in text. Count Text Lines. Quickly find the number of lines in text. Add Line Numbers. Quickly add a number before every text line. Create an Image from Text. Quickly create an image from text. Generate Zalgo Text. Apply the Zalgo effect to the input text.

Create a Palindrome. Quickly construct a palindrome from plain text. Check if Text is a Palindrome. Quickly test if text is a palindrome. Change Text Case. Quickly switch between various letter cases in text. Convert Text to Uppercase. Quickly convert text letters to uppercase.

Convert Text to Lowercase. Quickly convert text letters to lowercase. Randomize Text Case. Quickly randomize character case in text. Invert Text Case. Quickly invert character case in text.

Convert Spaces to Newlines. Quickly replace spaces with newlines in text. Convert Newlines to Spaces. Quickly replace newlines with spaces in text. Convert Spaces to Tabs. Quickly get tabs instead of spaces in text. Convert Tabs to Spaces. Quickly get spaces instead of tabs in text.

Remove All Whitespace. Quickly clear text from spaces, tabs, and newlines. Remove All Punctuation. Quickly clear text from dots, commas, and similar characters. Quickly extract tag content from HTML code. Extract Text from XML. Quickly extract tag content from an XML document. Extract Text from BBCode.

Quickly extract all textual data from BBCode markup. Quickly extract keys and values from a JSON data structure. Quickly convert text to a JSON string. Quickly convert previously JSON stringified text to plain text.

Slash-escape Text. Quickly escape special symbols in text with slashes. Slash-unescape Text. Quickly remove slashes from previously slash-escaped text. ROT13 Text. Quickly encode or decode text using ROT13 cipher algorithm. ROT47 Text. Quickly encode and decode text with ROT47 cipher algorithm. Generate Text from a RegExp. Quickly create text that matches the given regexp. Extract RegExp Matches from Text.

Quickly find and return all regexp matches. Test Text with a RegExp. Quickly check whether text matches a regular expression. Printf Text. Quickly format text using the printf or sprintf function. Rotate Text. Quickly cyclically rotate text letters to the right or left. Flip Text Vertically. Quickly rewrite text to vertical position. Convert Text to Nice Columns. Quickly format text so that all words are in neat columns.

Convert Nice Columns to Text. Quickly convert data aligned in columns to linear text. Generate Text Unigrams. Quickly create a list of all monograms from text. Generate Text Bigrams. Quickly create a list of all digrams from text. Generate Text N-grams. Quickly create a list of all ngrams from text.

Convert Text to Morse Code. Quickly write the text in Morse code. Convert Morse Code to Text. Quickly decode Morse code to plain text. URL-encode Text. URL-decode Text. Quickly URL-unescape text. HTML-encode Text. Quickly convert all plain text characters to HTML entities. HTML-decode Text. Quickly convert HTML entities to plain text.

Baseencode Text. Quickly encode text to base Basedecode Text. Quickly decode baseencoded text. Convert Text to Binary. Quickly convert plain text to binary text. Convert Binary to Text. Quickly convert binary text to plain text. Convert Text to Octal. Quickly convert plain text to octal text. Convert Octal to Text. Quickly convert octal text to plain text. Convert Text to Decimal. Quickly convert text to decimal values. Convert Decimal to Text. Quickly convert decimal values to text. Convert Text to Hex.

Quickly convert plain text to hexadecimal values. Convert Hex to Text. Quickly convert hexadecimal to readable text. Coming soon These text tools are on the way. Calculate Levenstein Distance. Find Levenstein distance of two text fragments. Tokenize Text. Create a list of all words in text. Lemmatize Text. Lemmatize all words in text. Generate Glitch Text.

Mess up characters in your text. Generate Random Text. Generate text using random words. Introduce Errors in Text. Randomly change letters in text and make mistakes. Convert Text to Code Points.

Convert text characters to their corresponding code points. Convert Code Points to Text. Convert numeric character code points to text. Convert CSV data to plain text columns. Convert plain text columns to a CSV file. Generate Text Trigrams. Filter has a One Tool Example. Visit Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.

Use Filter to select data using a condition. Rows of data that meet the condition are output to the True anchor. Rows of data that do not meet the condition are output to the False anchor. Use the Interface tools to connect to a Question anchor. Available operators depend on the data type of the column you select to filter by. Learn more about Data Types. To build a custom filter condition, enter your expression syntax into the expression editor.

There are also many tools to assist with building Custom filter conditions. See Expression Editor Tips. These tools are available within the expression editor to assist with building Custom filter conditions. Once you have built an expression you can save it for later use. Select the save icon. Enter your expression name and select Save. According to the condition of the above Basic filter, rows with a CustomerID value greater than 30 are output to the True anchor.

According to the condition of the above Basic filter, rows with a LastName value that is not null missing are output to the True anchor. According to the condition of the above Basic filter, rows with a JoinDate that is less than or equal to today's date are output to the True anchor. According to the condition of the above Custom filter, rows with a JoinDate that is greater than or equal to the FirstPurchaseDate are output to the True anchor.

According to the condition of the above Custom filter, rows where the region is either South or contains the word West, are output to the True anchor.