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

[LIM CHANGYEOP]

For example

Each line can be preceded by a space or a special character.

 

Data

orange ##@%^^%$$ shop1

apple $@ !#> shop2

banana^&*((*& shop3

[Fabian Duerr]

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/