How to reverse a string value in TIBCO Spotfire Analyst, using TERR_String().
Article ID: KB0081665
Updated On:
| Products | Versions |
|---|---|
| Spotfire Enterprise Runtime for R | All supported versions |
Description
In Spotfire Analyst, if you have a Spotfire column of DataType "String" and you want to reverse the order of characters in each entry in the column, then you can use the expression provided below in the Resolution and in the attached analysis file (Filename: ReverseString.dxp).
For example, this can be used to convert the string "Apple" to "elppA".
For example, this can be used to convert the string "Apple" to "elppA".
Issue/Introduction
How to reverse a string value in TIBCO Spotfire Analyst, using TERR_String().
Environment
All Supported OS
Resolution
In TIBCO Spotfire Analyst, create a calculated column that uses the following expression:
- TERR_String("output=sapply(lapply(strsplit(input1, NULL),rev),paste,collapse='')",[Column Name])
NOTE: This expression function is based on a TIBCO Enterprise Runtime for R (TERR) script, so it requires access to a TIBCO Enterprise Runtime for R statistics engine to work. TERR is included in the Professional/Analyst/Desktop Client starting in version 5.0, so there are no additional requirements for this to work in those clients. For this to work in Spotfire Web Player or Automation Services, you need to configure Spotfire to point to a TIBCO Spotfire Statistics Services (TSSS) server instance. This TSSS URL must be configured according to the TIBCO Spotfire Statistics Services Installation and Administration Manual located at the following:
- URL: https://docs.tibco.com/products/tibco-spotfire-statistics-services
- Chapter: Configuring TIBCO Spotfire to use TIBCO Spotfire Statistics Services
Note also that TIBCO Spotfire Statistics Services (TSSS) is a separate product, distinct from Spotfire Server, the Spotfire desktop client, Spotfire Web Player, and Spotfire Automation Services.
Additional Information
Attachments
Feedback
Yes
No
Powered by
