> For the complete documentation index, see [llms.txt](https://docs.inforiver.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.inforiver.com/super-filter/filter-types/6.-alpha-numeric-filter.md). # 6. Alpha Numeric Filter The **Alpha-Numeric Filter** feature enables users to include and filter data containing both letters and numbers. This provides a flexible way to refine data selections based on alpha-numeric fields. ## How to use Alpha Numeric Filter {% stepper %} {% step %} To enable alpha -numeric filter add an alpha-numeric field to the **Category** Field. {% endstep %} {% step %} The column added to the data field can contain both **numeric** and **alphanumeric** values, which can be displayed using a **slider.** {% endstep %} {% step %} If an alpha-numeric field is the **only category** added, the filter appears as a **slider** in the visual.

Image 1: Alpha numeric slider when show fixed label is enabled.

{% endstep %} {% step %} If combined with other categories, it displays as a **dropdown list** in the **Facet Filter View**. {% endstep %} {% step %} To enable or disable the alpha-numeric filter slider, navigate to the Format Pane, in the Alpha-Numeric Filter section use the toggle option to switch the slider view on or off. {% endstep %} {% endstepper %} {% hint style="warning" %} Alpha Numeric Filter as slider cannot be combined with other filter types. If multiple columns are added, the visual will automatically switch to Facet Filter mode. {% endhint %} ## Format Pane Settings Configure **General** section under alpha numeric filter settings with the following options: 1. **Range:** * **Between**: Filter data within a specified range. * **Less than or equal to**: Include values below or equal to the selected value. * **More than or equal to**: Include values above or equal to the selected value. 2. **Step**: Use the Step option to set increments size for the slider that make sense for your data. 3. **Label**: Use the toggle button to enable or disable the visibility of the Alpha numeric category label in the visual. 4. **Category Label:** Enable this option to display the selected range of alphanumeric IDs in the header. Configure **Slider Style** section under alpha numeric filter settings with the following options: 1. **Fixed Label**: When enabled, displays a fixed label for typing the start and end range. 2. **Slider Color**: Choose the color of the selected range in slider. 3. **Border Color:** Select the color for the unselected portion of the slider range. 4. **Background Color**: Adjust the background color behind the slider. 5. **Drag Handle Color**: Select the color of the slider handle used to adjust values. 6. **Font Color and Font Style Settings**: Modify the font color and style to Italics, Bold and Underline 7. **Font Size:** Customize the font size of values shown in the alpha numeric filter. At the bottom left of the tile, you’ll find the **Reset to Default** option. Click this to revert all Alpha Numeric Filter settings to their original configuration.

Image 2: Alpha numeric filter settings in Format pane

### Alpha Numeric Regex For users who need to handle complex alpha-numeric patterns and extract specific sets of numbers, a custom regex can be defined. This is useful when dealing with structured alpha-numeric formats where only certain numbers should be considered. #### Steps to Configure Alpha Numeric Regex: 1. Navigate to the **Display Settings** option in the format pane 2. Locate the **Alpha Numeric Regex** text box 3. Enter the custom regex pattern

Here, we explore alphanumeric patterns with examples: #### **1. Default Numeric Extraction with `\d`** By default, the `\d` token is used in regular expressions to extract all numbers from alphanumeric data. The `\d` operation captures individual digits that are not in a continuous sequence. This means that numbers appearing as isolated or broken segments, rather than as part of a long continuous sequence, will be extracted separately.

Image 4: Default Numeric Extraction with `\d`

#### **2. Extracting the First Two Numbers with Regex** To extract the first two numbers from an alphanumeric string using regular expressions, you can use the following pattern: ``` ^\d{2} ``` This pattern matches the first two digits at the beginning of the string: * `^` asserts the position at the start of the string. * `\d` matches any digit (0-9). * `{2}` specifies exactly two occurrences of the preceding digit.

Image 5: Extracting the First Two Numbers with Regex

#### **3. Extracting the Last Digit or Last Two Digits with Regex** * **To extract the last digit** from an alphanumeric string using regular expressions, use the following pattern: ``` \d$ ``` * `\d` matches any digit (0-9). * `$` asserts the position at the end of the string. * **To extract the last two digits** from an alphanumeric string, use the following pattern: ``` \d{2}$ ``` * `\d{2}` matches exactly two digits. * `$` asserts the position at the end of the string.

#### **4. Extracting the Two Middle Numbers with Regex** To extract the two middle numbers from an alphanumeric string, such as `"34AWE27S4D7"`, you can use the following regex pattern (assuming a fixed-length string): ``` (?<=^.{6})\d{2} ``` **Explanation:** * `^` asserts the position at the start of the string. * `.{6}` matches any 6 characters from the beginning. * `(?<=...)` is a positive lookbehind that ensures the match is preceded by exactly 6 characters. * `\d{2}` captures exactly two digits after the first 5 characters. > *Note:* In the provided string `"34AWE27S4D7"`, the two middle numbers are `27`, which appear at the 6th and 7th positions.

Image 7: Extracting the Two Middle Numbers with Regex

--- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://docs.inforiver.com/super-filter/filter-types/6.-alpha-numeric-filter.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.