Jump to content

Please tell me how to split fruit and shop when column values contain both spaces and special characters.


Recommended Posts

You can useRXExtract([your.column],"[[:alnum]]+",1) andRXExtract([your.column],"[[:alnum]]+",2) to get two new columns. Probably you need a more sophisticated solution for your real data. Then you can learn more about regular expressions.


Also check out stringr if you need more than the basic Spotfire RXExtract function


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...