How to Filter the spreadsheet data based on case sensitivity.

How to Filter the spreadsheet data based on case sensitivity.

book

Article ID: KB0071035

calendar_today

Updated On: 09-15-2023

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.



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.




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".

Attachments

How to Filter the spreadsheet data based on case sensitivity. get_app