I'm just setting up an import fr our paypal donations and have run into a slight problem. Paypal supply supporters name in one field, not split into first name, surname etc.
After looking at the data, Im going to have to make the assumption that most people supply first name and surname i. e John Smith, so i want to use a Reg Ex to split this field into 2.
Assuming i need 2 expressions, 1 to return everything from the left, up to the first space and one that returns everything from the right until the first space.
I've been trying to put a reg ex together, and i think it should be something like [^\S+], but its not working properly!
can anyone help?! Thanks in advance