Clean up names include special characters

[NganDao13]

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!

[dwstada]

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

[binuacs]

@NganDao13 try

REGEX_Replace([name], '[^ -~]', '')