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

1

To enable alpha -numeric filter add an alpha-numeric field to the Category Field.

2

The column added to the data field can contain both numeric and alphanumeric values, which can be displayed using a slider.

3

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.

4

If combined with other categories, it displays as a dropdown list in the Facet Filter View.

5

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.

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.

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

Image 3: Alpha Numeric Regex

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.

  

  Image 6: Extracting the Last Digit

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