i will import in perfectableplan too, but I need to import it in other programs too. As in perfectable plan we have groups and couples in these groups. I need to retain all informations. At the same time i’d like to obtain a consistent couple name.
@Anonymous As usual, much more elegant solution. With unfill and slide where I build IF statement and had to remove a lot of intermediate fields.
1 Like
Is beautiful to learn software functions through your exceptional solutions 
PerfectTablePlan is very flexible in the column structures it can import as guest lists:
But I understand other software might not be,
@Anonymous
That is more elegant than our solution.
2 Likes
For dividing Full Names into Title, first name and Second name I found a workaround splitting names and then joining last fields except the first two. it worked flawlessly. i’m a bit upstet that I failed to use regex to obtain the same thing in an unique passage.
i used Anonymous transformations at last Thanks again to everybody
There are a lot of resources online to learn about regular expressions. Some are linked on our resources page.
Here you go, it caters your requirement that second names can be composite.
Transform file.
SplitingName.transform (2.7 KB)
2 Likes
Names are tricky. People can have multiple first names and/or multiple last names. Pre-nominal titles, post nominal titles. Last names can include ‘particules’. I don’t think any approach will be 100% accurate.
1 Like
Thanks a lot! elegant and simple