Text compare in Spotfire

[Viji Dade]

I have a requirement where I need to compare two string columns in a data table and show or highlight the difference in text in another column. Can we do this a calculated column or through R script

[Fabian Duerr]

There are various R packages to work with strings. For example stringr or stringi

https://stringr.tidyverse.org/

https://cran.r-project.org/web/packages/stringi/stringi.pdf

To detect if there are any differences between strings, I can also recommend the stringdist package:

https://cran.r-project.org/web/packages/stringdist/stringdist.pdf