+1
I have a user's forename and surname in the combination ‘Surname, Forename’ and I’d like to:
I’ve tried some regular expressions found in searching online but these either return an empty value or ‘false’. I have no previous experience in regular expressions.
Any ideas?
Thank you.
Best answer by feckinirish
View originalHello there.
I suggest you first try using split with the comma as delimiter (so don’t remove it) and save first / lastname as separate variables. you can set the comma as a delimiter by making it a variable (“set” or use the ascii command 44). You can then create a new variable that uses these found variables ($firstname$ $lastname$ in any order you set them in your new variable. Use a dollarsign ($) to select variables that were previously created - look for a grey thunderbolt in the advanced command screen.
Blue thunderbolt means: you can create a new variable (no need for dollar) or select one that was previously created).
Should you want to play with regular expressions:
Online help:
Nintex RPA lets you test you regex inside the advanced command (e.g. find) and you can run it on a variable
Good luck.
+20
Hi
Did this response help solve your question?
+1
Hello there.
I suggest you first try using split with the comma as delimiter (so don’t remove it) and save first / lastname as separate variables. you can set the comma as a delimiter by making it a variable (“set” or use the ascii command 44). You can then create a new variable that uses these found variables ($firstname$ $lastname$ in any order you set them in your new variable. Use a dollarsign ($) to select variables that were previously created - look for a grey thunderbolt in the advanced command screen.
Blue thunderbolt means: you can create a new variable (no need for dollar) or select one that was previously created).
Should you want to play with regular expressions:
Online help:
Nintex RPA lets you test you regex inside the advanced command (e.g. find) and you can run it on a variable
Good luck.
TBH Gobitz I didn’t understand the recommended process. What I did is outlined in the images below with the results.
Step 1
Log to instance
Workflow test
I tried ‘^[^,]*,([^,]+)’ (Thanks Chat GPT) which returned an empty first variable when using the SPLIT operation and the full input text when using the EXTRACT operation.
+20
Hi
Is this question now resolved?
+1
No, though I’ve found an internal workaround.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
