How to Filter the spreadsheet data based on case sensitivity.
Article ID: KB0071035
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.
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
Feedback
Yes
No
Powered by
