Jump to content

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


LIM CHANGYEOP

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.

https://stat.ethz.ch/R-manual/R-devel/library/base/html/regex.html

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

https://stringr.tidyverse.org/

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...