I am working on an example file that contains names that have special characters.
For example: FranciscoDA~azValladares
How can I separate it into columns First name and Last name with these cases?
Thank you for your advices!
Hey @NganDao13 , maybe this can help you?
regex: (\u+[^A-Z]*)
use this as case sensitive in tokenize mode
it will parse anything starting with capital letters, followed by anything that is not a capital letter until it finds another capital letter