goude/Count Characters in Tibco Spotfire String

Last active December 12, 2018 16:37

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/goude/8332236.js"></script>
Save goude/8332236 to your computer and use it in GitHub Desktop.

Download ZIP

How do you create a calculated column in Tibco Spotfire to count occurences of a specific character in a string from another column?

Raw

Count Characters in Tibco Spotfire String

	Len(RXReplace([Column 1], "[^x]", "", "g"))

	Replace x with the character you wish to count.

freiermuth commented Dec 12, 2018

Thank you for this, was incredible helpful!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment