How to Filter the spreadsheet data based on case sensitivity.

book

Article ID: KB0071035

calendar_today

Updated On:

Products	Versions
Spotfire Statistica	14.x and higher

Description

If we enter Case-sensitive text data in the Spreadsheet, we can filter the duplicates using the RE_SEARCH Function.
Please find the below steps with a sample workspace attached which will help you to filter the data on the basis of Case sensitivity.

Issue/Introduction

Workaround to Filter the Data in the spreadsheet on basis of Case Sensitivity.

Environment

Windows OS

Resolution

Steps to Follow:

1. Open a new spreadsheet and enter Case Sensitive duplicate text values.

User-added image

2. Declare the function in Sensitive column:

3. Declare the function in Insensitive column:

4. Add the spreadsheet to the workspace and add the Filter function in the workspace.

5. Declare the Variables and Run the workspace, Output spreadsheet will have data without duplicates.

User-added image

If you still have any queries then you can contact us at https://support.tibco.com.

NOTE: Other Functions that uses Regular Expressions are "RE_MATCH", and "RE_REPLACE".